Dear Ah Heng, [[EMAIL PROTECTED] wrote]
> Subject: Need help in using replication manager > I have made a simple test, > create a new table (atest) in SAP DB (tst), and prepare the > csv file and command file in the following format: > > a) command file (addnew.dat) > FASTLOAD TABLE atry > id 1 > Desc 2 > INFILE 'd:\sapdb\oradata\alee.txt' COMPRESSED > / > commit > > b) csv file (alee.txt) > 2,user2 > 3,user3 > 4,user4 > 5,user5 > > 3) command used: > d:\> repmcli -u test,test -d tst -b addnew.dat > > Can anyone kindly advise me on the correct approach and > format of csv file? > The format of the CSV file is ok. But you need to specify separator and/or delimiter in the command if you do not use the default values. Default separator is comma (as in your example) but the default delimiter is double quotes whereas yours is empty. So your command should look like this: FASTLOAD TABLE atry id 1 Desc 2 INFILE 'd:\sapdb\oradata\alee.txt' COMPRESSED DELIMITER '' / commit Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
