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
 

 

Issue while unloading records using DB2HPU1 utility.

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

New User


Joined: 12 Apr 2012
Posts: 23
Location: Singapore

PostPosted: Wed Dec 16, 2015 3:30 pm    Post subject: Issue while unloading records using DB2HPU1 utility.
Reply with quote

Q1 : I am facing issue while unloading records using DB2HPU1 utility.

Currently the job is using BMCUNLD utility, but now have to convert my job to DB2HPU1 utility as per latest standards to unload records from table.

Please find below the select query being used in bmcunload which is currently running successfully in production.

Code:
Select    Col1,
                Col-year,
                Col-timestamp
Into
                Col1 Char(10),
                Col-year Decimal External (5,0)
                Col-timestamp  Char(26) IF NULL VALUE (‘ ‘)
From tablename


The COBOL declaration of table is as follows:

Code:
Col1  X(10)
Col-year S9(4)V USAGE COMP-3
Col-timestamp x(26)

DCLGEN of table is :
Col1 Char(10) Not Null,
Col-year  Decimal (4,0) not Null,
Col-timestamp Timestamp

When I am trying to run the same query using DB2HPU1 utility, it is failing at 2 places.

1. It is failing at External(5,0) with below error:
• 234 * Data Lost * SYSREC* * Col2 * * 02012C

When I give EXTERNAL(6,0) , it is working fine. Looks like it is taking extra sign bit which is not required. How do I trim it so that it just takes (5,0)

2. It is failing for Col-timestamp with invalid syntax error.

Code'd, some
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Wed Dec 16, 2015 7:05 pm    Post subject:
Reply with quote

Why not ask the people who told you to do this? They might have some conversion guidelines that cover these situations and if they do not then they should be made aware of them as others may run into the same problems.
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 TAPE VERIFY utility?? MrExtraordinare JCL & VSAM 3 Fri Dec 09, 2016 10:57 pm
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts DFHRESPONSE returns issue divated CICS 3 Wed Nov 02, 2016 6:32 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm


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