Problem in UNLOAD

abhishek_mishra · New User Joined: 09 Jan 2007 Posts: 4 Location: india

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

enrico-sorichetti · Posted: Tue Jan 15, 2008 5:48 pm

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

dbzTHEdinosauer · Posted: Tue Jan 15, 2008 5:50 pm

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.

abhishek_mishra · New User Joined: 09 Jan 2007 Posts: 4 Location: india

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.

stodolas · Posted: Tue Jan 15, 2008 7:21 pm

Have you looked in the manual yet?