IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

about DSNTAIUL utility


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vskumar_mf

New User


Joined: 28 Nov 2005
Posts: 11

PostPosted: Thu Feb 09, 2006 7:51 pm
Reply with quote

Hi friends,

Pls anyone explain about dsntaiul utility which is used to unload data from db2 table to files. also give me other load/unload utilites available and there usage. Also pls provide me any links on this.

thanks to all..

regards
kumar
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Fri Feb 10, 2006 12:47 am
Reply with quote

You probably meant DSNTIAUL. This is a sample program from IBM, written in Aassembler, to show you how to unload data. It is well documented in the fine manual.

Another option is to use the IBM's DB2 UNLOAD utility.

The only options I know out of IBM are File-Aid DB2 and BMC catalog manager.

O.
Back to top
View user's profile Send private message
vskumar_mf

New User


Joined: 28 Nov 2005
Posts: 11

PostPosted: Fri Feb 10, 2006 11:03 am
Reply with quote

Hi O,

thank u very much for ur reply.Also pls can u give some more on DSNTIAUL as u said it is a sample program from ibm to download table data, pls i want some more inform. on this and can u provide me the syntax for using this utility.

also as u said there are bmc and file-aid for db2 for unload, pls give me inform. or links for bmc. any utility to unload table data using bmc.

pls clarify my doubts

thanks
kumar
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Fri Feb 10, 2006 12:33 pm
Reply with quote

Kumar -

Did your read the manual in the link I supplied about DSNTIAUL ? It has all the information you need, including syntax.

Rgearding the other products, please use Google to serach the companies' website.

O.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts REASON 00D70014 in load utility DB2 6
No new posts ISRSUPC search utility - using high l... TSO/ISPF 2
No new posts Any JCL or VSAM Utility to get number... JCL & VSAM 1
No new posts DATA SET LIST UTILITY screen TSO/ISPF 6
No new posts Which SORT utility can improve the Pe... DFSORT/ICETOOL 16
Search our Forums:

Back to Top