ODBC/Methods/Config

From J Wiki
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)