Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Converting PD fields with ICEMAN

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Michaelod
Warnings : 1

New User


Joined: 02 Sep 2008
Posts: 49
Location: Edinburgh

PostPosted: Wed Sep 03, 2008 4:06 pm    Post subject: Converting PD fields with ICEMAN
Reply with quote

I have an S9(13)v9(2) comp-3 field in an input record that I wish to map to an S9(14)v9(2) field in an ouptut record.

I have tried the following to no avail:

158:179,8,PD,EDIT=(TTTTTTTTTTTTTTTS),SIGNS=(+,-),LENGTH=16,

Anyone have any ideas?

Thanks
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Sep 03, 2008 5:19 pm    Post subject:
Reply with quote

Hello Michaelod,

Would u Please provide us sample i/p & o/p ?
Back to top
View user's profile Send private message
Michaelod
Warnings : 1

New User


Joined: 02 Sep 2008
Posts: 49
Location: Edinburgh

PostPosted: Wed Sep 03, 2008 6:06 pm    Post subject:
Reply with quote

guptae wrote:
Hello Michaelod,

Would u Please provide us sample i/p & o/p ?


Hi,

Quote:
From position 179 in the Input record the data is as follows (hex):

00000350
0000010D

When I execute the following step:

158:179,8,PD,EDIT=(TTTTTTTTTTTTTTTS),SIGNS=(+,-),LENGTH=16

I get the following in the output file:

From position 158

000000000031500


For some reason there is no sign.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Sep 03, 2008 9:29 pm    Post subject:
Reply with quote

Quote:
For some reason there is no sign.


The reason is that you specified a trailing sign in the EDIT pattern, but you didn't specify trailing signs in SIGNS. You can use this:

158:179,8,PD,EDIT=(TTTTTTTTTTTTTTTS),SIGNS=(,,+,-),

The syntax for SIGNS is (lp,ln,tp,tn) where:

lp=leading positive sign
ln=leading negative sign
tp=trailing positive sign
tn=trailing negative sign

SIGNS=(+,-) gives the leading signs, not the trailing signs.
SIGNS=(,,+,-) gives the trailing signs.

Note that you don't need LENGTH=16 since the length is taken from the EDIT pattern by default.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm
No new posts Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm
No new posts Sort two file having same field, one ... himanshu malik DFSORT/ICETOOL 7 Thu Feb 02, 2017 10:09 am
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
This topic is locked: you cannot edit posts or make replies. DB2 query Using Recursion, Converting... smilewithashu2 DB2 3 Tue Jan 03, 2017 12:50 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us