DSXchange

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

This seems to be a Netezza restriction.

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

Hi Andrew,

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

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

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.