odbc issue in datastage 8.0.1

v2rao · Post by **v2rao** » Mon May 11, 2009 1:33 am

Dear Team,

When I try to view the data of the below query in ODBC connector stage, i getting error msg "error occured while invoking CAS".

" SELECT COL_NUM1, COL_NUM2 FROM TABLENAME;"

please tell me why it is coming.

chulett · Post by **chulett** » Mon May 11, 2009 6:49 am

How can we, with so little information posted? What are you trying to connect to and with what driver? Details, man, details.

reddysrc · Post by **reddysrc** » Mon May 11, 2009 11:33 am

metaData Missmatch, correct your metadata according to source file.

Thanks
Ram

v2rao · Post by **v2rao** » Tue May 12, 2009 12:06 am

Thanks for replays,

in my job we are connecting to informix table with 28 columns, but i need 2 columns only that i written a query for retriving 2 columns but it throwing error.

Please help me in this

ray.wurlod · Post by **ray.wurlod** » Tue May 12, 2009 12:14 am

Why is there a leading space in your SQL? Have you tried it without the terminating semi-colon?

v2rao · Post by **v2rao** » Tue May 12, 2009 12:45 am

hi ray,

i try with remove ";" also but it is coming.

one thing i like to know that we need to import completed metadata of the table or just two columns saficent.

i done with 2 column import only but it is not working.

ray.wurlod · Post by **ray.wurlod** » Tue May 12, 2009 1:10 am

OK, be more specific - "not working" does not convey anything useful. What precise error message is generated (copy/paste it from the job log - don't try to paraphrase or transcribe it).

DSXchange

odbc issue in datastage 8.0.1

odbc issue in datastage 8.0.1

Re: odbc issue in datastage 8.0.1