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
 

 

getting garbage value in my file while unloading the data

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
mainframe_world

New User


Joined: 22 Jan 2010
Posts: 12
Location: delhi

PostPosted: Sun Oct 24, 2010 11:06 am    Post subject: getting garbage value in my file while unloading the data
Reply with quote

Hi All,

Just wanted your confirmation and suggestions.

I am unloading the data and retrieving the data into the file. But i am getting some garbage value in the file for some INTEGER value for
eff-data and exp-date.

Table-data declaration

TBLP_EFF_DATE INTEGER
TBLP_EXP_DATE INTEGER

On the other when i am using the FILEAID at that time i am getting the correct value for the Integer vale.
The declaration in the declgen is
TBLG-EFF-DATE PIC S9(9) USAGE COMP.
TBLG-EXP-DATE PIC S9(9) USAGE COMP.

So could you please anyone suggest me.

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

mainframe_world

New User


Joined: 22 Jan 2010
Posts: 12
Location: delhi

PostPosted: Sun Oct 24, 2010 11:56 am    Post subject: Re: getting garbage value in my file while unloading the dat
Reply with quote

mainframe_world wrote:
Hi All,

Just wanted your confirmation and suggestions.

I am unloading the data and retrieving the data into the file. But i am getting some garbage value in the file for some INTEGER value for
eff-data and exp-date.

Table-data declaration

TBLP_EFF_DATE INTEGER
TBLP_EXP_DATE INTEGER

On the other when i am using the FILEAID at that time i am getting the correct value for the Integer vale.
The declaration in the declgen is
TBLG-EFF-DATE PIC S9(9) USAGE COMP.
TBLG-EXP-DATE PIC S9(9) USAGE COMP.

So could you please anyone suggest me.

Any body wants any other clarification pls let me know.

It's urgent.
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Sun Oct 24, 2010 12:20 pm    Post subject:
Reply with quote

Hello,

Sorry, but we don't do urgent. . .

From the very little that has been posted, there is nothing wrong. . .

Why do you believe there is a problem? If FileAid shows the correct value, why do you not believe this?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sun Oct 24, 2010 1:45 pm    Post subject:
Reply with quote

why is this in CICS forum???

comp data is binary. in the unloaded file, the field will be in binary format.
file-aid converts the binary to a display-decimal
so rookies that don't understand computers can see the value without
having to understand internal representation.
Back to top
View user's profile Send private message
mainframe_world

New User


Joined: 22 Jan 2010
Posts: 12
Location: delhi

PostPosted: Sun Oct 24, 2010 4:25 pm    Post subject:
Reply with quote

Thanks to all.
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Sun Oct 24, 2010 10:50 pm    Post subject: Reply to: getting garbage value in my file while unloading t
Reply with quote

You're welcome icon_smile.gif

Hopefully, this is now clear. . .

d
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm


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