Does DataStage work with byte stream, binary files
?
A byte stream file was ftp'd from an HP3000 MPE/iX server to the ETL server (windows 2000).
The column values are enclosed in double quotes (") and the spaces within these are not lost
Comma (,) is the column delimiter
However, the newline character is converted to binary (vertical rectangular box) and is not recognized as line (row) terminator either by notepad or the datastage sequential file stage
So when trying to View Data thru the Sequential File Stage, it retrieves the entire file as one row and fails with the message:
CopyOfLoadProcDetail..TEST_PROC_DETAIL_RAW.From_Raw: read_delimited() - row 1, too many columns in record
Does DataStage work with byte stream, binary files?
-
Interview Candidate
- Jun 15th, 2007
- 0
- 4189
This Question is not yet answered!
Related Answered Questions
Related Open Questions
Does DataStage work with byte stream, binary files
A byte stream file was ftp'd from an HP3000 MPE/iX server to the ETL server (windows 2000).
The column values are enclosed in double quotes (") and the spaces within these are not lost
Comma (,) is the column delimiter
However, the newline character is converted to binary (vertical rectangular box) and is not recognized as line (row) terminator either by notepad or the datastage sequential file stage
So when trying to View Data thru the Sequential File Stage, it retrieves the entire file as one row and fails with the message:
CopyOfLoadProcDetail..TEST_PROC_DETAIL_RAW.From_Raw: read_delimited() - row 1, too many columns in record
Does DataStage work with byte stream, binary files?
This Question is not yet answered!
Related Answered Questions
Related Open Questions