Fatal Error: Not a v1.1 type: decimal

daniel0623 · Post by **daniel0623** » Tue Sep 20, 2005 1:40 am

Hi All,
I have this new error for all my jobs which contain DB2 API Stage:
Job 1
main_program: Fatal Error: Not a v1.1 type: decimal[12,2].
Job 2
main_program: Fatal Error: Not a v1.1 type: decimal[20,0].
Job3
main_program: Fatal Error: Not a v1.1 type: decimal[14,2].

I create a Job which reads data from DB2 API Stage,and put data into Copy Stage.Error still persists.

Can anyone has any solutions.

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Sep 20, 2005 2:21 am

Import the table definition(s) from DB2 using the plug-in stage. Whatever is imported must be correct. Use that.

The message suggests that "Decimal" is not recognized as a data type in version 1.1 of the stage type - maybe "Numeric" is required instead.

daniel0623 · Post by **daniel0623** » Tue Sep 20, 2005 10:07 pm

Job succeeded when executing at local job,but failed at remote server.I change data type to Numeric at remote server.Error persisted.
At remote server all other data type are ok except decimal.I'm very puzzled.

lfong · Post by **lfong** » Wed May 16, 2007 5:55 am

In the Administrator, set the option APT_AUTO_TRANSPORT_BLOCK_SIZE
to false.

karthikraju · Post by **karthikraju** » Wed May 16, 2007 1:19 pm

If the issue exist still do the following

The property APT_AUTO_TRANSPORT_BLOCK_SIZE must be commented out in the zprofile of the unix admin id who installed the datastage.

DataStage by default puts entries into the profile while installing.