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

Table processing using easytrieve


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

New User


Joined: 09 Nov 2006
Posts: 2

PostPosted: Mon Jun 30, 2008 4:06 pm
Reply with quote

Hi everbody,

I have a query regarding table processing using easytrieve.. The DB2 table has the field DECIMAL(7, 2). This translates in cobol as S9(5)V9(2) USAGE COMP-3. This amount field may hold negative values also. Say the amout field is -313.00 . I want to convert this into packed decimal.
I tried the syntax below.

FILE FILEIN
FILEIN-COL17 253 08 N
*
FILE FILEOUT
FILEOUT-COL17 101 04 -P 2
*
JOB INPUT(FILEIN)
FILEOUT-COL17 = FILEIN-COL17
PUT FILEOUT
*

Can you give me suggestions regarding this..

Regards,
Nishmija
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Jun 30, 2008 9:24 pm
Reply with quote

Hello Nishmija and welcome to the forums,

Quote:
I tried the syntax below.
Ok. What happened?

When posting a question, you need to post what happened when you tried. Did the job abend or give undesired results? Was some diagnostic message presented? Etc. . .
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 Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top