MVSFORUMS.com

arv · Beginner Joined: 30 Mar 2003 Posts: 13 Topics: 11

Hi all,

Kindly explain the DSNUTILB utility with an example, like how it is used to load data to a db2 table from vsam file and also how to unload data.Kindly specify in detail....

with regards,

arv.

kolusu · Posted: Thu Apr 03, 2003 11:18 am Post subject:

Arv,

DSNTIAUL is a sample unload program of DB2. This program, which is written in assembler language, unloads some or all rows from up to 100 DB2 tables. With DSNTIAUL, you can unload data of any DB2 built-in data type or distinct type. You can unload up to 32KB of data from a LOB column. DSNTIAUL unloads the rows in a form that is compatible with the LOAD utility and generates utility control statements for LOAD. DSNTIAUL also lets you execute any SQL non-SELECT statement that can be executed dynamically.

Check this link for examples of unloading of the tables using DSNTIAUL

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/APPENDIX1.3.1?DT=20010710165542

Hope this helps...

cheers

kolusu

Manas Biswal · Posted: Thu Apr 03, 2003 11:54 pm Post subject:

In addition, you can also see the following book for a complete list of all the utilities along with examples -

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUG0F6/CCONTENTS?DT=20000421183700

Regards,
Manas