DSXchange

Thanks Chullet, i changed it to Px. Source is db2 table and DESC column data is being used by other users who can update this column. So i can't split rows based on LF or any other delimiter. I have to produce the output rows based on number of characters in DESC column. Output file is a source file...

Sorry its a parallel job i could'nt update the job type. Do i still need to continue here or create a new topic ?

I have to split a row based on number of characters (e.g 2 characters in the following example) to multiple rows. Which stage i can use or what is the best technique to do it. Input: (Act and Line columns are keys) Act Line Desc --- ----- -------------------- 5 1 ABCDEFGH 8 1 LMNOP 9 1 XY Desired Ou...

APT_STRING_PAD_CHAR is not Parallel property?
Can it be used used in server job as well ?

While creating a sequential file strings are padded with NULLs. I want to remove those nulls before loading to table.

Although its for parallel jobs but i tried to set following property as well but it didnt work: APT_STRING_PADCHAR 32x0

009 value works to make tab delimited file.

It worked with correct case. Thanks.

I provided Sort Specification as below and it errored out:

TRAN_NO Desc

Drivertest..Sort_29: Internal Error: sort specification error, function create_sort_spec returned [Invalid sort specification]

I mentioned Temp directory as follows:
\\xyz1\DEV\temp

Hi,
I want to do sort in a server job. I tried to get help for server SORT stage but couldnt. Can anyone help me out what options has to be set in SORT stage with some example plz.

Thanks.

995100003 213576 001950449803503 2008050700000000 003 SHORT TERM PREM 100 ANNUAL PREM 100 Coding: --- ---- 39 9 39 9 35 5 31 1 30 0 30 0 30 0 30 0 33 3 20 20 20 32 2 31 1 33 3 35 5 37 7 36 6 20 20 30 0 30 0 31 1 39 9 35 5 30 0 34 4 34 4 39 9 38 8 30 0 33 3 35 5 30 0 33 3 20 20 20 20 20 20 20 20 32 2...

Actual Row: 995100003 213576 001950449803503 2008050700000000 003 SHORT TERM PREM 100 ANNUAL PREM 100 Hex format: 39 39 35 31 30 30 30 30 33 20 20 20 32 31 33 35 37 36 20 20 30 30 31 39 35 30 34 34 39 38 30 33 35 30 33 20 20 20 20 20 20 20 20 32 30 30 38 30 35 30 37 30 30 30 30 30 30 30 30 20 20 20 ...

Im sorry it was MS1252 not MS1253.

1. How to display hex/octal values of a row.
2. MS1253

Any Comments ?

It worked. Thanks.