I would like to know the difference between SQLID, COLLECTION, QUALIFY and so on...I have tried to search some related materials in the site, but i can't find them. Please help me to tell more details about the difference of above mentioned concepts. Many thanks!
Thank you very much for your reply. I just want to know about these DB2 concepts and these queries are not related with interview and any other similar situations. I'm just confused by the difference about OWNER/QUALIFIER/CREATER/COLLECTIONS/SQLID. Some DB2 materials say they are the same but the others not, so i just want to confirm on the details about these concepts. Could you please kindly tell me where can i find the related materials?