By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,702 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

A query related to fetch(DB2)

P: 1
My query is like i declare a cursor like
SELECT A,B,C,D
FROM H
WHERE A = a;

Here i will get the sets like a b1 1 6
a b1 2 4
a b2 3 8
a1 b1 4 7 so on......
so its like a 2 By 2 matrix
So how should i fetch all combinations of B and fro each A B combinations i should also take care of updating D
Mar 13 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.