Hi
I am new to this group.
I am using Datastage EE (7.5)
I am trying to read the data from an ODBC Enterprise stage and pass it to a transformer and then write it into a ODBC Enterprise stage
ODBC Enterprise-->Transformer-->ODBC Enterprise
I am giving the write mode as "CREATE table". I am giving a new table name. Compilation was ok. But while runing,It was giving an error like
"main_program: Internal Error: (0): odbcUtils.C: 798 "
Does it automatically creates a new table? Can we pass Table name as a Parameter?
Please let me know how to overcome this error
Thanks
Pradeep
Problem to Write into ODBC Enterprise Stage
Moderators: chulett, rschirm, roy
Problem to Write into ODBC Enterprise Stage
Pradeep Kumar
I am aware of an issue where using an ODBC stage and a DB2 stage within a same job resulted in a similar error which was then resolved by applying some patches. I have a feeling that this error is similar to that. I am not aware of what patches were applied nor the ecase number. So can't help you in that. I vaguely remember it had something to do with ODBC libraries but I am not sure.
HTH
HTH
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson