Problem to Write into ODBC Enterprise Stage

pradkumar · Post by **pradkumar** » Wed Oct 18, 2006 7:52 pm

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

splayer · Post by **splayer** » Thu Oct 19, 2006 2:49 pm

The id you are using may not have table creation rights on the database. Developer ids rarely do. This is the first thing to check.

pradkumar · Post by **pradkumar** » Thu Oct 19, 2006 3:13 pm

Thanks for the reply

I do have the permission to create.
I do not know where it is going wrong.

Regards

kris007 · Post by **kris007** » Thu Oct 19, 2006 4:19 pm

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

DSguru2B · Post by **DSguru2B** » Thu Oct 19, 2006 5:33 pm

If thats the case then i think the OP needs to contact support.
If i were you, i would have the table already in place. I dont like the idea of creating things on the fly, thats too "at the last moment" for me.