ODBC/Methods/Config
< ODBC
Jump to navigation
Jump to search
ODBC: Data Sources | Handles | Data Driver | Error Messages | API: Connect Read Update Create Bulk Insert Config
Options to modify default behavior
format is:
ddconfig key;value {;key;value...}
- data type of decimal numbers
ddconfig 'numeric';mode NB. number is 0 to 1
mode:
0 decimal numbers returned as string 1 decimal numbers returned double
default 0 (string)
- precision of fractional second in timestamp fields
ddconfig 'frasecond';number NB. number is 0 to 9
default 0 (no fractional second)
- timestamp field format
ddconfig 'dayno';mode NB. mode is 0, 1 or 2
mode:
0 string '2018-12-24 10:34:56.234' 1 J dayno 79980.567 2 Jd epoch date 598962896234000000
default 0 (string)