MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Platinum Fast Unload

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
schintala
Beginner


Joined: 18 May 2005
Posts: 108
Topics: 31
Location: USA
PostPosted: Thu Jan 07, 2010 2:25 pm    Post subject: Platinum Fast Unload Reply with quote
Hi,
I am trying to unload the data from catalog tables using platinum fast unload utility. The data from output dataset is not readble. It could be due to unicode format of the catalog. How do I get the data from catalogs in readble format using fast unload of platinum util. My fast unload util control card as follows.

Code:
FASTUNLOAD                                       
DISPLAY-STATUS 2000000,T                         
EXCP YES                                         
INPUT-FORMAT TABLE                               
IO-BUFFERS 60                                     
LOAD-CONTROL NONE                                 
OUTPUT-FORMAT DSNTIAUL                           
UNLDDN SYSREC01  ASCII                           
SHRLEVEL CHANGE                                   
SORTSIZE 8M                                       
SORTNUM 6                                         
ESTIMATED-ROWS 250000                             
SQL-ACCESS  EXTENSION                             
SELECT B.COLLID , B.NAME , B.OWNER               
FROM SYSIBM.SYSPACKDEP A, SYSIBM.SYSPACKAGE B     
WHERE A.BQUALIFIER =                             
'PSSQATB '                                       
AND A.BNAME = 'PSIPAYT'                           
AND  A.BTYPE = 'T'                                                   
AND A.DLOCATION = B.LOCATION AND                                     
A.DCOLLID = B.COLLID AND A.DNAME = B.NAME AND A.DCONTOKEN = B.CONTOKEN
ORDER BY B.COLLID , B.NAME , B.OWNER                                 
;                                           
Back to top
View user's profile Send private message
schintala
Beginner


Joined: 18 May 2005
Posts: 108
Topics: 31
Location: USA
PostPosted: Thu Jan 07, 2010 2:27 pm    Post subject: Reply with quote
Please ignore the following line from the above code. It is an error.

UNLDDN SYSREC01 ASCII.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group