MVSFORUMS.com

Shankarganesh_gopal

Hi all,

I am using DSNTIAUL program to extract data into File and the Query is as follows.

shekar123 · Posted: Mon May 28, 2007 10:13 pm Post subject:

Shankar,

Try the following:

1.Create your Header in a dataset with columns
2.Use SORT utility to concate the Header dataset and the Unloaded dataset as SORTIN
3.In the SORTOUT Dataset you can get the desired output with Header and Detail records

Example:

Nic Clouston · Posted: Tue May 29, 2007 3:42 am Post subject:

You could use IEB/ICEGENER as well if you go down this route
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

kolusu · Posted: Tue May 29, 2007 8:17 am Post subject:

Shankarganesh_gopal,

Use DSNTEP2 program to unload the data instead of DSNTIAUL. However with DSNTIAUL your output is limited to 133 bytes only. If your unload exceeds that length then it will wrap around.

Alternatively you can try this also. Select 1 row from sysibm.sysdummy1 as the header values.

Shankarganesh_gopal · Posted: Wed May 30, 2007 12:50 am Post subject:

Thanks a lot kolsu.

I worked and i got my problem solved.

Shankarganesh_gopal · Posted: Tue Jun 05, 2007 1:36 am Post subject:

Hi Kolusu,

I have one more issue now.

I am doing a select using DSNTIAUL. If suppose a column is defined as NULL, then it is producing the result with like '..?'. Is there a way to make it space or proper data.

Thanks a ton.

kolusu · Posted: Tue Jun 05, 2007 6:15 am Post subject:

Shankarganesh_gopal,

1. Click on "Quick Manuals" link on top of this page
2. Scroll down to DB2 section and click on the manual " DB2 V7 SQL Reference"
3. Click on

4. In the search box type COALESCE and press search
5. Read the first link which will answer your query

Hope this helps...

Cheers

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu