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|UK01|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 ?
---------------------------------------------------------------
Nicolas JOUANIN - SA REGIE FRANCE
Village Informatique BP 3002
17030 La Rochelle CEDEX
Tel: 05 46 44 75 76
Fax: 05 46 45 34 17
email: [EMAIL PROTECTED]
Web : www.regie-france.com
---------------------------------------------------------------
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
