DSXchange

Change capture stage will not sort the data by default on key column. One needs to sort the data and hash partition the data on key column(s) explicitly in sort stage or in the same stage.

dsexport.exe /U=Username /P=Password /H=Server /JOB=Jobname <PROJECT> <LOCATION>

I've used this to export the job dsx....it came without the Job executables.

Can you provide more details about the column...? What is the datatype in the source Database....!!

Thank you Craig ... It worked...!! :D

I'm using Ipswitch S/W to transfer the file,by changing the mode of transfer the box character won't appear. But if you observe I've asked if there is any way these characters can be handled in Datastage?

Yes..... this column is the last one in my file.
Record level final delimiter is end.

Hi All, Iam moving a CSV file from Windows to UNIX, then reading the CSV file in one of my job and when trying to view data in dataset i'm able to see a box character appended to the value of a column which has a datatype of VARCHAR(8). The box character is not appended for the values if the string ...

Clear the partitioning in the Transformer stage in stage properties, which is before the Sequential file stage.

Convert the source data from string to decimal...automatically the zero's will be stripped off. If you still want the source data to be string then convert it back from decimal to string..!

Make the execution mode in transformer as Sequential in stage properties.....keep a counter which adds one for every record..!!

Read the column in the source table as "decimal[28,0]" and convert the column's datatype in the transformer stage to the datatype of the target table.

If you observe the error message there is a space coming in front of the string,trimming the string before the conversion can help.

Multiplying with 100 will help only if the number has two decimal places.

Divide 12.90 with the value 7.47 and store the result as an integer. Then multiply this integer value with 7.47 and subtract this result from 12.90.

In transformer itself, one can compare the code value with that of the previous code value using stage variables. If same then you can directly drop it, else send the record to the link.