Strange Problem With APT_STRING_PAD_CHAR
Posted: Wed Jul 18, 2007 11:06 pm
Hi All,
We are facing a strange problem with APT_STRING_PADCHAR environment variable. I can say dangerous variable in DS. I can suggest handle with care.
My Flow is : I am extracting the data by using DB2 API stage in Extract, Where I have one EMP CHAR(6) and DEPT VARCHAR(20) and I am extrcating into Dataset.
I am using the above mentioned in Dataset in one of my derivationLoad job. In that job I am using DB2 EE stage to load the data. So, we have opted APT_STRING_PAD_CHAR (0x20) as a value. Now, the problem starts, from the Dataset mentioned above, we have tried to filter the data in the flow based on EMP CHAR(6) field. My data is not filtering and when we filtered the data with DEPT VARCHAR(20) my data is filtered.
When I changed the value of APT_STRING_PAD_CHAR(0x0) then CHAR field is filtering properly.
If I have used APT_STRING_PAD_CHAR(0x0) then I am facing the problem of Padding nulls when loading the data by using DB2 EE stage.
Can anybody face this type of problem. Please share your inputs.
We are facing a strange problem with APT_STRING_PADCHAR environment variable. I can say dangerous variable in DS. I can suggest handle with care.
My Flow is : I am extracting the data by using DB2 API stage in Extract, Where I have one EMP CHAR(6) and DEPT VARCHAR(20) and I am extrcating into Dataset.
I am using the above mentioned in Dataset in one of my derivationLoad job. In that job I am using DB2 EE stage to load the data. So, we have opted APT_STRING_PAD_CHAR (0x20) as a value. Now, the problem starts, from the Dataset mentioned above, we have tried to filter the data in the flow based on EMP CHAR(6) field. My data is not filtering and when we filtered the data with DEPT VARCHAR(20) my data is filtered.
When I changed the value of APT_STRING_PAD_CHAR(0x0) then CHAR field is filtering properly.
If I have used APT_STRING_PAD_CHAR(0x0) then I am facing the problem of Padding nulls when loading the data by using DB2 EE stage.
Can anybody face this type of problem. Please share your inputs.