IBM PureData System for Analytics, Version 7.1

Common error messages

You cannot use cross-database INSERT, UPDATE, or DELETE statements. If you attempt to do so, the system displays an error message.

For example, if you attempt to insert data into a table that is not in the current database (the database you are logged in to):

dev.sch1(admin)=>INSERT INTO PROD..EMP SELECT * FROM EMP;

The system displays an error message:

Cross Database Access not supported for this type of command.

For this type of query, consider changing the query to a cross-database SELECT statement (which is supported) while logged in to the target database. For example:

prod.schema(admin)=>INSERT INTO EMP SELECT * FROM DEV..EMP;

You cannot use CREATE, ALTER, or DROP commands to change objects in a database outside your current database. If you attempt to do so, the system displays an error message.

For example, if you attempt to create an object in a different database:

dev.sch1(admin)=>CREATE PROD..PAYROLL;

The system displays an error message:

Cross Database Access not supported for this type of command.