FTP issue from ETL Server to Mainframe
Posted: Wed Oct 10, 2007 8:46 pm
JOB:
I read a SQL Server Table and then populate a text file(orderdetails.txt). Total record length of text file is 160 characters (total 15 columns).
SEQUENCER:
Once the job completes successfully, I am running a shell script (as below) that connects to a mainframe server and puts the text file
------------------------------------------------------------
FTP <host Name>
UserID
Password
LCD /dir/textfiledir/
put orderdetails.txt 'CRHY.PROD.ORDERDET'
bye
-------------------------------------------------------------
Issue:
Everything runs fine, only when I login to mainframe to see 'CRHY.PROD.ORDERDET' it has ONLY 80 characters record length. Rest all columns values are just gone
Question:
What command should I put in my FTP script, so that it transfers COMPLETE RECORD LENGTH to the mainframe server?
I read a SQL Server Table and then populate a text file(orderdetails.txt). Total record length of text file is 160 characters (total 15 columns).
SEQUENCER:
Once the job completes successfully, I am running a shell script (as below) that connects to a mainframe server and puts the text file
------------------------------------------------------------
FTP <host Name>
UserID
Password
LCD /dir/textfiledir/
put orderdetails.txt 'CRHY.PROD.ORDERDET'
bye
-------------------------------------------------------------
Issue:
Everything runs fine, only when I login to mainframe to see 'CRHY.PROD.ORDERDET' it has ONLY 80 characters record length. Rest all columns values are just gone
Question:
What command should I put in my FTP script, so that it transfers COMPLETE RECORD LENGTH to the mainframe server?