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>