ajayvamsi
New User
Joined: 21 Jul 2005 Posts: 56 Location: Hyderabad
|
|
|
|
hi all,
could you please help how to place sign field in output file
I have declared
OUTREC FIELDS=(11,2,PD,EDIT=(STTT.TT))
if the input file amount field contains sign then I am not getting sign in output file instead I am getting as 'S' before the value even it is -/+
input file :-123.12 it is declared as comp-3
output file :S123.12 which is wrong
expected should be : -123.12 in displayable format with out using file-aid.
I want to use EDIT only since we can declare the number of byte accordingly.
thanks
ajay |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You can't have -123.12 in a 2-byte PD field. You would need a 3-byte PD field -> X'12312D'.
You need a SIGNS parameter to tell DFSORT what you want for the leading and trailing signs.
If you want + for the plus sign and - for the minus sign, use:
Code: |
OUTREC FIELDS=(11,3,PD,EDIT=(STTT.TT),SIGNS=(+,-))
|
If you want a blank for the plus sign and - for the minus sign, use:
Code: |
OUTREC FIELDS=(11,3,PD,EDIT=(STTT.TT),SIGNS=(,-))
|
|
|