UNIX files vs DOS files
Posted: Sat Jun 09, 2001 7:28 am
Hi All,
We have a situation we are loading the same layout file sourced from UNIX and NT. Now UNIX files have a newline that consists only of a Linefeed whereas the NT files have a newline that is a Carriage Return and a Linefeed. In the Sequential File Stage I can specify whether this file is a Unix or DOS file but Id like to be able to process these through the same job.
Now, if I write a bit of job control to OpenSeq the file, and ReadSeq a few lines, I find that Universe treats the two files as identical (ie the length of a line is the same in both).
How can I get DataStage to be as file friendly?
Or
How can I determine in Universe Basic if the file is of Unix or DOS format?
thanks,
Gavin
*******************Confidentiality and Privilege Notice*******************
This email is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply email. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Visit Qantas online at http://www.qantas.com
We have a situation we are loading the same layout file sourced from UNIX and NT. Now UNIX files have a newline that consists only of a Linefeed whereas the NT files have a newline that is a Carriage Return and a Linefeed. In the Sequential File Stage I can specify whether this file is a Unix or DOS file but Id like to be able to process these through the same job.
Now, if I write a bit of job control to OpenSeq the file, and ReadSeq a few lines, I find that Universe treats the two files as identical (ie the length of a line is the same in both).
How can I get DataStage to be as file friendly?
Or
How can I determine in Universe Basic if the file is of Unix or DOS format?
thanks,
Gavin
*******************Confidentiality and Privilege Notice*******************
This email is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply email. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Visit Qantas online at http://www.qantas.com