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.
tehavele wrote:...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.
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.
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.