Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: DB2 V9 z/OS Unload Delimited

    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
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I think it's not mature enough like other platforms...

    I'll have to generate the SQL and SYSREC's
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •