odbc stage

vijaykumar · Post by **vijaykumar** » Wed Feb 21, 2007 2:23 pm

Hi Gurus;
Is it possible to dump the data from odbc to odbc.
odbc--->odbc. without any transfomation in between the two stages.I tried out its throwing error.
It doesn't recognise the table name, even if i choose in the target update action as create new table, its throwing error.

please help me.
cheers;
vijaykumar

I_Server_Whale · Post by **I_Server_Whale** » Wed Feb 21, 2007 2:33 pm

Please post exact error message.

DSguru2B · Post by **DSguru2B** » Wed Feb 21, 2007 2:36 pm

It is certainly possible but you need to provide all the connection information, table names etc etc.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 21, 2007 3:31 pm

Indeed it's one of the lab exercises you do in the IBM DataStage Essentials (server edition) class.

So, please verify the details as DSguru2B requested, also verify that you have sufficient privilege to create tables in the data source to which you are connecting. Are there any error/warning messages logged? If so, please post these.