Hi,
I am using Fujitsu COBOL version 6. I am trying to
insert rows into a simple Access table that I created
locally but I never can get records to insert.
The SQL trace log looks ok and running in the debug
mode the sqlstate is always 0000 but no records are
written to the table.
Here is the insert code. Have used same code in remote
odbc and it works.
EXEC SQL
INSERT INTO GL3DIFF_DTL(GL3DIFF_BATCHNO, GL3DIFF_IMAGENO,
GL3DIFF_FLDDESC, GL3DIFF_MIS1FLD, GL3DIFF_MIS2FLD)
VALUES
DTL-BATCH-NBR, TL-IMAGE-NBR,
TL-FLD-DESC, TL-MIS1-FLD, TL-MIS2-FLD)
any help would be greatly appreciated.
thanks,
END-EXEC.
I am using Fujitsu COBOL version 6. I am trying to
insert rows into a simple Access table that I created
locally but I never can get records to insert.
The SQL trace log looks ok and running in the debug
mode the sqlstate is always 0000 but no records are
written to the table.
Here is the insert code. Have used same code in remote
odbc and it works.
EXEC SQL
INSERT INTO GL3DIFF_DTL(GL3DIFF_BATCHNO, GL3DIFF_IMAGENO,
GL3DIFF_FLDDESC, GL3DIFF_MIS1FLD, GL3DIFF_MIS2FLD)
VALUES
DTL-BATCH-NBR, TL-IMAGE-NBR, TL-FLD-DESC, TL-MIS1-FLD, TL-MIS2-FLD)any help would be greatly appreciated.
thanks,
END-EXEC.