MVSFORUMS.com

[satyenderd]

Hi all,

The following is the scenario.

I have to unload the data from the production. But as I am not supposed to hit a query in production, is it is possible to write a sub-query or join on Imagecopies to unload the data.

for example:

SELECT *
FROM
TABLE1
WHERE RDNDTE IN
(SELECT
RDNDTE
FROM
TABLE2
WHERE DATE(RDNDTE) >= CURRENT DATE - 5 YEARS);


Please let me know, if there are any chances of executing a query on this kind of scenario.

Thanks in advance to all.
_________________
Satya

[jsharon1248]

The UNLOAD from image copy supports limited query-like functionality via the WHEN clause in the FROM-TABLE spec. The WHEN is not processed by the optimizer. The UNLOAD utility will not allow a sub-select in the FROM-TABLE spec.

[CraigG]

Are you expecting an answer more to your liking from this site.

[jsharon1248]

CraigG

How did my response compare to the other site? Better or worse?