Hello,
I get wrong values in loading LONG ASCII
It seems that the offsets are wrong interpreted.
I get the first 3 characters of the "long File" in every row
an miss the trailing ones.
--- my BATCH file is ------------------------------
SQLMODE INTERNAL
//
CREATE TABLE "TEST"."EVASCRIPT" (
"ESID " INTEGER ,
"MANID " INTEGER ,
"AMTID " INTEGER ,
"NAME " VARCHAR (64) ASCII ,
"DTA " LONG ASCII ,
"WER " INTEGER ,
"WANN " TIMESTAMP ,
"STATE " CHAR (1) ASCII
, PRIMARY KEY ("ESID"
))
//
DATALOAD TABLE "TEST"."EVASCRIPT"
"ESID" 1 CHAR
"MANID" 2 CHAR DEFAULT NULL
"AMTID" 3 CHAR DEFAULT NULL
"NAME" 4 CHAR DEFAULT NULL
"DTA" 5 CHAR DEFAULT NULL
"WER" 6 CHAR DEFAULT NULL
"WANN" 7 CHAR DEFAULT NULL
"STATE" 8 CHAR DEFAULT NULL
INFILE 'EVASCRIPT.data'
DECIMAL '/ /./'
DATE 'INTERNAL'
TIME 'INTERNAL'
TIMESTAMP 'INTERNAL'
NULL '-?- '
BOOLEAN 'TRUE /FALSE '
SEPARATOR ',' DELIMITER '"'
//
-------------- EVASCRIPT.data -----------------------
100 000,100 002,100 001,"Preisliste 1","'EVASCRIPT.DTA.long' 1-8",100
000,20040425205313069964,-?-
100 001,100 002,100 001,"Preisliste 2","'EVASCRIPT.DTA.long' 9-28",100
000,20040425205520881690,-?-
100 002,100 002,100 001,"Preisliste 3","'EVASCRIPT.DTA.long' 29-49",100
000,20040425205557251284,-?-
100 003,100 002,100 000,"Preis alle 3 ","'EVASCRIPT.DTA.long' 50-220",100
001,20040506150628333778,-?-
100 004,100 002,100 000,"Preis alle 4 ","'EVASCRIPT.DTA.long' 221-391",100
001,20040506150620401477,-?-
100 005,100 002,100 000,"Preis alle 2 ","'EVASCRIPT.DTA.long' 392-562",100
001,20040506150440702763,-?-
100 006,100 002,100 000,"TESTDATEN","'EVASCRIPT.DTA.long' 563-603",100
000,20050103153216855375,-?-
--------------- EVASCRIPT.DTA.long ( $ = \n !)
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> cat -A EVASCRIPT.DTA.long
Kost nixKost sehr $
viel mehrIst richtig$
sau teuerPA1*1*300*$
PA1*2*300*$
PA1*3*300*$
PA1*4*300*$
PA1*5*300*$
PA1*6*300*$
PA1*7*300*$
PA1*8*300*$
PA1*9*300*$
PA1*10*300*$
PA1*11*300*$
PA1*12*300*$
PA1*13*300*$
PA1*14*300*$
PA1*15*300*$
PA1*1*400*$
PA1*2*400*$
PA1*3*400*$
PA1*4*400*$
PA1*5*400*$
PA1*6*400*$
PA1*7*400*$
PA1*8*400*$
PA1*9*400*$
PA1*10*400*$
PA1*11*400*$
PA1*12*400*$
PA1*13*400*$
PA1*14*400*$
PA1*15*400*$
PA1*1*200*$
PA1*2*200*$
PA1*3*200*$
PA1*4*200*$
PA1*5*200*$
PA1*6*200*$
PA1*7*200*$
PA1*8*200*$
PA1*9*200*$
PA1*10*200*$
PA1*11*200*$
PA1*12*200*$
PA1*13*200*$
PA1*14*200*$
PA1*15*200*$
Diers ist ein testtext fM-|r PUTFILE Sofort
-------------------SELECT * from EVASCRIPT ----------------------
select * FROM EVASCRIPT
ESID MANID AMTID NAME DTA WER WANN STATE
100000 100002 100001 Preisliste 1 Kost nix 100000 2004-04-25
20:53:13.069964 ?
100001 100002 100001 Preisliste 2 KosKost sehr .viel m 100000
2004-04-25 20:55:20.881690 ?
100002 100002 100001 Preisliste 3 KosIst richtig.sau te 100000
2004-04-25 20:55:57.251284 ?
100003 100002 100000 Preis alle 3 KosPA1*1*300*.PA1*2*300*.PA1*3*
100001 2004-05-06 15:06:28.333778 ?
100004 100002 100000 Preis alle 4 KosPA1*1*400*.PA1*2*400*.PA1*3*
100001 2004-05-06 15:06:20.401477 ?
100005 100002 100000 Preis alle 2 KosPA1*1*200*.PA1*2*200*.PA1*3*
100001 2004-05-06 15:04:40.702763 ?
100006 100002 100000 TESTDATEN KosDiers ist ein testtext für P
100000 2005-01-03 15:32:16.855375 ?
------------------------------------------------------------------
if you nee the original files for test just mail me.
any idea ?
regards
jph
___________________________
Dipl.-Ing. Jens-Peter C. Hillers
Remote Web Services GmbH
Tel: +49 40 25 49 06 22
Fax: +49 40 36 00 67 27
Email: [EMAIL PROTECTED]
____________________________
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
