[Last Call] Learn how to a build a cloud-first strategyRegister Now


Informix 7.x

Posted on 2009-12-16
Medium Priority
Last Modified: 2013-12-24
Hi ,
I have a flat file that i generated from the database with a simple pipe statements as follows
select col1||'||col2 ...... from table_name
and spooled that into a file and tried to use the dbload as follows
dbload -c E:\LX_LOG\dbl -d pstruct -l E:\LX_LOG\dbl_error.err -n 1000
but i got back the follwoing error :
The # of fields in the load file does not match the # on the FILE line
the contents of the dbl file are as follows
0-1532028-2|61880250603|ESP-R-025-P5-1-H26E3-18.0-603                               |0-1532028-2.dwg                         |AUTO-CAD-DWGS                           |
 that is the file i initially generated (flat file i spoeke about in the first line)
Whats the issue here :

And also when i try to dbimport a dmp file using the following
dbimport pstruct -d ol_unistarpesv -i E:\OL_UNISTARPESV_DUMP

It just stays there without spitting out anything.
Is this a privilege issue.

Kindly suggest.

Question by:aaddanki

Expert Comment

ID: 26072769
Hi, I've had similar problems due to end of line characters. Try removing the final | character from the end of the line. Try a small sample of the file first.

Or, have we FTP'd the file from UNIX to Windows/Dos bnecause they use different end of line characters and that can cause a problem as well (DOS uses CR LF, Unix use LF). FTP the file as ASCII to revent this problem.


Accepted Solution

aaddanki earned 0 total points
ID: 26193349
hope i have to find this myself.
Thanks experts for the suggessions.

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

826 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question