Saini19 New User Joined: 12 Apr 2012 Posts: 23 Location: Singapore
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.
Col-year Decimal External (5,0)
Col-timestamp Char(26) IF NULL VALUE (‘ ‘)
The COBOL declaration of table is as follows:
Col-year S9(4)V USAGE COMP-3
DCLGEN of table is :
Col1 Char(10) Not Null,
Col-year Decimal (4,0) not Null,
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.
Nic Clouston Global Moderator Joined: 10 May 2007 Posts: 2407 Location: Hampshire, UK
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.
All times are GMT + 6 Hours