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 in UNLOAD

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

New User


Joined: 09 Jan 2007
Posts: 4
Location: india

PostPosted: Tue Jan 15, 2008 5:42 pm    Post subject: Problem in UNLOAD
Reply with quote

Hi....Actually I m using Unload utility in JCL to unload the data...using DSNUPROC....and its working ...the only problem is that the table which is retrieved...has the first column missing...instead i have some garbage values on that column.

] % ACT 2005-11-01 2007-12-01
] % ACT 2006-10-01 2006-10-01
] % ACT 2004-05-01 2007-12-01
] @ ACT 2005-04-01 2005-04-01
] @ ACT 2005-08-01 2005-08-01
] @ ACT 2005-03-01 2005-03-01
] à ACT 2006-12-01 2006-12-01

U can see the values before ACT are supposed to be of column one....can u tell me what could be the problem.
the first column is supposed to be a 10 digit number(i.e. np_prfl_no)


the main part of jcl is as follows

UNLOAD TABLESPACE XXXX00.NP
FROM TABLE XXXX00.NP_PRFL_CHNL
WHEN ( NP_PRFL_NO < 3000010000)
UNLDDN(SYSREC00)
NOSUBS
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10374
Location: italy

PostPosted: Tue Jan 15, 2008 5:48 pm    Post subject: Reply to: Problem in UNLOAD
Reply with quote

unload to a sequential dataset...
browse the dataset
issue the command "HEX ON"
most probably You will see what looks ike garbage, but are really Your numbers
in packed or binary fomat
- check the table definition ( create statements )

- that' s what can be inferred from the data posted ,
the first bytes look like garbage, but probably are Your numbers
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Tue Jan 15, 2008 5:50 pm    Post subject:
Reply with quote

well, I am overwhelmed with the amount of info that you have provided.

1. this 'garbage' data could be a record variable length indicator

or

2. this 10 digit number is retreived in binary format. if you want the np_prfl_no to be in another format, you need to specify that in your control parms.
Back to top
View user's profile Send private message
abhishek_mishra

New User


Joined: 09 Jan 2007
Posts: 4
Location: india

PostPosted: Tue Jan 15, 2008 7:07 pm    Post subject: Re: Reply to: Problem in UNLOAD
Reply with quote

U seem to be correct....the datatype of the first column is numeric(10 digits)....if I want to extract the column in decimal format...where to define that in the jcl.
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Tue Jan 15, 2008 7:21 pm    Post subject:
Reply with quote

Have you looked in the manual yet?
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 Having a problem FTP'ng to the MF pahiker All Other Mainframe Topics 2 Fri Nov 10, 2017 8:20 pm
No new posts LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts Problem commiting to DB2 from IMS MPP Ole Soerensen IMS DB/DC 2 Wed Jul 26, 2017 5:19 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am

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