Author |
Message |
Topic: Run JCL for COBOL Stored Procedure & DB2 Stored Proced. |
SureshKumar
Replies: 7
Views: 7957
|
Forum: Database Posted: Wed May 17, 2006 10:33 am Subject: Run JCL for COBOL Stored Procedure & DB2 Stored Proced. |
srini_iqsi,
Are you suggesting a solution or is it a question? I am assuming you are asking a quetion regarding how to proceed after the call...refer to this topic. Thanks
http://www.mvsforums.c ... |
Topic: Run JCL for COBOL Stored Procedure & DB2 Stored Proced. |
SureshKumar
Replies: 7
Views: 7957
|
Forum: Database Posted: Tue May 16, 2006 10:06 am Subject: Run JCL for COBOL Stored Procedure & DB2 Stored Proced. |
vsr100481,
I am not sure about your requirement. If you need to run the program as a stored procedure call, then you need to have a host program that can issue an EXEC SQL CALL to the SP program, wit ... |
Topic: Run JCL for COBOL Stored Procedure & DB2 Stored Proced. |
SureshKumar
Replies: 7
Views: 7957
|
Forum: Database Posted: Tue May 16, 2006 7:04 am Subject: Run JCL for COBOL Stored Procedure & DB2 Stored Proced. |
vsr100481,
If you are not familiar with the Mainframe it will be hard to follow the instructions. Anyways, when you mention "thru JCL", well its Batch. You may have to have a Host program t ... |
Topic: PGM output in XML format |
SureshKumar
Replies: 2
Views: 1414
|
Forum: Application Programming Posted: Tue May 09, 2006 7:18 am Subject: PGM output in XML format |
raajesh_gs,
It's a simple statement to generate the XML o/p. try this, you can also find many examples in the manuals. thanks
01 WS-WORK-AREA. ... |
Topic: Commiting a single MQ in a multi MQ transaction |
SureshKumar
Replies: 2
Views: 1500
|
Forum: CICS and Middleware Posted: Thu Apr 27, 2006 8:33 am Subject: Commiting a single MQ in a multi MQ transaction |
cxvxbx,
Refer to MQ PUT Options. You can set a message to have implicit commit by using "MQPMO-NO-SYNCPOINT", this message would be outside the control of the LUW. However, if you have to r ... |
Topic: Shared data Tables - UMT |
SureshKumar
Replies: 2
Views: 2140
|
Forum: CICS and Middleware Posted: Thu Mar 23, 2006 12:53 pm Subject: Shared data Tables - UMT |
Kolusu,
Thanks for the link, I had referenced this manual earlier but was unable to gleen much from it, just "WRITE commands without the RBA or MASSINSERT options. The record is added to the data tab ... |
Topic: Shared data Tables - UMT |
SureshKumar
Replies: 2
Views: 2140
|
Forum: CICS and Middleware Posted: Thu Mar 23, 2006 11:45 am Subject: Shared data Tables - UMT |
Hi,
I have a doubt on how to handle a CICS Shared Data Table(UMT) in the program. We have an existing process which reads off the data table and if data not found, builds a dynamic result and writes ... |
Topic: SQLCODE -104 from UPDATE query which runs everyday |
SureshKumar
Replies: 9
Views: 5242
|
Forum: Database Posted: Fri Mar 17, 2006 11:21 am Subject: SQLCODE -104 from UPDATE query which runs everyday |
TheGodfather,
Just curious, is this firing a dynamic SQL and is the column " EMT.ASSIGNED_TO_NM " NULLABLE ? also can the Select Criteria return a NULL and if so how is the Null value handled? Thanks |
Topic: How to Retrieve Last Saturday Date using SQL ? |
SureshKumar
Replies: 11
Views: 4514
|
Forum: Database Posted: Tue Mar 14, 2006 3:17 pm Subject: How to Retrieve Last Saturday Date using SQL ? |
vini,
Does anybody have a one-pass solution without programming a whole lot around it to get the previous Saturday date of the week given any date as input.
you had a specific requirement a ... |
Topic: How to make a jcl have a pgm run with 3 different plan? |
SureshKumar
Replies: 6
Views: 2953
|
Forum: Database Posted: Tue Mar 14, 2006 8:21 am Subject: How to make a jcl have a pgm run with 3 different plan? |
issac1029 ,
Yes, but it depends on the requirement and how the system is set-up. Most often, programs are bound to all plans/collections. It's the data that is outside the plan and package switching ... |
Topic: How can we relieve DB2 resources in CICS DB2 Applications |
SureshKumar
Replies: 2
Views: 1697
|
Forum: CICS and Middleware Posted: Mon Mar 13, 2006 9:40 am Subject: How can we relieve DB2 resources in CICS DB2 Applications |
vinnay,
Is it related to RELEASE(DEALLOCATE/COMMIT) ? |
Topic: Clocking when doing a Fetch |
SureshKumar
Replies: 10
Views: 4493
|
Forum: Database Posted: Fri Mar 10, 2006 2:06 pm Subject: Clocking when doing a Fetch |
Pknair,
The issue is more in line with Kolusu's explanation. Its good to have the SQL tested thru QMF/SPUFI with fetch 1 or 2 rows to take an initial shot with the SQL. Thanks |
Topic: Clocking when doing a Fetch |
SureshKumar
Replies: 10
Views: 4493
|
Forum: Database Posted: Fri Mar 10, 2006 11:38 am Subject: Clocking when doing a Fetch |
pknair,
If "FETCH FIRST 10 ROWS ONLY" is in effect and the OPEN is complete, then FETCH should not take time. What else is going on in the program logic, what is going on in the SP with the result - ... |
Topic: How do we know that sequential file has no records in cobol? |
SureshKumar
Replies: 4
Views: 2085
|
Forum: Application Programming Posted: Wed Mar 08, 2006 9:39 am Subject: How do we know that sequential file has no records in cobol? |
mrar_160,
What Kolusu has provided is good enough for a beginner to start working on. However, I am adding this. Thanks
SET NOT-END-OF-FILE TO TRUE.
OPEN INPUT INPUT-FILE. ... |
Topic: Unload and load related. |
SureshKumar
Replies: 2
Views: 1653
|
Forum: Database Posted: Wed Mar 08, 2006 9:29 am Subject: Unload and load related. |
gavini_vasu,
Is the tablespace partitioned? 2 million is not a huge number and do you have tools like Platinium utilities? There are several examples for unloading by partitions. Typcally unloading 2 ... |
|