> 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

Reply via email to