Page 1 of 1

odbc stage

Posted: Wed Feb 21, 2007 2:23 pm
by vijaykumar
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

Posted: Wed Feb 21, 2007 2:33 pm
by I_Server_Whale
Please post exact error message.

Posted: Wed Feb 21, 2007 2:36 pm
by DSguru2B
It is certainly possible but you need to provide all the connection information, table names etc etc.

Posted: Wed Feb 21, 2007 3:31 pm
by ray.wurlod
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.