Simple INSERT not working.
Posted: Tue Jul 15, 2014 8:34 am
I'm trying to do a READCSV to a rowset and then insert the rowset into an i-Series file. I've simplified this down to one field in both the rowset and i-Series file. The first error in the joblog is "Last known record near boundaries...", which after reading other forum entries tells me there may be something wrong with my data, but I don't see anything wrong. The next error is "Descriptor index not valid".
Attached is the CSV file and the joblog. Below is the XML listing. Can anyone tell what I'm doing wrong here?
Attached is the CSV file and the joblog. Below is the XML listing. Can anyone tell what I'm doing wrong here?
Code: Select all
<project name="Get File From Concur - SQL test" mainModule="Main" version="2.0" logLevel="verbose">
<module name="Main">
<createWorkspace version="1.0" />
<readCSV inputFile="/QOpenSys/Concur/TempFIles/tfile1.txt" outputRowSetVariable="locrowset" fieldDelimiter="pipe" skipInvalidRecords="true" skipFirstRow="false" recordDelimiter="CRLF" version="1.0">
<data trim="none" nullIndicator="*">
<column index="3" name="Batch Date" size="10" type="CHAR" trim="both" nullIndicator="*" />
</data>
</readCSV>
<sql label="Connect to AS400" resourceId="AS400a" version="1.0" disabled="false">
<query label="Import into PF" inputRowSetVariable="${locrowset}" outputVariable="tmpresult" nullSubstitute="*" whenNoDataFound="continue">
<statement>INSERT INTO PTLIB.CONCURTST(BATCHDT) VALUES(?)</statement>
</query>
</sql>
<deleteWorkspace version="1.0" disabled="false" />
</module>
</project>