Re: how to get more info than 'INVALID FORMAT' error with onpladm on Windows?
Brian wrote:
> I have a similar scenario to the one here from awhile ago:
>
> http://groups.google.com/group/comp.databases.informix/browse_thread/thread/53b7139761e2dcc3/938d2320bd7c761c?lnk=gst&q=%22Invalid+format%22#938d2320bd7c761c
>
> 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?
File format looks OK
Are there any hidden / weird characters in the file?
JWC