does there exist a list, what the eror's mean?
i have created a table:
CREATE TABLE "ACCOUNTING"."CISCO3640_200310"
(
"ID" Integer NOT NULL DEFAULT serial(1) ,
"SOURCE" Varchar (16) ASCII NOT NULL DEFAULT ' ',
"DESTINATION" Varchar (16) ASCII NOT NULL DEFAULT ' ',
"PACKETS" Integer,
"BYTES" Integer,
"TIMSTAMP" Timestamp NOT NULL,
PRIMARY KEY ("ID")
)
//
create index I_src on cisco3640br_200310 (source)
//
create index I_dst on cisco3640br_200310 (destination)
//
create index I_tims on cisco3640br_200310 (timstamp)i have a csv file with some lines (24801162)
24801161;127.0.0.1;217.74.2.26;1;40;20031101000002 24801162;217.74.0.10;217.74.1.247;10;1867;20031101000002
if i do a:
loadercli -d acct -u user,pw
dataload table accounting.cisco3640br_200310 infile ID 1 SOURCE 2 DESTINATION 3 PACKETS 4 BYTES 5 TIMSTAMP 6 infile '/tmp/tmp2/cisco3640br_200310.csv' separator ';'
i get:
ERR -25281 Syntax error at position 56 (Unexpected integer value: 1).
greetings thomas
Schildberg, Steffen wrote:
Hi Matt, found the problem.
matt rogers [mailto:[EMAIL PROTECTED] wrote:
C:\maxdb\programs\bin>
C:\maxdb\programs\bin>loadercli -u DBA,dba -d crap1
Loader Server Protocol File: 'c:\maxdb\data\wrk\loader.prt'
User DBA connected to database CRAP1 on local host. loadercli> DATALOAD TABLE dba.contacts contactid 1 surename 2 INFILE 'c:\maxdb\tests\contac ts.csv' SEPARATOR ';' ERR -25502 Error opening file '1': wrong file or device name.
I'm pretty sure the first column (contactid) of your table is defined as a long column, right? I was at least able to reproduce the error here with this assumption. To load longs (as short they ever might be) it is necessary to specify a long data file. Your command should look like this
DATALOAD TABLE dba.contacts contactid 1 surename 2 INFILE 'c:\maxdb\tests\contacts.csv' SEPARATOR ';' LONGFILE contactid '<your_long_file_name>'
The corresponding content of contacts.csv then must be for your data
"1-1";"Smith" "2-2";"Robinson" "3-3";"Cage"
The data in your longfile then must be 123
Well, actually the Loader should report a different error message (from that reporting in your case) saying that there is the longfile info missing. Obviously this got lost 'in space' in the current version. We'll correct that asap.
Sorry for any inconvenience. If more problems arise with the Loader let me know.
Regards, Steffen
-- # Thomas Stegbauer # http://www.keyserver.de:11371/pks/lookup?op=get&search=0xFF837A1A # Key fingerprint = E469 F5DC 42FB B530 F5CB 99CB CEB2 BFC6 FF83 7A1A
pgp00000.pgp
Description: PGP signature
