I have a similar scenario to the one here from awhile ago:

http://groups.google.com/group/comp....8d2320bd7c761c

I have around 160 tables to load, using pipe-delimited text files. We
have an older series of batch files that a previous developer wrote to
load Informix data, but they're not working with the new version of
Informix (11.5) that I installed. I'm running it on a Windows 2003
server.

I've modified the batch file to execute the onpladm commands for one
file, so this batch file looks like this;

onpladm create project dif31US-1-table-Load

onpladm create object -F diffdbagidaxsid.dev
onpladm create object -F diffdbagidaxsid.fmt
onpladm create object -F diffdbagidaxsid.map
onpladm create object -F diffdbagidaxsid.job

When I run this, it successfully creates the project and device array,
but I get an error creating the format. The only error I get is:

Create object DELIMITEDFORMAT diffile1fmt failed!
Invalid format!

The diffdbagidaxsid.fmt file is as follows:

BEGIN OBJECT DELIMITEDFORMAT diffile1fmt

PROJECT dif31US-1-table-Load
CHARACTERSET ASCII
RECORDSTART
RECORDEND
FIELDSTART
FIELDEND
FIELDSEPARATOR |
BEGIN SEQUENCE
FIELDNAME agid
FIELDTYPE Chars
END SEQUENCE
BEGIN SEQUENCE
FIELDNAME axsid
FIELDTYPE Chars
END SEQUENCE

END OBJECT

As you can see, it is only 2 columns. It originally had nothing
following the CHARACTERSET. I've tried it with ASCII, and with the
numeric code for ASCII, and still get the same error.

Is there any way to get a more verbose error message?

Brian wrote:
File format looks OK

Are there any hidden / weird characters in the file?

JWC