What do you mean by delimiter for space and fixed width files? There is no column delimiter for fixed width files. You should create a control file which defines the record layout.

Here you go

nzload -u ${NZ_USER} -pw ${NZ_PWD} -host ${NZ_HOST} -db ${NZ_DB -t ${TGT_TABLE} -cf ${CTL_FILE_NM} -lf ${LOGFILE} -bf ${BADFILE} 2> ${LOAD_TBL_ERR}

Control file

DATAFILE <Specfiy the file name>

{

format fixed

maxerrors 0

layout (

COLUMN1 char(1) bytes 1,

COLUMN2 char(5) bytes 5,

COLUMN3 char(5) bytes 5,

COLUMN4 char(11) bytes 11,

COLUMN5 varchar(30) bytes 30,

COLUMN6 varchar(6) bytes 6,

COLUMN7 varchar(2) bytes 2,

COLUMN8 varchar(1) bytes 1,

COLUMN9 varchar(8) bytes 8,

COLUMN10 varchar(8) bytes 8,

COLUMN11 varchar(8) bytes 8,

COLUMN12 varchar(1) bytes 1,

COLUMN13 varchar(40) bytes 40

       )

}

NZLoad is a very simple tool with very few features.  It expects the file content to match the definition, so you cannot selectively exclude columns.

There are two different approaches you can take to perform transformation on the source:

1. Use NZLoad to get the data in as-is from the source, then use SQL to move what you want, where you want.

2. Define the source as an external table (which is what NZLoad does anyway) and use SQL to read the source and place the data where you want it.