DSXchange

Hi srikanth18 The error comes while in the XML message the field is defined as decimal and it is having null values. By default, the decimal field in the xml message cannot be specified as null. ( this is also a bypart when u specify "replace empty values with null". In this case since the...

@Sreen 1. I did not get your question ? Are you able to see the polish characters when you open in the unix box ? I have used a csv and db stage in the existing job having the NLS pack of 8859-1 (proj default). Then created another job to read the csv using the UTF-8 pack and i was able to see the d...

@ray.wurlod I had tried numerous NLS packages like ISO-8859-1 ( proj default),8859-2,8859-12,UTF-8,IBM 01147,IBM 918,8859-1:1987 but i could not resolve the issue . I had done these changes in the NLS tab of the job properties wherin i have changed the Default map for Stages section Could you please...

Hi I have 2 environments PRD and PRD_SUP. The job reads from the message queue and loads in the Staging table.For loading into the database table i am using write append. The job is working fine in PRD_SUP but when i execute the same job it aborts giving the following error : The statement named in ...

The Error is basically due to the Environment Varible is not defined properly. for example you may be using parameter set in the job but would not defined the same.