While trying to use loader to export and import I found an issue with one of our test instances. The export is done with
EXPORT DB CATALOG OUTSTREAM 'invocadb_ddl.catalog' DATA OUTSTREAM 'invocadb_pages.data'
now importing it into an empty instance I do
IMPORT DB CATALOG INSTREAM 'invocadb_ddl.catalog' DATA INSTREAM 'invocadb_pages.data'
and it shows this in it's log:
IMPORT DB CATALOG INSTREAM 'invocadb_ddl.catalog' DATA INSTREAM 'invocadb_pages.data'
// *
// M Execute PACKAGE to transform unlocked CATALOG
// *
CREATE TABLE "IMAGES"
(
"IMAGEID" Fixed (19,0) NOT NULL DEFAULT 0,
"IMAGETYPE" Integer NOT NULL DEFAULT 0,
"NAME" Varchar (64) ASCII NOT NULL DEFAULT '0',
"IMAGE" Blob NOT NULL DEFAULT ,
CONSTRAINT SYSPRIMARYKEY PRIMARY KEY("IMAGEID")
)
// *
// E -25392: '[SAP AG][LIBSDBOD SO][MaxDB] General error;-5004 POS(228) Missing constant'
// M Loader 7.7.07 Build 016-121-231-153
What's wrong here? I understand it's the IMAGE Blob which shows a DEFAULT but no value. Is this a bug in the loader or did I miss something?
Thanks,
Simon