1111111111aaaaaaaaaaaaaaaaaaaaaaaaa 11111111.11
2222222222bbbbbbbbbbbbbbbbbbbbbbbbb-22222222.22
3333333333ccccccccccccccccccccccccc 33333333.33

PARTNBR             Character                   10      
DESCRIPTION         Character                   25       
PRICE               Packed Dec                  10,2 

<project name="Fixed-width to database" mainModule="Main" version="1.0" logLevel="debug">

	<module name="Main">
		<createWorkspace />

		<ftp label="Connect to FTP server" resourceId="Dev 54">
			<get label="Get Fixed-width File" sourceFile="/Demo/TEST1.TXT" destinationDir="${system.job.workspace}" type="binary" destinationFilesVariable="fixedwidthFile" />
		</ftp>

		<readFixedWidth label="Read Fixedwidth File" inputFile="${fixedwidthFile}" outputRowSetVariable="fixedwidthData" skipFirstRow="false" recordDelimiter="CRLF">
			<data>
				<column index="1" name="PARTNBR" type="CHAR" size="10" alignment="left" />
				<column index="2" name="DESCRIPTION" type="CHAR" size="25" alignment="left" />
				<column index="3" name="PRICE" size="12" alignment="right" />
			</data>
		</readFixedWidth>


		<sql label="Connect to DB" resourceId="DEV54">
			<query label="clear out file">
				<statement>DELETE 
FROM 
	DEMO.TEST3
</statement>
			</query>
			<query label="Import Data" inputRowSetVariable="${fixedwidthData}">
				<statement>INSERT INTO DEMO.TEST3
	(PARTNBR, DESCRIPTION, PRICE)
VALUES
	(?, ?, ?)</statement>
			</query>
		</sql>


		<deleteWorkspace />

	</module>

	<description>FTP Get Fixed-width file and insert into Database</description>
</project>