Hello list,
I'm trying to load data with loadercli, my max-db version is 7.6.00.16
under SLES9.
I'm using the SEQNO-clause for the field "GE_ID", running loadercli leads to an
"Memory fault".
Omitting the SEQNO-clause, it works.
In the loader.prt file, I see:
// *
// M Loader 7.6.00 Build 016-121-109-428
// *
// M Loader instance started at krz7 for database ZUVDB
// *
// M Starting protocol at 2006050900165303
// *
// M START 20060509 00165303
// *
SET
// *
// M START 20060509 00165303
// *
USE USER "ADMSYS_ADM" * SCHEMA ADMSYS_ADM SERVERDB "ZUVDB"
// *
// M USER: 'ADMSYS_ADM' on DB: 'ZUVDB' ISOLATION LEVEL: 3
// *
// M START 20060509 00165305
// *
import columns table gesporig_ukl reject duplicates
ge_ueberzeit '20060509040500'
ge_id SEQNO 1 1
ge_leitung 1-5
ge_nebenstelle 9-18
ge_extnr 32-53
ge_telzeit 60-73
ge_einheiten 74-77
ge_dienst 78-78
ge_kzpd 87-90
data instream file '/home/sdb/teldat/DT.HICOM.UKL.09052006.040500' formatted
TIMESTAMP 'YYYYMMDDHHMMSS'
// *
// M Import PACKAGE x'01000000D1AC60443C2500000D7F7C1FC407C1C4FFFFFFFF'
// *
// M Execute PACKAGE to transform DATA
// *
// M Number of TABLES to transform: 0
// *
The table is defined like this:
CREATE TABLE "ADMSYS_ADM"."GESPORIG_UKL" (
"GE_UEBERZEIT" CHAR(26) ASCII ,
"GE_ID" FIXED(10,0) ,
"GE_URKNOTEN" CHAR(3) ASCII ,
"GE_KZPD" CHAR(4) ASCII ,
"GE_NEBENSTELLE" CHAR(10) ASCII ,
"GE_EXTNR" CHAR(22) ASCII ,
"GE_DIENST" CHAR(1) ASCII ,
"GE_LEITUNG" CHAR(5) ASCII ,
"GE_EINHEITEN" CHAR(4) ASCII ,
"GE_CARRIER" CHAR(2) ASCII ,
"GE_TELZEIT" TIMESTAMP
, PRIMARY KEY ("GE_UEBERZEIT"
,"GE_ID"
))
Did somebody already tried the SEQNO-clause? Did it work?
Greetings
Uli
____________________________________________________
Ulrich Lickert, Universitaetsklinikum Freiburg
Klinikrechenzentrum, Agnesenstr. 6-8, D-79106 Freiburg
Tel +49-761-270-2265 Fax +49-761-270-2066
E-Mail [EMAIL PROTECTED]
WWW: http://www.uniklinik-freiburg.de/
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
