InfoSphere Datastage Complex Flat File stage (CFF) error with reject file

Technote (troubleshooting)


Problem(Abstract)

InfoSphere Datastage Complex Flat File stage (CFF) produces "Record format type=implicit: cannot save rejected records." error with reject file

Cause

Variable length record files processed through CFF stage with reject not supported. In this case, file was fixed length, but the osh code generated showed record format of implicit.

Diagnosing the problem

First evaluate the file to determine if file is truly fixed length. To do this, divide the record length defined in table definition into the size of the source data file. Also determine what code page is defined for the job. It must be a single byte character set. Reject files are not supported when processing a variable length file.

Resolving the problem

Source file must be fixed length and character set must not contain multi-byte characters as this will change the record format to implicit as the record will be variable length due to possible multi-byte characters.

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere DataStage

Software version:

7.5, 8.0.1, 8.1, 8.5, 8.7

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1614643

Modified date:

2012-11-04

Translate my page

Machine Translation

Content navigation