 |
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 16 matches |
| Author | Message |
|---|---|
 Topic: Replace version of the Bind and ReBind |
|
| a_seshu Replies: 2 Views: 1694 |
 Forum: Database Posted: Thu May 18, 2006 3:00 pm Subject: Replace version of the Bind and ReBind |
| BIND and REBIND are two different animals.
You have ADD and REPLACE options in BIND. If no package with the same userid, same name bound to the same database, as you are BINDing now is present the ... |
|
| Topic: Will be there any issue if a new column is added |
|
| a_seshu Replies: 7 Views: 3916 |
Forum: Database Posted: Thu May 18, 2006 2:53 pm Subject: Will be there any issue if a new column is added |
| Say a table T1 is having columns A and B and your application program A1 is referring to the columns A and B by SELECT A,B from T1.
Now assuming the table is modified using the ALTER TABLE command ... |
|
| Topic: Conflicting DCB parameters |
|
| a_seshu Replies: 7 Views: 9623 |
Forum: Problem Determination Posted: Tue Jan 24, 2006 2:41 pm Subject: Conflicting DCB parameters |
| Ripley
Looking at your code //JAXHCLEA JOB CLASS=H,MSGCLASS=A,MSGLEVEL=(1,1),NOTIFY=I1000XX //DUMMY EXEC PGM=IEBGENER,REGION=2048K //SYSUT1 DD DUMMY ... |
|
| Topic: DB2 - delay |
|
| a_seshu Replies: 4 Views: 4625 |
Forum: Database Posted: Fri Dec 30, 2005 12:40 pm Subject: DB2 - delay |
| Hema_Manyam
Think this way..... Your program encountered a deadlock at a particular point... You end up getting an sql code of -911 or -913. All the work done in your program in that LUW (L ... |
|
| Topic: Delete Duplicates |
|
| a_seshu Replies: 12 Views: 7052 |
Forum: Database Posted: Mon Dec 19, 2005 4:58 pm Subject: Delete is a setlevel operation even with correlation.... |
| Hi Kolusu,
The reason i think all the duplicate rows get deleted even in the case of a correlated query is that the delete operation performs at a set level. Taking the same data example ... |
|
| Topic: Manual for GTB BMS map generator for generating CICS maps |
|
| a_seshu Replies: 1 Views: 4368 |
Forum: CICS and Middleware Posted: Fri Nov 11, 2005 4:58 pm Subject: Manual for GTB BMS map generator for generating CICS maps |
| I need to find a manual for GTB BMS map generator. If any one is having can you please share it with me.... | |
| Topic: A token of immense gratitude for our great moderator. |
|
| a_seshu Replies: 13 Views: 32949 |
Forum: About Mvsforums Posted: Fri Oct 28, 2005 2:34 pm Subject: A token of immense gratitude for our great moderator. |
| Its been a long time since i registered to this forum... Every time I open a topic and read the sequence of messages, no matter how complex the question is, our moderator kolusu has a very intelligent ... | |
| Topic: SOC4 Abend |
|
| a_seshu Replies: 2 Views: 4657 |
Forum: Database Posted: Tue Oct 25, 2005 6:14 am Subject: SOC4 Abend |
| Hi abracadabra...
when ever any db2 program is executing in batch, it has to either issue a call attach facility or it has to execute under the terminal monitor program (TMP) (IKJEFT01), specify ... |
|
| Topic: SQL tuning for a CICS program |
|
| a_seshu Replies: 3 Views: 2752 |
Forum: Database Posted: Mon Oct 24, 2005 1:24 pm Subject: SQL tuning for a CICS program |
| Hi Vijay,
Why dont you think the option of creating an index on the table with the columns. ID, Status, timestamp preferrably an ascending index... CREATE INDEX <INDEX NAME> ON &l ... |
|
| Topic: How to aviod Database inserts/updates in Production? |
|
| a_seshu Replies: 4 Views: 2647 |
Forum: Database Posted: Mon Oct 24, 2005 1:11 pm Subject: How to aviod Database inserts/updates in Production? |
| Use a read only plan | |
| Topic: z/OS DB2 Stored Procedure Returning Duplicate Results |
|
| a_seshu Replies: 3 Views: 2941 |
Forum: Database Posted: Fri Oct 21, 2005 3:56 pm Subject: z/OS DB2 Stored Procedure Returning Duplicate Results |
| Hi Bithead,
I feel waiting in a loop for 0 sql code when processing in multi threaded evironment with high volumes of concurrency is not a good approach of programming. Having said that, I have a ... |
|
| Topic: Can Views be indexed in DB2? |
|
| a_seshu Replies: 1 Views: 2169 |
Forum: Database Posted: Sun Oct 24, 2004 12:24 am Subject: Can Views be indexed in DB2? |
| We index tables in DB2. But is there any possibility to index views in DB2? | |
| Topic: Commit |
|
| a_seshu Replies: 3 Views: 2183 |
Forum: Database Posted: Sat Oct 02, 2004 7:38 am Subject: Commit |
| Suresh,
do you have any idea why is that we would be needing a COMMIT even after a large number of selects are performed? I mean i dont understand what might be the need for giving a commit, eve ... |
|
| Topic: How to use LIKE parameter for Numeric literals |
|
| a_seshu Replies: 2 Views: 1909 |
Forum: Database Posted: Sat Oct 02, 2004 7:33 am Subject: A straight forward solution |
| Phani,
The solution I am giving here is a simple and straight forward approach. If the data is too large, you are gonna have performance issues. UPDATE EPR_MNTG_REGN SET EMR_SUBR_CTRY_CD = ... |
|
| Topic: Which would be better? EXCI Call or CTG Implementation? |
|
| a_seshu Replies: 1 Views: 1792 |
Forum: CICS and Middleware Posted: Sat Oct 02, 2004 7:04 am Subject: Which would be better? EXCI Call or CTG Implementation? |
| Hi all,
I have a request that i should parse an XML document that would come from a webpage and get the data from it and put it in a TS queue and invoke a CICS Transaction. 
We have t ... |
|
All times are GMT - 5 Hours |