IBM Mainframe Forum

by **ranga_subham** » Sat Nov 01, 2008 1:39 am

Hi,

I need a SQL query for the following condition.

Select employee-numbers for date 11th October 2008 who has request number "JZSK008" and for the date 12th October 2008 who has request number "KZSK009".

Please help.

Thanks.

by **dick scherrer** » Sat Nov 01, 2008 1:46 am

Hello,

You need to post what you have tried and what problem(s) were encountered. . .

I believe we have been thru this before. . .

by **ranga_subham** » Sun Nov 02, 2008 12:47 pm

This is what I tried.........

Select all

SELECT EMPLOYEE_NUM
FROM CONADB.EMPLOYEE
WHERE REQST_NUM = 'JZSK008'
AND TIM_STMP BETWEEN '2008-10-11-00.00.00.000000'
AND '2008-10-11-23.59.59.000000'
AND EXISTS
(SELECT EMPLOYEE_NUM
FROM CONADB.EMPLOYEE
WHERE REQST_NUM = 'KZSK009'
AND TIM_STMP BETWEEN '2008-10-12-00.00.00.000000'
AND '2008-10-12-23.59.59.000000')
WITH UR;

Thanks.

by **dick scherrer** » Sun Nov 02, 2008 6:14 pm

Hello,

So, you want multiple "answers rows" returned from the query?

You will probably be better served using a cursor (unless your environment supports multi-row fetch (check with your dba to see if this is available and how to use it if it is)).

The declare cursor could use something like this in the the "where":

Select all

WHERE (REQST_NUM = 'JZSK008'
AND TIM_STMP BETWEEN '2008-10-11-00.00.00.000000'
AND '2008-10-11-23.59.59.000000' )
OR (REQST_NUM = 'KZSK009'
AND TIM_STMP BETWEEN '2008-10-12-00.00.00.000000'
AND '2008-10-12-23.59.59.000000')

In the processing code, you wouold open the cursor and fetch the rows (one at a time) that match your criteria and do whatever is needed for each row read.

IBM Mainframe Forum

SQL Query needed.

SQL Query needed.

Re: SQL Query needed.

Re: SQL Query needed.

Re: SQL Query needed.