We often edit our IQD's to do things that the original IMR could not.
I have one now that includes in its WHERE clause a correlated subquery, a "not exists" condition that is correlated to 3 fields in the main query.
While it runs fine in a native Oracle 9 session, Transformer refuses to accept the IQD as a data source, giving the following errors ...
TR0118 Transformer can't read the database...etc
DMS-E-GENERAL, A general exception has occurred during operation 'prepare request'.
DMS-E-SS_PARSER, An error was detected during processing of the SQL request.
DMS-E-SS_INCONS_LOGICAL, An inconsistent logical operation was specified.
We are using Oracle 9, Impromptu 7.1 and PP Transformer 7.0
Any advice would be wonderful.
regards,
doddy
I have one now that includes in its WHERE clause a correlated subquery, a "not exists" condition that is correlated to 3 fields in the main query.
While it runs fine in a native Oracle 9 session, Transformer refuses to accept the IQD as a data source, giving the following errors ...
TR0118 Transformer can't read the database...etc
DMS-E-GENERAL, A general exception has occurred during operation 'prepare request'.
DMS-E-SS_PARSER, An error was detected during processing of the SQL request.
DMS-E-SS_INCONS_LOGICAL, An inconsistent logical operation was specified.
We are using Oracle 9, Impromptu 7.1 and PP Transformer 7.0
Any advice would be wonderful.
regards,
doddy