i am using the following code, but running into errors
bteq
.logon DB/U_NAME,*******;
.SET ECHOREQ off
.defaults
.set errorout stderr;
.import REPORT file = sb_nonatm_data.txt
.quiet on
.repeat*
using (ASOF_YYYYMM char(6),CO_ID char (3),ACCT_NUM4 CHAR(5),Segment_Code CHAR(1),ECN DEC(15,0),
PCODE CHAR(2),PCODE_DESC CHAR(40),tran_cnt char (3))
insert into DTUAU.SK_0804_ATM_FEE_LOB_FILE_2 (ASOF_YYYYMM,CO_ID,ACCT_NUM4,Segment_Code,ECN,PCODE,PCODE_DESC,tran_cnt)
values(:ASOF_YYYYMM,:CO_ID,:ACCT_NUM4,:Segment_Code,:ECN,:PCODE,:PCODE_DESC,:tran_cnt)
.quit
;
-------------------------
ERROR
-------------------------
.quit.SET ECHOREQ off
.defaults
.set errorout stderr;
*** Starting Row 0 at Thu Mar 20 13:22:57 2008
.quit.SET ECHOREQ off
$
*** Failure 3706 Syntax error: expected something between ')' and '.'.
Statement# 2, Info =360
*** Total elapsed time was 1 second.
*** Warning: Repeat is cancelled.
*** Finished at input row 1 at Thu Mar 20 13:22:57 2008
*** Total number of statements: 1, Accepted : 0, Rejected : 1
*** Total elapsed time was 1 second.
BTEQ -- Enter your DBC/SQL request or BTEQ command:
.import REPORT file = 'sb_nonatm_data.txt'
.import REPORT file = 'sb_nonatm_data.txt'
BTEQ -- Enter your DBC/SQL request or BTEQ command:
.quiet OFF
.quiet OFF
BTEQ -- Enter your DBC/SQL request or BTEQ command:
.repeat*
using (ASOF_YYYYMM char(6),CO_ID char (3),ACCT_NUM4 CHAR(5),Segment_Code CHAR(1),ECN DEC(15,0),
.repeat*
BTEQ -- Enter your DBC/SQL request or BTEQ command: