MVSFORUMS.com

[kirankumargupt]

Hi ,

I executed one Db2 Query in Batch mode with delimiter(,). And I outputted the result of Query to Sequential file.

When I Opened the data set in browse mode the character values are starting with junk characters.

Query :

Select (Digits(eno)),substr(','),Ename,substr(','),(Digits(eage))
from Employee;

Ex:

O/P Dataset Values
1,..xyz,23
2,..abc,45

Please help me how to write the data to O/P dataset without Junk characters.

[kolusu]

kirankumargupt,

They are NOT junk characters. The extra 2 bytes you see is the length field of a varchar column. So You need the char function to treat them as Char columns which has fixed length.