title: How to use default value in LOAD statement in DB2?
body: <p>I am currently using DB2 . I do not know much about load statement.
  I am using this query to load data.. </p>
  
  <blockquote>
    <p>LOAD FROM "IXAC.CSV" OF DEL METHOD P ('IX',1,2,3,4,) MESSAGES
    "SYAC.MSG"  INSERT INTO SYNC.AC_COUNT (       "TYPE",         AC1,        AC2,        AC3,
          AC4  ) ; COMMIT;</p>
  </blockquote>
  
  <p>In "IXAC.CSV" there are 4 int values separated with comma. My problem is that how can i insert 'IX' with load statement as a constant with each row insert. </p>
  
  <p>I tried this but not found any success. I am newer in database.</p>
  
  <p>Help me .. 
  Thanks in advance ...</p>