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
