Hi,
after a catalogextract all outstream FILE 'testdb.catalog' DDL
I corrected some statements, which were wrong
- comment on user without any apostrophe
- some commanddelimiter where they should not be ( and so on ... )
Then I tried a catalogload all instream FILE 'testdb.catalog' .
But without success :
catalogload has modified the testdb.catalog file in a weird way:
Some statements have now a command delimiter on their line
e.g.
CREATE VIEW testview1 AS SELECT a,b,c FROM tab1 //
GRANT SELECT ON VIEW testview1 TO ...
this '//' at end of the commandline causes an error in catalogload
My questions :
1. Why is the catalogfile modified by catalogload ?
2. Is it possible to change the commanddelimiter from '//' to perhaps
semicolon like in other databases ?
( I think there is a multiline mode in loadercli which can interpret
semicolon as commanddelimiter but this doesn't affect
the 'real' db-commands in the catalogfile )
Thanks in advance
tom
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
