Cross Database Access not supported for this type of command

rumu · Post by **rumu** » Fri Jun 10, 2016 4:58 am

Hi All,

I am loading Netezza table from a source file.And after the table load ,calling after SQL to load another table(same metadata) to another Database.While executing the job,the job is aborting at After SQL saying "Cross Database Access not supported for this type of command".

In the after SQL ,I am using full qualifier to call the tables from respective databases.

Do we need to raise for this access through DBA?

Thanks in advance.

Rumu

ArndW · Post by **ArndW** » Fri Jun 10, 2016 6:52 am

This seems to be a Netezza restriction.

See http://www.ibm.com/support/knowledgecen ... mples.html

rumu · Post by **rumu** » Fri Jun 10, 2016 7:58 am

Hi Andrew,

It means ,we can not execute the insert/update statement involving two DB's?

chulett · Post by **chulett** » Fri Jun 10, 2016 8:56 am

Why not just do this "in job" rather than burying it in the After SQL?

Teej · Post by **Teej** » Fri Jun 10, 2016 9:24 am

It means that the behind-the-scene activity that is done within the stage itself most likely prevented the ability for you to do this task within Netezza Connector. Sorry.

(You could ask for an enhancement request to make this possible, somehow.)

-T.J.