DB2 V9 z/OS Unload Delimited

Brett Kaiser · #1 (**permalink**) 03-26-10, 17:01

I can't figure out how to unload without quote identifiers, and eliminate trailing spaces...any one have any samples? I tried

Code:

 UNLOAD LIST UNLD                   
   DELIMITED COLDEL '|' DECPT '.'   
   PUNCHDDN PUNCHDS                 
   UNLDDN UNLDDS

Brett Kaiser · #2 (**permalink**) 03-26-10, 17:03

Punch card looks like

Code:

TEMPLATE CR0MXZW5                               
     DSN('BXHRSP.DBB1.SBD000DA.SBS00002.UNLD')  
     DISP(OLD,KEEP,KEEP)                        
LOAD DATA INDDN CR0MXZW5 LOG NO  RESUME YES     
 EBCDIC  CCSID(00037,00000,00000)               
 FORMAT DELIMITED COLDEL  X'4F'  DECPT   X'4B'  
 INTO TABLE                                     
 "BXHRSPDA".                                    
 "POSITION_TREE_V"                              
 ( "LVL_1_CD"                                   
  POSITION(*)             CHAR(00005)           
 , "LVL_2_CD"                                   
  POSITION(*)             CHAR(00004)           
 , "LVL_3_CD"                                   
  POSITION(*)             CHAR(00005)           
 , "MNGR_EMPL_ID"

Brett Kaiser · #3 (**permalink**) 03-30-10, 13:46

I think it's not mature enough like other platforms...

I'll have to generate the SQL and SYSREC's

Internet Services

Web Development

Digital Marketing

Consumer Tech