Hello,
I'm trying to extract a user catalog and table...
To extract the catalog I do the following action
./loadercli -d TEST -u DBA,DBA
USE USER PSF PSF
CATALOGEXTRACT USER OUTSTREAM FILE '/tmp/cataPSF'
1) But when I try to extract the data with the istruction
./loadercli>TABLEEXTRACT USER DATA OUTSTREAM FILE '/tmp/dataPSF'
I receive the error
ERR -25109
Command not implemented.
2) When I try to load the catalog in PROV user' schema with the istruction
CATALOGLOAD USER INSTREAM FILE '/tmp/cataPSF'
I receive the error
ERR -25392
'[MySQL MaxDB][LIBSQLOD SO][MaxDB] Syntax error or access violation;-2000 POS(575) Row
too long'
and looking in file loader.prt, I find
CATALOGLOAD USER INSTREAM FILE '/tmp/cataPSF'
// *
CREATE TABLE "ACTIVITY_DYN_INFO" ( "E_ACT_K_ACTIVITY" Fixed (9,0) NOT
NULL, "E_DINF_TYP_K_DYNINFO_TYPE" Fixed (6,0) NOT NULL,
"E_DINF_VAL_K_DYNINFO_VALUE" Fixed (6,0), "Q_VALUE" Fixed
(9,0), "C_VALUE" Varchar (4000) ASCII, "D_VALUE"
Timestamp, "T_VALUE" Fixed (12,3), "D_START" Timestamp
NOT NULL, "K_PROG" Fixed (3,0), "O_MODIFY" Timestamp
NOT NULL, "E_OPERATOR_K_OPERATOR" Varchar (20) ASCII NOT NULL,
"C_NOTE" Varchar (4000) ASCII, "D_END" Timestamp,
"E_DB_TYP_K_DATABASE_TYPE" Fixed (6,0) NOT NULL, "K_ACTIVITY_DYNINFO"
Fixed (9,0) NOT NULL )
// *
// E -25392: '[MySQL MaxDB][LIBSQLOD SO][MaxDB] Syntax error or access
violation;-2000 POS(575) Row too long'
// M EXECUTE PACKAGE TO TRANSFORM CATALOG
// *
// M Number of tables transformed : 0
// *
// M Number of views transformed : 0
// *
// M Number of synonyms transformed : 0
// *
// M UNLOAD TRANSFORMATIONPACKAGE
x'01000000A8E44F416A690000C61B1D5300017F0000000000'
// *
What's wrong?
Thanks.
Bye,
Matteo
