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 33 matches MVSFORUMS.com Forum Index Author Message   Topic: DB2 702 or 703? Catherine Replies: 1 Views: 1172 Forum: Database   Posted: Tue Jun 08, 2010 5:45 am   Subject: DB2 702 or 703? Hi friends, I have application development experience in mainframe technologies of nearly 5 years . I have already taken up DB2 700 exam and thinking of which to do next. Although i donot have ...   Topic: -438 sqlcode Catherine Replies: 9 Views: 10742 Forum: Database   Posted: Wed Jul 01, 2009 7:51 am   Subject: -438 sqlcode Hi dina, Thanks very much for info   Topic: -438 sqlcode Catherine Replies: 9 Views: 10742 Forum: Database   Posted: Wed Jul 01, 2009 4:30 am   Subject: -438 sqlcode Hi, Im getting -438 SQLCODE while inserting a row in DB2 table. Can you please help me why is this error occuring. Imnt able to underatand the description provided for this sqlcode Thanks Cathe ...   Topic: AFCY abend Catherine Replies: 0 Views: 2457 Forum: CICS and Middleware   Posted: Fri Apr 03, 2009 6:39 am   Subject: AFCY abend When 2 transactions try to WRITE the same record to a File one after the other, assume that the transactions are not committed at this point in time Will not one of the transactions encounter DUPLI ...   Topic: File Deadlock Catherine Replies: 2 Views: 2204 Forum: CICS and Middleware   Posted: Fri Mar 27, 2009 3:02 am   Subject: File Deadlock Thanks Kolusu My VSAM File is defined to have a SHARE OPTION ( 2 3) T1 & T2 transactions belong to the same CICS region Other SHARE OPT 3, 4 are not recommended as per our standards This m ...   Topic: File Deadlock Catherine Replies: 2 Views: 2204 Forum: CICS and Middleware   Posted: Thu Mar 26, 2009 7:11 am   Subject: File Deadlock There were 2 transactions T1, T2 corresponding to a Single Program P which were trying to WRITE to the File F1 ( T1 , T2 are multiple transaction running on a single program ) The Program P actual ...   Topic: File Deadlock Catherine Replies: 0 Views: 1590 Forum: CICS and Middleware   Posted: Thu Mar 26, 2009 7:10 am   Subject: File Deadlock There were 2 transactions T1, T2 corresponding to a Single Program P which were trying to WRITE to the File F1 ( T1 , T2 are multiple transaction running on a single program ) The Program P actual ...   Topic: RLSA abend Catherine Replies: 2 Views: 1707 Forum: CICS and Middleware   Posted: Fri Jan 04, 2008 7:26 am   Subject: RLSA abend Hi, My transaction encounters an RLSA abend. The Processing is as below A Links B B Links C C Links D Since the Linking through Programs A thru D is a Single unit of work, All the Workin ...   Topic: EXECUTE IMMEDIATE Catherine Replies: 2 Views: 1171 Forum: Database   Posted: Fri Dec 07, 2007 8:32 am   Subject: EXECUTE IMMEDIATE Hi all, Please let me know how and when a EXECUTE IMMEDIATE statement is used. Will it help to improve my performance of the Query? I understand that EXECUTE IMMEDIATE can be used starting from D ...   Topic: Group by on 3 Columns and get unique rows query Catherine Replies: 9 Views: 4456 Forum: Database   Posted: Tue Mar 27, 2007 8:52 am   Subject: SQL Query Kolusu, I just want to confirm this The output of this Query SELECT A.ID, A.NAME, B.TRNS FROM EMP A, TRANSACTION B WHERE A.ID = B.ID GROUP BY A.ID, A.NAME, B.TRNS will be 1 A CR ...   Topic: Group by on 3 Columns and get unique rows query Catherine Replies: 9 Views: 4456 Forum: Database   Posted: Tue Mar 27, 2007 7:24 am   Subject: SQL Query Nic, I get the same result   Topic: Group by on 3 Columns and get unique rows query Catherine Replies: 9 Views: 4456 Forum: Database   Posted: Tue Mar 27, 2007 6:51 am   Subject: SQL Query Nic, Sorry thats B.TRNS instead of B.TRNS_TY SELECT A.ID, A.NAME, B.TRNS FROM EMP A, TRANSACTION B WHERE A.ID = B.ID GROU ...   Topic: Group by on 3 Columns and get unique rows query Catherine Replies: 9 Views: 4456 Forum: Database   Posted: Tue Mar 27, 2007 5:18 am   Subject: Group by on 3 Columns and get unique rows query Hi, I have got 2 tables Table Emp: ID Primary key ID NAME 1 A 2 B 3 C 4 D Table TRANSACTION ID TRNS DATE 1 CR ...   Topic: isolation levels Catherine Replies: 13 Views: 7484 Forum: Database   Posted: Fri Mar 23, 2007 3:17 am   Subject: Isolation levels Christian, Suppose i have defined LOCKSIZE=PAGE, I query the table with a SELECT statement. When I try to retrieve a row 1) The page containing the Row is put in "Share" Lock mode ...   Topic: isolation levels Catherine Replies: 13 Views: 7484 Forum: Database   Posted: Wed Mar 21, 2007 4:50 am   Subject: isolation levels Kolusu, Can you plz refer this link and explain me? http://www.dbazine.com/db2/db2-mfarticles/mullins4 In the above article under table locks and tablespace locks i find that even if i giv ...   Page 1 of 3 Goto page 1, 2, 3  Next 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