dbTalk Databases Forums  

DB2 V7 Unload order

ibm.software.db2.mvs ibm.software.db2.mvs


Discuss DB2 V7 Unload order in the ibm.software.db2.mvs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
yaf201
 
Posts: n/a

Default DB2 V7 Unload order - 12-03-2004 , 04:30 AM






If I unload only one column from a table and that column is the first
column of the clustering index, will the output DS be in physical order
of the table or in index order? My gut feeling is that it should be in
index order as the unload can be satisfied from the index alone, but I
can't find any confirmation in the documentation. It doesn't appear as
if I can specify an ORDER BY clause in UNLOAD as I could have done with
DSNTIAUL.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.