troubleshooting Question

Informix 7.x

Avatar of aaddanki
aaddanki asked on
Databases
2 Comments1 Solution849 ViewsLast Modified:
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.



Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros