Hi all again
So, now I have 2 Files, a Command-File(test3.sql) and a Source
File(test4.sql).
The Commandfile has that content:
create table fastlTest
(
nr int,
name varchar(50)
)
//
FASTLOAD table fastlTest
nr 1
name 2
INFILE '/home/sapdb/test4.sql'
and the source-file:
1,hallo
2,holger
But with the command:
./repmcli -d testdb -u dbadmin,admin -b /home/sapdb/test3.sql
I get the following error:
User DBADMIN connected to database TESTDB on local host.
create table fastlTest
(
nr int,
name varchar(50)
)
Successfully executed
FASTLOAD table fastlTest
nr 1
name 2
INFILE '/home/sapdb/test4.sql'
Error during execution
-->-25319
Missing data for specified column NAME.
Defined maximum number of errors (1) reached
1 error(s) during execution of command file '/home/sapdb/test3.sql'.
---> See log file(s) for more information.
Some error(s) occurred running command.
---> See log file(s) for more information.
So, whats wrong with that INFILE?
Danny
> Danny Tramnitzke wrote:
> > Hi all
> >
> > Is it possible to insert values in a sapdb-table with a functionality
> like
> > "byte copy"?
> > So when I have the table "perso" with
> >
> > (
> > nr smallint,
> > name char(50),
> > start date
> > )
> >
> > and a external, tab-seperated file called "tablevalues" with content:
> >
> > 1 Mueller 09-12-00
> > 2 Schulz 31-01-78
> >
> > How can I get the content of "tablevalues" into table "perso", without
> to
> > make a "insert into" in each line?
> >
> > Danny
> >
>
> look for repmcli in the docs. This tool does exactly what you want.
>
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
NEU: Mit GMX ins Internet. Rund um die Uhr f�r 1 ct/ Min. surfen!
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
