I have one sqlserver table with an attribute type date
i'm using a odbc stage to "insert rows without clearing"
i'm suging a odbc stage to select a row
i'm using a transformer just to match directly
i'm getting errors:
(1)
[...]: DSD.BCIOpenW results of function SQLColAttributes(data) gave MetaData mismatch
COLUMN.TYPE Expected = Date Actual =
and i have to define attribute data as varchar(10) so i don't get this error
(2)
[...]: ..load.load_gg_dados_comboio_dia: DSD.BCIPut call to function SQLExecute failed.
SQL statement:INSERT INTO gg_dados_comboio_dia(data) VALUES (?)
SQLSTATE=22008, DBMS.CODE=241
[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]filed to convert data and/or hour [...]
Yes, VarChar(10) or Char(10). Set the Data Element value to
Date
to specify to the ODBC driver that it's a date.
_________________ IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Add To Favorites View next topic View previous topic
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum