If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > how to get more info for 'invalid format' error for onpladm on Windows?

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 02-10-10, 11:24
codemonkey73 codemonkey73 is offline
Registered User
 
Join Date: Feb 2010
Posts: 1
Question how to get more info for 'invalid format' error for onpladm on Windows?

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?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On