Try this:
Code:
LOAD DATA
INFILE 'example.txt'
DISCARDFILE 'example.dsc'
APPEND INTO TABLE test_tab
FIELDS TERMINATED BY ',' TRAILING NULLCOLS
( empid
, ename CONSTANT 'abc'
, sal   CONSTANT '1'
, job   CONSTANT 'bbc')