I'm trying to copy data from a 7.3 database to 7.5 using loadercli CATALOGEXTRACT. However, all the CREATE TABLE statements are empty except fo rthe table name and a trailing parenthesis. Looking at loader.prt, I see that every SELECT fails because it's looking for a column in domain.columns called NULLABLE, which doesn't exist in 7.3:

// E -25392: '[MySQL MaxDB][LIBSQLOD SO][MaxDB] Column not found;-4005 POS(64) Unknown column name:NULLABLE'
SELECT COLUMNNAME, DATATYPE, LEN, DEC, CODETYPE, MODE, KEYPOS, NULLABLE, "DEFAULT", COMMENT FROM DOMAIN.COLUMNS WHERE TABLENAME = 'MONTHLY_LOGIN_TOTALS' AND OWNER = 'STATSDBA'


I tried running repmcli on the 7.3 machine instead, but it has no CATALOGEXTRACT option. Is there any way around this?

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to