Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 6968
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 Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us