Hi Team,
Happy New Year to all!!
Informatica team is sending files to mainframe, but alignment is not properly there in mainframe saide.
Could you please tell me is there any specific command we need to include before input file to get data aligned properly.
Input:
ABCDEFGHIJKLMNOP ABCDEFGHIJKLMNOPQRSTUVWX 001.00000000000.00000071161.1100.00005.00
ABCDEFGHIJKLMNOP ABCDEFGHIJKLMNOPQRSTUVWX 001.00000071161.11000071161.1100.00000.00
ABCDEFGHIJKLMNOP ABCDEFGHIJKLMNOPQRSTUVWX 001.00000000000.00000071161.1100.00020.00
Output:
ABCDEFGHIJKLMNOP ABCDEFGHIJKLMNOPQRSTUVWX 001.00000000000.00000071161.1100.00005.00 ABCDEFGHI
JKLMNOPQRSTUVWX 001.00000071161.11000071161.1100.00000.00 ABCDEFGHIJKLMNOP ABCDEFGHIJKLMNOPQ
RSTUVWX 001.00000000000.00000071161.1100.00020.00
Thank you in Advance.
Alignement command for receiving files
-
Loganathan Arumugam
- Posts: 4
- Joined: Thu Mar 05, 2015 2:27 am
Re: Alignement command for receiving files
This appears to be a problem with the Co:Z SFTP settings that were used, which prevented the line terminators from being recognized as record delimiters.
If your client is sending a text file to z/OS Co:Z SFTP with newline characters, you would want to use something like:
mode=text,linerule=flexible
To diagnose, you will need to enable tracing for the Co:Z SFTP server and capture a session log.
To temporarily enable tracing (without adding commands to the remote client's script), you can add these lines to your $HOME/.ssh/sftp-server.rc script:
export SFTP_SERVER_OPTIONS="-e -l debug3"
export COZ_LOG=T
(For more information on this file, see: http://dovetail.com/docs/sftp/config.ht ... _server_rc)
If you need assistance, please have your Co:Z Support contact open a ticket, since your company has an Enterprise License and Support Agreement.
If your client is sending a text file to z/OS Co:Z SFTP with newline characters, you would want to use something like:
mode=text,linerule=flexible
To diagnose, you will need to enable tracing for the Co:Z SFTP server and capture a session log.
To temporarily enable tracing (without adding commands to the remote client's script), you can add these lines to your $HOME/.ssh/sftp-server.rc script:
export SFTP_SERVER_OPTIONS="-e -l debug3"
export COZ_LOG=T
(For more information on this file, see: http://dovetail.com/docs/sftp/config.ht ... _server_rc)
If you need assistance, please have your Co:Z Support contact open a ticket, since your company has an Enterprise License and Support Agreement.