sql_type_date is 91 in odbc v3, I think your odbc driver is only v2 that data_type = 9, [1]
jdd can only handle odbc v3 not v2, you need to amend jdd to handle those older datetime types. Or find a newer odbc driver for your database. Or cast date to other types. [1] http://msdn.microsoft.com/en-us/library/ms714714(VS.85).aspx Пнд, 06 Сен 2010, Steven Taylor писал(а): > > Is the H1.RYN a mssql, oracle? or xtrive!?" > The database is Intersystems Cache. I was just trying to stay on topic. > > > Anyways I suggest use ddcol to examine the column type of the stockprice > table. Current dd does not > handle all odbc types. > > Thanks! Using ddcol, details on the offending column found by elimination > are: > x=: 'StockPrice' ddcol ch > r1=:0{x > r2=:13{x > |:2 13$r1,r2 > > TABLE_QUALIFIER¦ > TABLE_OWNER ¦dbo > TABLE_NAME ¦stockprice > COLUMN_NAME ¦tdate > DATA_TYPE ¦9 > TYPE_NAME ¦DATE > PRECISION ¦10 > LENGTH ¦4 > SCALE ¦0 > RADIX ¦ > NULLABLE ¦0 > REMARKS ¦tdate > COLUMN_DEF ¦ > Is there a way to know which ODBC types are implemented in J? Perhaps I > should have realised since there's no date type in J. I thought it might > translate to float or int. > > thanks, > -Steven > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm -- 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
