MVSFORUMS.com

Please then point me to the manual where it states that the key and index used in a binary search are never located in shared storage for a table defined and used in this manner (instead of responding ...

The Search Criteria are local to my programs, but the Key and Index are not local to my programs. The Key and Index are located in Shared Storage. Therefore repeating my concern: could the Key and Ind ...

We are attempting to use COBOL logic in CICS that was originally written to work in Batch, where the programs are now reuse=re-entrant. A table is being stored in CICS shared/main storage for use thro ...

I believe that using REPLACE will replace all occurrences of a dash, so if a name contains a dash in other than the last position, then that dash will also be removed. The question was for only removi ...

Just use DB2TOOLS, which is the DB2 Administration Tool. This should be available for any developer to use. In our shop, we access it via TSO DB2TOOLS. Much better than using a cumbersome select.

I'll answer my own question. This setting is not getting reset. I believe what was happening is that I was being timed-out of TSO before cleanly exiting from DB2TOOLS. The option settings are now stay ...

We have version 7.1.0 of DB2 Admin Tools. Under P - Change DB2 Admin parameters, 2 - Change DB2 Admin defaults, you can change some defaults. I change the "Max No of Rows to Fetch" to zero, ...

What commands are you using? The first command must be REDKG (read key greater or equal), followed by REDNX (read next). If only REDKG is used, then yes, you will only retrieve the same record over an ...

How does one generate a hyperlink within COBOL source code using TSO as the editor? In other words, when browsing or editing the source in TSO, an active hyperlink to an Internet url can be clicked on ...

Thanks kolusu, your answer is simpler than mine and works just as well!
I was not using the Quick Reply box. If we should use that then why are two "postreply" buttons supplied both top and ...

Thanks, and I will try that, but in the meantime I got what I wanted by coding this (and can u plz tell me how to get this to look like code in this forum, I tried to use the Code button but does not ...

I have the following SQL I am running in SPUFI. It works fine, but I would also like to display B.REL_VER_NUM. Can someone please show me how to change this statement so I can display the extra column ...

SYNCH11!

You used a tool other than ChangeMan ZMF to change and replace a component
in a staging library.
Suggested Resolution: Use ChangeMan ZMF to restage the component from
baseline.

I expected this type of info to be documented in the DB2 Developer's Guide, but it was not. Thanks for the explanation.

Using z/OS DB2 version 7. When SQLCODE -803 is detected, is there a way to programatically obtain the indexspace-name? I do not see anywhere in SQLCA where this is stored. How/Where does DSNTIAR obtai ...