Shell Programming and Scripting

Table structure: 
create multiset table tbl1, no fallback,
  no before journal,
  no after journal,
  checksum = default,
  default mergeblockratio (
    col1 VARCHAR(10) not null title 'col1' casespecific,
    col2 VARCHAR(200) casespecific,
    col3 CHAR(1) not null casespecific
)
primary index tbl1 (
col1 );

CREATE MULTISET TABLE LMS_STG.tbl1 ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      col1 DECIMAL(18,0),
      col2 VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY INDEX NUPI_PH_STUD_CPNT ( col1 );

I have to create another control file which will be like this:

DEFINE JOB TBL1
DESCRIPTION 'Load a Teradata table from a file'
(
DEFINE SCHEMA DATA_SCHEMA
(
col1 CHAR(20),
col2 CHAR(11),
col3 CHAR(11),
col4 CHAR(11),
,EOL_PAD CHAR(1)
);
DEFINE OPERATOR FILE_READER
TYPE DATACONNECTOR PRODUCER
SCHEMA DATA_SCHEMA
ATTRIBUTES
(
VARCHAR PrivateLogName='PL_TBL1',
VARCHAR IndicatorMode = 'N',
VARCHAR OpenMode = 'read',
VARCHAR Format = 'Unformatted',
VARCHAR DirectoryPath = '/ngs/app/edwt/INFA/tgtfiles/',
VARCHAR FileName = 'tbl1.out'
);
DEFINE OPERATOR STREAM_OPERATOR
TYPE STREAM
INPUT SCHEMA *
ATTRIBUTES
(
INTEGER TenacityHours = 4,
INTEGER TenacitySleep = 6,
INTEGER MaxSessions = 6,
INTEGER MinSessions = 2,
VARCHAR Robust = 'Y',
VARCHAR ARRAYSUPPORT = 'ON',
INTEGER ErrorLimit = 1,
VARCHAR AppendErrorTable = 'Y',
INTEGER Pack = 600,
VARCHAR TdpId = @tdpid,
VARCHAR UserName = @userid ,
VARCHAR UserPassword  = @password ,
VARCHAR WorkingDatabase = 'LMS_STG',
VARCHAR TargetTable  = 'LMS_STG.PA_tbl1_FL',
VARCHAR ErrorTable = 'LMS_STG.ET_tbl1',
VARCHAR LogTable  = 'LMS_STG.LG_tbl1',
VARCHAR PrivateLogName = 'load_log',
VARCHAR Dateform = 'ANSIDATE'
);
APPLY
('
INSERT INTO LMS_STG.tbl1_FL(
col1,
col2

) VALUES ( 
:col1,
:col2
) ; 
')
SERIALIZE ON (
col1
) 
TO OPERATOR (STREAM_OPERATOR())
SELECT 
CASE WHEN col1 = '*' 
THEN NULL(CHAR(20)) 
ELSE col1 
END AS col1,
CASE WHEN col2 = '*' 
THEN NULL(CHAR(11)) 
ELSE col2 
END AS col2
END AS SEQUENCE_NUM
FROM OPERATOR
(
FILE_READER()
ATTR
(
FileName = 'tbl1.out'
)
);
);