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
 

 

Problem while viewing unloaded data

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Help-Me-Out

New User


Joined: 09 Dec 2006
Posts: 56
Location: Pune

PostPosted: Wed Jul 08, 2009 5:19 pm    Post subject: Problem while viewing unloaded data
Reply with quote

Hi,

I am unloading the data which has 15 dates and values can be null.
I have unloaded the data in a file. When I am opening the file using the fileaid (specifying the copybook for the table), I am not able to see the data correctly. Also the date indicator occupying only 1 byte instead of 2 (Indicator S9(4) comp)

Can anyone help me where I am going wrong icon_question.gif
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


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

PostPosted: Wed Jul 08, 2009 5:33 pm    Post subject:
Reply with quote

Depends on how you are 'unloading' the table.
Maybe you have null-ind-variables (as well as lengths for varchar if there are any)
which means the copybook for the table is worthless.
you need a copybook that matches the 'unloaded' data.

If you ask anymore questions, provide us with a cut&paste image of the data with HEX ON using bbcode
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Wed Jul 08, 2009 5:39 pm    Post subject:
Reply with quote

what utility you are using for unloading table?
is it DSNTIAUL if so then check if your copybook is agreeing with SYSPUNCH generated...
Back to top
View user's profile Send private message
Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai

PostPosted: Thu Jul 09, 2009 4:27 pm    Post subject:
Reply with quote

Hi,
Please check with the sysin and the unload card. When we are unloading any table we can give a fix value to unload when a colum has a null value
like
If null then '000000' some what like this there is a option.
So check what are you replacing with.

May be this help.

Regards
Ketan varhade
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts JES2 JEC: Use UNIX Pipes to Pass Data... Virendra Shambharkar JCL & VSAM 21 Tue Dec 20, 2016 6:55 pm


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