Main Menu

KB#00649-'Date Column Suffix' of ODBC Administrator Data Source Setup is Case Sensitive

Title:

'Date Column Suffix' of ODBC Administrator Data Source Setup is Case Sensitive

Description:

The ODBC driver will translate dates that are stored as Julian dates into a recognizable date format. To accomplish this, the data dictionary field column suffix must be passed to the ODBC driver. In the ODBC Administrator, click on the data source and select the Advance or Configure option. Enter the same column suffix used for the column definition in the Data Dictionary in the Column Suffix field. This will allow the driver to automatically translate columns that end with the entered suffix from a Julian value to a human readable format (MM/DD/YY usually). 

However, the suffix information is case sensitive, so the column suffix must be entered in exactly the same case as the column definition in the dictionary. 

Note that this applies to date translations for both OEM date types and Julian dates 

Resolution:

For example, if the dictionary has a column defined in all upper case as INVOICE_DATE, the entry in the Date Column Suffix must contain DATE. 

FOR REVISION 2.x ONLY: 
If the dictionary has definitions for both DATE and date, then both must be entered into the Date Column Suffix field, separated by commas. 



Last Modified: 10/07/1999 Product: BASIS ODBC Driver Operating System: Windows

BASIS structures five components of their technology into the BBx Generations.

  Google+ View BASIS LinkedIN ProfileVisit our Twitter Feed Check out our Facebook Public Profile Click to View the BASIS youTube channel