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

Reply via email to