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 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: 10211
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: 6966
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 SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm


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