title: How to write DB2 SELECT statement in unload job for delimiters
body: <p>I have been over this... seems silly but couldnt figure out!</p>
  
  <p>I wanna UNLOAD a table but with a delimiter '|' in between the fields. Here is the JCL used to unload the table:</p>
  
  <pre><code>//JS020    EXEC PGM=IKJEFT01,                     
  //             DYNAMNBR=20                        
  //*                                               
  //SYSTSPRT DD  SYSOUT=*                           
  //SYSPRINT DD  SYSOUT=*                           
  //SYSUDUMP DD  SYSOUT=*                           
  //SYSPUNCH DD  SYSOUT=*                           
  //*                                               
  //SYSTSIN  DD  *                                  
    DSN SYSTEM(XXXX)                                
    RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) PARM('SQL')
  //*                                               
  //SYSREC00 DD  DSN=TABLEA.UNLOAD.FILE,            
  //             DISP=(NEW,CATLG,DELETE),           
  //             UNIT=SYSDA,LRECL=80                
  //SYSIN    DD  *                                  
    SELECT  COLUMN1                                 
           ,'|',COLUMN2                                 
           ,'|',COLUMN3                                 
           ,'|',COLUMN4                                 
           ,'|',COLUMN5                                 
    FROM   TABLEA                                   
    WITH UR;                                        
  /*                                                
  //*                                               
  </code></pre>
  
  <p>Output yields </p>
  
  <pre><code>VALUEA..|VALUEB..|VALUEC..|VALUED..|VALUEE
  VALUEA..|VALUEB..|VALUEC..|VALUED..|VALUEE
  VALUEA..|VALUEB..|VALUEC..|VALUED..|VALUEE
  VALUEA..|VALUEB..|VALUEC..|VALUED..|VALUEE
  VALUEA..|VALUEB..|VALUEC..|VALUED..|VALUEE
  </code></pre>
  
  <p>But I wish to have like below</p>
  
  <pre><code>VALUEA|VALUEB|VALUEC|VALUED|VALUEE
  VALUEA|VALUEB|VALUEC|VALUED|VALUEE
  VALUEA|VALUEB|VALUEC|VALUED|VALUEE
  VALUEA|VALUEB|VALUEC|VALUED|VALUEE
  VALUEA|VALUEB|VALUEC|VALUED|VALUEE
  </code></pre>
  
  <p>I'm not able to figure our why that .. is preceeding the delimiter '|'. Any guesses what does that value mean? Thanks for your interest.</p>