Informix 7.x

Posted on 2009-12-16
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
    LVL 5

    Expert Comment

    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

    hope i have to find this myself.
    Thanks experts for the suggessions.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    This article describes some very basic things about SQL Server filegroups.
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now