Chris, I included a fragment from odbc.ijs for your reference. As you can see date and time (91 92?) are not supported. Furthermore blob data type (eg. _1 and _4) will never be supported in ddfch, as it is impossible to allocate (2G or more)*rowsize of memory buffer for each blob column.
NB. 3) All the supported datatypes can be fetched with (ddfet) only NB. fixed length and short datatypes (*'ed) can be returned by (ddfch). NB. This table is critical to the operation of this system. ALTER WITH CARE! SQL_SUPPORTED_NAMES=: (];._2) 0 : 0 0 NB. SQL types C default type Into J as Bytes Conversions SQL_CHAR=: 1['*' NB. SQL_C_CHAR SQL_C_CHAR 1 ] SQL_NUMERIC=: 2['*' NB. SQL_C_CHAR SQL_C_CHAR 1 ] SQL_DECIMAL=: 3['*' NB. SQL_C_CHAR SQL_C_CHAR 1 ] SQL_INTEGER=: 4['*' NB. SQL_C_SLONG SQL_C_SLONG 4 ] SQL_SMALLINT=: 5['*' NB. SQL_C_SSHORT SQL_C_CHAR 2 ifs SQL_FLOAT=: 6['*' NB. SQL_C_DOUBLE SQL_C_DOUBLE 8 ] SQL_REAL=: 7['*' NB. SQL_C_FLOAT SQL_C_CHAR 4 ffs SQL_DOUBLE=: 8['*' NB. SQL_C_DOUBLE SQL_C_DOUBLE 8 ] SQL_TYPE_TIMESTAMP=:93['*' NB. SQL_C_TYPE_TIMESTAMP SQL_C_CHAR 16 fmtdts SQL_VARCHAR=: 12['*' NB. SQL_C_CHAR SQL_C_CHAR 1 trctnb trbuclnb SQL_DEFAULT=: 99['*' NB. SQL_C_DEFAULT SQL_C_CHAR 1 ] SQL_LONGVARCHAR=: _1 NB. SQL_C_CHAR SQL_C_CHAR 1 trbuclnb SQL_BINARY=: _2['*' NB. SQL_C_BINARY SQL_C_CHAR 1 ] SQL_VARBINARY=: _3['*' NB. SQL_C_BINARY SQL_C_CHAR 1 ] SQL_LONGVARBINARY=:_4 NB. SQL_C_BINARY SQL_C_CHAR 1 ] SQL_BIGINT=: _5['*' NB. SQL_C_SBIGINT SQL_C_CHAR 1 ] SQL_TINYINT=: _6['*' NB. SQL_C_STINYINT SQL_C_CHAR 1 ] SQL_BIT=: _7['*' NB. SQL_C_BIT SQL_C_CHAR 1 ] SQL_WCHAR=: _8['*' NB. SQL_C_WCHAR 2*SQL_C_CHAR 2 ] SQL_WVARCHAR=: _9['*' NB. SQL_C_WCHAR 2*SQL_C_CHAR 2 trctnb trbuclnb SQL_WLONGVARCHAR=: _10 NB. SQL_C_WCHAR 2*SQL_C_CHAR 2 ] SQL_UNIQUEID=:_11['*' NB. SQL_C_CHAR SQL_C_CHAR 36 trctguid ) -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
