Forum

7. Oktober 2008 um 14:14 Uhr #4174
hke

Mitglied

Ja das geht, siehe DB2 for zOS V8 – Utility Guide and Reference – Chapter 16. LOAD – Option DELIMITED http://publib.boulder.ibm.com/epubs/pdf/dsnugj16.pdf

//SYSIN DD * 

	   LOAD DATA FORMAT DELIMITED COLDEL ’,’ CHARDEL ’"’ DECPT ’.’

	   INTO TABLE TBQB0103 

	   (FILENO CHAR, 

	    DATE1 DATE EXTERNAL, 

	    TIME1 TIME EXTERNAL, 

	    TIMESTMP TIMESTAMP EXTERNAL) 

	/*