MVSFORUMS.com A Community of and for MVS Professionals    FAQ   Search   Quick Manuals   Register   Profile   Log in to check your private messages   Log in  Search found 5 matches MVSFORUMS.com Forum Index Author Message   Topic: Performance of Fetch First Row Jiten Replies: 8 Views: 2818 Forum: Database   Posted: Wed Jun 13, 2007 11:19 am   Subject: Performance of Fetch First Row hi dbzTHEdinosauer, I am using DB2 Version 8. If you could explain the usage of SELECT 1 WHERE EXISTS....actually I did not get it. Usage of Exists I know, it will stop after getting the first find ...   Topic: Performance of Fetch First Row Jiten Replies: 8 Views: 2818 Forum: Database   Posted: Wed Jun 13, 2007 8:28 am   Subject: Performance of Fetch First Row Hi Kolusu, I do not have an Order By Clause. I am simply checking the exisiting of record in the table. To add to the previous post, for one particular query, The COST reduced from 14564 to 4485 w ...   Topic: Performance of Fetch First Row Jiten Replies: 8 Views: 2818 Forum: Database   Posted: Wed Jun 13, 2007 8:16 am   Subject: Performance of Fetch First Row I have a program having many Single Select SQL queries, all having Fetch First Row. The Response time for the online program was near to 40 seconds. Someone suggested to Remove all of the Fetch First ...   Topic: Identity Columns Jiten Replies: 4 Views: 2325 Forum: Database   Posted: Fri May 25, 2007 8:10 am   Subject: @dbzTHEdinosauer I have found the Identity Column information in SYSIBM.SYSSEQUENCES and SYSIBM.SYSSEQUENCESDEP. But I am not sure if these tables existed before Version 8 release. As Identity Columns existed before V ...   Topic: Identity Columns Jiten Replies: 4 Views: 2325 Forum: Database   Posted: Fri May 25, 2007 7:27 am   Subject: Identity Columns I have a table with Identity Column Defined on it. I insert one row(the only row present) in the table and using the Identity_val_local Function get the latest value of Identity column(suppose 1000). ...   Page 1 of 1 All times are GMT - 5 Hours Jump to: Select a forum Announcements----------------MVSFORUMS - Announcements Help Boards----------------Application ProgrammingDatabaseUtilitiesJob Control Language(JCL)CICS and MiddlewareIMSTSO and ISPFData ManagementProblem DeterminationMainframe ChallengeAbout MvsforumsOther Technical TopicsRelated Non-Technical TopicsInterview Q & A General----------------Tools and DownloadsIT News Technical FAQ (Tips)----------------Programming LanguagesDB2/IMSJCL/SORTTSO and ISPF  MVSFORUMS Powered by phpBB © 2001, 2005 phpBB Group