Ok, thanks all! That example runs now. But another problem: I have a Table with datatype "date". What form must a value have(in the INFILE), to get it into a date-variable?
best regards Danny > Hi Danny, > > Danny Tramnitzke wrote: > > > > 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: > > > > Error during execution > > -->-25319 > > Missing data for specified column NAME. > > > > So, whats wrong with that INFILE? > > > Nothing is wrong with your INFILE. But you need to adapt your > FASTLOAD command to get data loaded thats not included in > delimiters (the default is double qoutes): > FASTLOAD table fastlTest > nr 1 > name 2 > INFILE '/home/sapdb/test4.sql' > DELIMTER '' > > Regards, > Steffen > -- > Steffen Schildberg > SAP DB Team > SAP Labs Berlin > _______________________________________________ > 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
