Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Retrieve records from DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
nkothako

Active User


Joined: 26 Nov 2008
Posts: 125
Location: chennai

PostPosted: Wed Oct 20, 2010 2:18 am    Post subject: Retrieve records from DB2
Reply with quote

Can I get some sample jcl for retrieving records from DB2 using DFSORT/ICETOOL?
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1755
Location: Bloomington, IL

PostPosted: Wed Oct 20, 2010 2:23 am    Post subject:
Reply with quote

Probably not.
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Wed Oct 20, 2010 2:37 am    Post subject: Reply to: Retrieve records from DB2
Reply with quote

nkothako,

What exactly is your requirement ? You cannot retrieve records directly from DB2 using DFSORT. However I don't see any value in invoking DFSORT to retrieve records from DB2. IBM has unload utilities which lets you unload/reformat the data in anyway you want.

DSNTIAUL : It 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 32 KB 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.


DB2 High Performance Unload enables you to:

1. Unload DB2 data to flat files, tape devices, or named pipes.
2. Create files for multiple targets, even if the target files require different import or
load file formats, because DB2 High Performance Unload supports multiple formats for output files.
3. Unload DB2 summary tables.
4. Perform complete system migration from one DB2 instance to another one.
5. Eliminate the need for special applications to convert data, because DB2 High
Performance Unload column function supports conversion to a wide range of
data types by using SELECT statement.
6 Use powerful, easy-to-use, and familiar SELECT syntax to specify the columns
and rows to unload.
7. Unload a sample of DB2 rows by using the MAXROWS, SKIP, and INTERVAL
keywords. You can use this feature to quickly check your control file syntax.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us