Hi, That works, thanks to your help. But, when I try to load datas with a empty file I get the following message: Error during execution -->-25362 No data to load in datafile /users/ifmxdata/qw_regie.exp/y01__00100.unl.
Is there a way to tell loadercli no to report an error when data stream is empty, just keep on ? other thing : I noticed that when data fields or table name contains digits 0-9 you have to put them between double quotes and uppercase, else it doesn't work. May be I made a mistake, but that's what I noticed . Nicolas. > -----Message d'origine----- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] la part de Bumes, > Hans-Georg > Envoy� : mardi 15 juillet 2003 17:11 > � : [EMAIL PROTECTED] > Cc : 'Nicolas JOUANIN' > Objet : RE: Loading datas without column specification > > > Hi Nicolas, > > > - Is it possible to load datas without specifying columns ? > > which should be possible knowing the delimiter and the > table structure. > > no, you have to declare an explicit mapping from record-fields in > the file to > row-columns in the table > > > - what is the the correct instruction to load such a file ? > > you can use the dataextract for dataload or dataextract for > fastload statement > to generate most part of the loadstatement. > the ( sligthly modified ) result for your tabledefinition is. > > // > SET COMPRESSED '/|//' > // > FASTLOAD WITH 80% USAGE TABLE "BRA" > "BRA_ID" 1 CHAR > "CPY_ID" 2 CHAR > "CUR_ID" 3 CHAR > "LNG_ID" 4 CHAR > "THR_ID" 5 CHAR > "XDV_ID" 6 CHAR DEFAULT NULL > "BRA_SCREEN" 7 CHAR > "BRA_MAIN" 8 CHAR > "BRA_TAX_TRADEIN" 9 CHAR > "BRA_EECEXP" 10 CHAR DEFAULT NULL > "BRA_EECIMP" 11 CHAR DEFAULT NULL > "XCL_ID" 12 CHAR DEFAULT NULL > "BRA_ID_SETTING" 13 CHAR > "BRA_ID_DEFAULT" 14 CHAR > "BRA_ID_PRICING" 15 CHAR > "BRA_ID_WAP" 16 CHAR > "BRA_MEASURE" 17 CHAR > "TAD_ID" 18 CHAR DEFAULT NULL > "BRA_ACCT" 19 CHAR DEFAULT NULL > "BRA_ID_AR" 20 CHAR DEFAULT NULL > INSTREAM FILE 'bra.dat' > COMPRESSED ASCII > DECIMAL '//./' > DATE INTERNAL > TIME INTERNAL > TIMESTAMP INTERNAL > NULL '' > BOOLEAN 'TRUE/FALSE' > // > > -- > Hans-Georg Bumes > SAP DB, SAP Labs Berlin > http://www.sapdb.org/ > > > > -----Original Message----- > > From: Nicolas JOUANIN [mailto:[EMAIL PROTECTED] > > Sent: Dienstag, 15. Juli 2003 14:14 > > To: sapdb > > Subject: Loading datas without column specification > > > > > > Hi, > > > > still tying to migrate ..... here's the next trick. > > > > Let's say a table: > > create table bra > > ( > > bra_id char(4) not null , > > cpy_id char(4) not null , > > cur_id char(3) not null , > > lng_id char(3) not null , > > thr_id integer not null , > > xdv_id decimal(4,0), > > bra_screen char(15) not null , > > bra_main decimal(1,0) > > default 0 not null , > > bra_tax_tradein decimal(1,0) > > default 1 not null , > > bra_eecexp decimal(1,0) > > default 0, > > bra_eecimp decimal(1,0) > > default 0, > > xcl_id char(6), > > bra_id_setting char(4) not null , > > bra_id_default char(4) not null , > > bra_id_pricing char(4) not null , > > bra_id_wap char(4) not null , > > bra_measure decimal(1,0) > > default 0 not null , > > tad_id integer, > > bra_acct char(4), > > bra_id_ar char(4) > > ) > > > > and a data file (bra__00401.unl): > > 01|0001|EUR|1|6||TP LR|1.0|0.0|1.0|1.0|FRANCE|01|01|01|01|1.0|6||01| > > 02|0001|EUR|1|8||TP Paris|0.0|0.0|||FRANCE|01|01|01|01|1.0|8||01| > > 03|0001|EUR|1|9||TP Lyon|0.0|0.0|||FRANCE|01|01|01|01|1.0|9||01| > > AG01|0002|EUR|1|969||AG > > LR|1.0|0.0||||AG01|AG01|AG01|AG01|1.0|971||AG01| > > AG02|0002|EUR|1|970||AG > > Lyon|0.0|0.0||||AG01|AG01|AG01|AG01|1.0|972||AG01| > > LC01|0005|EUR|1|975||LC > > LR|1.0|0.0||||LC01|LC01|LC01|LC01|1.0|977||LC01| > > LC02|0005|EUR|1|976||LC > > Toulouse|0.0|0.0||||LC01|LC01|LC01|LC01|1.0|978||LC01| > > LC03|0005|EUR|1|977||LC > > Marseille|0.0|0.0||||LC01|LC01|LC01|LC01|1.0|979||LC01| > > NG01|0004|EUR|1|978||NG > > Paris|1.0|0.0||||NG01|NG01|NG01|NG01|1.0|980||NG01| > > PL01|0003|EUR|1|979||PL > > Nantes|1.0|0.0||||PL01|PL01|PL01|PL01|1.0|981||PL01| > > UK01|2001|EUR|0|989||UK > > Birmingham|1.0|0.0||||UK01|UK01|UK01|UK01|1.0|999||UK01| > > IM01|IMUK|EUR|0|997||IM > > Brussels|1.0|0.0|||FRANCE|IM01|IM01|IM01|IM01|1.0|1009||IM01| > > UK02|2001|EUR|0|1006||London|0.0|0.0||||UK01|UK01|UK01|UK02|1. > > 0|1019||UK01| > > UK03|2001|GBP|0|1007||Liverpool|0.0|0.0|||FRANCE|UK01|UK01|UK0 > > 1|UK03|1.0|102 > > 0||UK01| > > > > I found easy to use loadercli to create the table AND fill > > the data at the > > same time, so I put the following instruction AFTER the table > > creation: > > > > FASTLOAD > > TABLE bra > > INFILE '/users/ifmxdata/qw_regie.exp/bra__00401.unl' > > DELIMITER '|' > > NULL '' > > > > Error during execution > > -->-25319 > > Missing data for specified column CPY_ID. > > > > My questions are: > > - Must I precise columns in the fastload commande like: > > FASTLOAD TABLE bra > > bra_id 1 > > cpy_id 2 > > .... > > - Is it possible to load datas without specifying columns ? > > which should be possible knowing the delimiter and the table structure. > > - what is the the correct instruction to load such a file ? > > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
