AWK

Print single quotation marks on awk  ( ' ) , you need use  \047 

Sample:

cat testfile | awk 'BEGIN {FS=","}{print "\047"$0"\047"","}' 

How create DB2 basic table:

CREATE TABLE EMPLOYEE
 (EMPLOYEEID   CHAR(3)     NOT NULL,
  NAME  VARCHAR(36) NOT NULL,
  GENDER   CHAR(6)             ,
  LOCATION CHAR(16)            ,
  PRIMARY KEY(EMPLOYEEID)          )