|
View previous topic :: View next topic
|
| Author |
Message |
karthikr44
Active User
Joined: 25 Aug 2007
Posts: 235
Location: Chennai
|
|
|
|
HI,
I have been using the following query to fetch all programs starting with YUGT.
| Code: |
SELECT A.NAME, HEX(CONTOKEN)
FROM SYSIBM.SYSPACKAGE A
WHERE NAME LIKE 'YUGT%' AND COLLID='YATCTTJH'
AND BINDTIME = (SELECT MAX(BINDTIME)
FROM SYSIBM.SYSPACKAGE B
WHERE B.NAME=A.NAME
AND COLLID='YATCTTJH')
|
It is working correctly.
But now i want to inlcude the program YUFU0000 in addition to YUGT* programs in the same query.
Kindly share your thoughts to achive this.
Thanks
R KARTHIK |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| UNION ??? |
|
| Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
| Code: |
SELECT A.NAME, HEX(CONTOKEN)
FROM SYSIBM.SYSPACKAGE A
WHERE (NAME LIKE 'YUGT%' OR NAME = 'YUFU0000') AND COLLID='YATCTTJH'
AND BINDTIME = (SELECT MAX(BINDTIME)
FROM SYSIBM.SYSPACKAGE B
WHERE B.NAME=A.NAME
AND COLLID='YATCTTJH') |
Hope it will work. But not sure that this one is an optimized way.. Sorry. |
|
| Back to top |
|
|
karthikr44
Active User
Joined: 25 Aug 2007
Posts: 235
Location: Chennai
|
|
|
|
Hi Gnana Sekaran,
Before i post i actually tried the following code. But i got erroneous output. Same rows came multiple times. (may be due to join). Instead of expected 60 rows i got 853 rows.
| Code: |
SELECT A.NAME, HEX(CONTOKEN)
FROM SYSIBM.SYSPACKAGE A
WHERE NAME LIKE 'YUGT%' OR NAME = 'YUFU0000' AND COLLID='YATCTTJH'
AND BINDTIME = (SELECT MAX(BINDTIME)
FROM SYSIBM.SYSPACKAGE B
WHERE B.NAME=A.NAME
AND COLLID='YATCTTJH')
|
But when i put bracket like your code i get correct result.
| Code: |
WHERE (NAME LIKE 'YUGT%' OR NAME = 'YUFU0000') AND
|
Thanks
R KARTHIK |
|
| Back to top |
|
|
|
|
