Table creation failed

[tehavele]

Hi ,

I am trying to create a table using Enterprise ODBC stage.Database is Oracle.

But I am getting below fatal errors.

Code: Select all

main_program: Driver doesn't support the datatype. DataType Code = -9
main_program: Could not get mapping for one or more datatypes. Cannot create table:CSTG2.MM_ZMARA 
ODBC_Enterprise_32: Table create failed: {0} 
main_program: Could not check all operators because of previous error(s)
main_program: Creation of a step finished with status = FAILED.

I tried searching in the forum. No success as of yet.
Any help is appreciated.

[ArndW]

...main_program: Driver doesn't support the datatype. DataType Code = -9
main_program: Could not get mapping for one or more datatypes. ...

What datatypes are you using in your table. One or more of them are not supported.

[tehavele]

Datatypes are Varchar , Decimal.
From the source I am applying function UstringToString for som,e columns.

[ArndW]

Are you generating the CREATE TABLE? I can't check right now, but seem to remember that you can view the generate DDL in the stage and then you could either post it here or manually try to run it in your favorite query tool.

[tehavele]

Arnd,

The problem is solved now. The problem was of NULLs. I had done NullHandling in the transformer but I repleced NULLs with the Empty string "" .I Read in some post that database treats empty string as a NULL.So I replaced it with one space " " then it is run fine.

I am not generating CREATE TABLE. I am using property Write Method = Write and Write Mode = Create . I looked for create sql statement but I did not get it.

Thanks for your help Arnd.[/i]