DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
jsgoncalves
Participant



Joined: 31 May 2005
Posts: 12

Points: 116

Post Posted: Wed Jun 17, 2020 12:21 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Windows
Hello everybody

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 [...]

data = 2020-01-01

Can someone help me, please ?
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54581
Location: Sydney, Australia
Points: 295981

Post Posted: Sat Jun 27, 2020 8:25 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Display posts from previous:       

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



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours