IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Easytrieve Problem with Numeric Field


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
melmania

New User


Joined: 22 Sep 2006
Posts: 4
Location: Phoenix, AZ

PostPosted: Fri Sep 22, 2006 8:55 pm
Reply with quote

I have a file that contains a 2-byte field which I defined as 'N'. In the file the field has a hex value of x'F5C2'. My program does a check to determine if the field is numeric (some of the records contain spaces). This record fails the numeric check and is not added to the total. Does anyone know how to handle this? icon_question.gif
Back to top
View user's profile Send private message
guptae

Moderator


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

PostPosted: Tue Sep 26, 2006 12:45 pm
Reply with quote

Hi melmania,

Just try to defined as

ws-var 2 P
then try to add it. I hope it should work.

Just try it & let us know the result
Back to top
View user's profile Send private message
melmania

New User


Joined: 22 Sep 2006
Posts: 4
Location: Phoenix, AZ

PostPosted: Tue Sep 26, 2006 8:48 pm
Reply with quote

Ekta,

Thanks for your suggestion. As I expected, it did not work. If the field was a packed field it should be x'052C', not x'F5C2'. I tried several statements, add, move... but all with the same result: Code 7 (Data Excp).
Back to top
View user's profile Send private message
guptae

Moderator


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

PostPosted: Tue Sep 26, 2006 9:15 pm
Reply with quote

HI melmania,

Just try to defined as

ws-var 2 b
then try to add it. I hope it should work.

Just try it & let us know the result
Back to top
View user's profile Send private message
melmania

New User


Joined: 22 Sep 2006
Posts: 4
Location: Phoenix, AZ

PostPosted: Tue Sep 26, 2006 9:42 pm
Reply with quote

I took out the numeric check and Easytrieve added the value correctly. However, it fails the numeric check. Interesting.
Back to top
View user's profile Send private message
guptae

Moderator


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

PostPosted: Wed Sep 27, 2006 10:32 am
Reply with quote

Thats great
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Issues Converting From ZD to Signed N... DFSORT/ICETOOL 4
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Join 2 files according to one key field. JCL & VSAM 3
No new posts How to move the first field of each r... DFSORT/ICETOOL 5
Search our Forums:

Back to Top