Re: [Q];loading from file into the table
Posted in 1997
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Platform-Specific Issues
> > There is a file "fff" that consists of
> > K,H,28,3,
> > K,H,28,4,
> > K,H,28,5,
> > K,H,28,6
> >
> > And there is a table fff, having the structure:
> >
> > Column Name Type Length Index Nulls
> >
> > diap Char 1 Dups No
> > koef Char 1 No
> > space Smallint Yes
> > quality Smallint Yes
> >
> > When i run script "load from "fff" Delimiter "," insert into fff" using
> > dbaccess i got the next message:
> > 4 Numbers loaded
> > and then ;
> > 846: Number of values in load file is not equal to number of columns.
> > 847: Error in load file line 1.> > What can be the reason of that messages (846, 847) ? It does not matter
> that
> > there is no final comma on line 4.
> >
> > And the second question. When i try using esql and gcc v7.2 with Solaris
> 2.4 to compile
> > some program (esql ex.c) i got the next messages:
> >
> > gcc: language cg92 not recognized
> >
> > Undefined first referenced symbol in file
> > __cg92_used libsql.a(iqsimple.o)
> >
> > Can anyone tell me how can i use gcc instead of SUN cc (if there is such
> possibility of
> > course) ?
> >
> > Thanks in advance .
> >
> >
Thanks to all who replied me ,
These errors comes from blank line at EOF .
Cheers ,
Vitaly