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 14 matches MVSFORUMS.com Forum Index Author Message   Topic: Check for the existence of the dataset process the next Pavani Donepudi Replies: 3 Views: 2485 Forum: Job Control Language(JCL)   Posted: Thu Dec 11, 2008 4:04 pm   Subject: Check for the existence of the dataset process the next I was checking for something else. By mistake I forgot to remove the statement of setting MAXCC. BTW, I got the solution. I changed STEP020.SYSUT1 to have DISP=MOD instead of DISP=SHR. This wa ...   Topic: Check for the existence of the dataset process the next Pavani Donepudi Replies: 3 Views: 2485 Forum: Job Control Language(JCL)   Posted: Thu Dec 11, 2008 2:16 pm   Subject: Check for the existence of the dataset process the next Here is my req. I have a dataset TEST1 which I am not sure if it existing or not in the mainframe. My req is if TEST1 existing in the mainframe then copy it to TEST2 else use the a DUMMY file to ...   Topic: Removing BLL Pointers and SERVICE RELOAD Pavani Donepudi Replies: 0 Views: 1174 Forum: CICS and Middleware   Posted: Mon Apr 16, 2007 1:36 am   Subject: Removing BLL Pointers and SERVICE RELOAD Hi, We have a task where in we are converting couple of CICS programs from Meta COBOL to COBOL II. Here is the scenario where in we are getting an ASRA abend. I am not sure whether there is any pr ...   Topic: Mass update on a table - resulting in -904 Pavani Donepudi Replies: 1 Views: 1172 Forum: Database   Posted: Mon Jan 23, 2006 10:06 pm   Subject: Mass update on a table - resulting in -904 Hi, I am looking for a solution for the following req. I need to update one column with a value for the entire table records which has approximately 800000 (800 Thousands records). Update is simpl ...   Topic: Replace string in the first line using SYNCSORT Pavani Donepudi Replies: 1 Views: 2405 Forum: Utilities   Posted: Mon Nov 07, 2005 4:35 pm   Subject: Replace string in the first line using SYNCSORT Hi, Here is my requirement. I wanted the solution either in SYNCSORT or FILEAID. 1. My input file is of length 80 bytes of Fixed type. And there will only three records. 2. I need to repla ...   Topic: Embedded SQL select with ORDER BY and FETCH FIRST Pavani Donepudi Replies: 8 Views: 3399 Forum: Database   Posted: Fri Jul 15, 2005 1:22 pm   Subject: Embedded SQL select with ORDER BY and FETCH FIRST Hi, I am trying to compile a COBOL program with the following query SELECT COL2, COL3 INTO :WS-COL ...   Topic: Merging of the files and summing Pavani Donepudi Replies: 5 Views: 3564 Forum: Utilities   Posted: Wed Mar 02, 2005 4:02 pm   Subject: Merging of the files and summing Thanks Kolusu...... Regards, Pavani.   Topic: Merging of the files and summing Pavani Donepudi Replies: 5 Views: 3564 Forum: Utilities   Posted: Tue Mar 01, 2005 5:13 pm   Subject: Merging of the files and summing Thanks Frank for the information. But if possible can I have the solution using SYNCSORT. Regards, Pavani.   Topic: Merging of the files and summing Pavani Donepudi Replies: 5 Views: 3564 Forum: Utilities   Posted: Tue Mar 01, 2005 3:35 pm   Subject: Merging of the files and summing Hi, I have slight change from what I saw for merging the files. Chances are that I could have missed this in the prior posts also. If so let me know the link for it. Here is what I ne ...   Topic: Max limit on the SQL stmts in a JCL Pavani Donepudi Replies: 15 Views: 11978 Forum: Job Control Language(JCL)   Posted: Mon Aug 23, 2004 2:39 pm   Subject: Max limit on the SQL stmts in a JCL Hi Kolusu, My input file will be as follow, format FB and LRECL = 80. 111111111A 222222222B 333333333C First 9 positions is a number and 10 position is a char. Like these we have 32000 re ...   Topic: Max limit on the SQL stmts in a JCL Pavani Donepudi Replies: 15 Views: 11978 Forum: Job Control Language(JCL)   Posted: Mon Aug 23, 2004 2:01 pm   Subject: Max limit on the SQL stmts in a JCL Hi Kolusu, I am using regualr Fileaid only. Basically my input file(Foxed) will have 32000 records containing the primary key data of the table in a specific format. I use this as the input file i ...   Topic: Max limit on the SQL stmts in a JCL Pavani Donepudi Replies: 15 Views: 11978 Forum: Job Control Language(JCL)   Posted: Mon Aug 23, 2004 1:39 pm   Subject: Max limit on the SQL stmts in a JCL Hi Kolusu, Since the number of updates are very high, I would like to have a fileaid step to create Update SQL stmts. But now the question, is possible to insert a COMMIT stmt after every 500th SQ ...   Topic: Max limit on the SQL stmts in a JCL Pavani Donepudi Replies: 15 Views: 11978 Forum: Job Control Language(JCL)   Posted: Mon Aug 23, 2004 12:39 pm   Subject: Max limit on the SQL stmts in a JCL Hi Kolusu, Just to be more specific, I am going to update only one table. But I still need some more clairification - Does each SQL update stmt have a max of 32765 bytes or all the SQL update stmt ...   Topic: Max limit on the SQL stmts in a JCL Pavani Donepudi Replies: 15 Views: 11978 Forum: Job Control Language(JCL)   Posted: Mon Aug 23, 2004 10:51 am   Subject: Max limit on the SQL stmts in a JCL Hi, Probably my question might be simple. But not able to get the solution. My problem is that I need to run aproximately 32000 updates in production. 1. Is there any limit on the maximum ...   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