MVSFORUMS.com

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Hi all,

I wanna refresh the test environment with the data from 3 tables.
As the tables are huge I am planning to take imagecopies of three tables.
After that Can I run the following qurey on Image copies, will it run or not, if not is there any best way to do that. As this query is taking lot of time to unload the data from prod.

Pls suggest me.
Thanks in advance.

SELECT A.*
FROM
Table1 A,
Table2 B ,
Table 3 C
WHERE A.RID = B.RID
AND B.RDNDTE = C.RDNDTE
AND DATE(C.RDNDTE) >= CURRENT DATE - 5 YEARS;
_________________
Satya

CraigG · Posted: Tue Jul 22, 2008 6:41 pm Post subject:

Queries don't work on files (even imagecopies) they only work on DATABASES!

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Thanks CraigG.
_________________
Satya

jsharon1248 · Posted: Thu Jul 24, 2008 9:08 am Post subject:

CraigG

Techinically speaking, you are right. Queries are run on DB objects. However, the UNLOAD utility provides query-like access to image copies via the FROM TABLE and WHEN specs. The access is obviously single table only (no joins) so it would probably not help the op in this case.

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Thanks Sharon.
_________________
Satya

dbzTHEdinosauer · Posted: Thu Jul 24, 2008 4:44 pm Post subject:

jsharon1248,

nice bit of 'oh by the way' info...
_________________
Dick Brenholtz
American living in Varel, Germany