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: 1753
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 Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm
No new posts To Merge mutliple records into a sing... anandgbe DFSORT/ICETOOL 6 Wed Feb 22, 2017 8:49 am


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