Data conversion issue happened during DS upgrade
Posted: Tue Apr 16, 2013 1:17 am
Dear all
Pls help look at this issue i met during migrating job from DS 7.5 to 8.7
The error message like this
No default type conversion from type "raw[8]" to type "string[8]
Context:
1. We copied the DS project /DDL/data in DB from existing DS7.5 environment
2. We are using DB2EE stage to extract data from table
3. In DS 7.5 the job is working well, but the job in DS 8.7 aborted due to above error
4.The value of this field is generated in mainframe, we load data from source to staging table, during the load, we are using column import stage to do a convert that is from binary to char, but when we are using DB2EE stage to extract data from staging table, the error appeared
5. this field is defined as char for bit in DDL
Pls let me know whether i need to provide other information
Pls help look at this issue i met during migrating job from DS 7.5 to 8.7
The error message like this
No default type conversion from type "raw[8]" to type "string[8]
Context:
1. We copied the DS project /DDL/data in DB from existing DS7.5 environment
2. We are using DB2EE stage to extract data from table
3. In DS 7.5 the job is working well, but the job in DS 8.7 aborted due to above error
4.The value of this field is generated in mainframe, we load data from source to staging table, during the load, we are using column import stage to do a convert that is from binary to char, but when we are using DB2EE stage to extract data from staging table, the error appeared
5. this field is defined as char for bit in DDL
Pls let me know whether i need to provide other information