Hi Hemant, Hemant Gohil [mailto:[EMAIL PROTECTED] wrote: > > Hi, > I am new to sap db. > I am trying to load DB table from a tab('\t') delimited file > and for some or other reason it keep giving me errors. > > I am attaching my loadercli command file. > Table qryTimings is already created using SQL Studio. > > ============== > SET COMPRESSED ' /\t//' > > // > FASTLOAD TABLE qryTimings > qryExecutedOn 1 > jctsId 2 > qryExecutionTime 3 > qryType 4 > sqlPart1 5 > sqlPart2 6 > INFILE 'D:\tools\sapdb\mySQLs\atlas1.dat' COMPRESSED > ============== > any and all help will be appreciated. > > The loader still lacks the ability to specify tab as delimiter in the form you did ('\t'). If you instead specify it this way SET COMPRESSED '/<tab>//'
(and I mean here really hitting <tab> and not writing <tab> literally) it should work. Well, an error message would have been helpful anyway ;-) Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
