Re: Calling a COBOL DB2 Stored Procedure

start from the basics - I assume the plan name is DSNREXX. you can 1. bind the DSNREXX plan with your collection and it will find it in the search list 2; SET CURRENT PACKAGESET = 'your collection' I haven't played in this area but those are the basics. Mike On Tue, Feb 7, 2023 at 2:25 PM

Re: Calling a COBOL DB2 Stored Procedure

you forgot the bind step - when you created the stored procedure the JCL should have had a ddname for DBRMLIB usually a pds with a member name the same as your stored procedure. I don't have a sample bind handy but the manual has several. Mike On Tue, Feb 7, 2023 at 5:40 AM Binyamin Dissen

Re: Db2 sql error -805

-805 means the version of dsnrexx that you are running doesn't match what is in DB2. either wrong DB2/DSNREXX or DSNREXX wan't installed. Mike On Thu, Feb 4, 2021 at 8:47 AM Binyamin Dissen wrote: > On Thu, 4 Feb 2021 16:17:59 +0200 ITschak Mugzach > wrote: > > :>the DB2-L group seems to be

Re: SMS dataset woes

Your issue is the new (different) usercat name. I am not sure if the vvds captures the SMS but I know it captures the usercat. Mike On Wed, Aug 23, 2017 at 11:24 AM, Kirk Wolf wrote: > I would appreciate some advice on a problem that I'm having on a > development system. >

Re: thoughts on z/OS ftp server enhancement.

the existing products that do this a generally classified as ETL - extract, transfer and load. most of them are data warehouse style products Mike On Wed, Mar 22, 2017 at 8:19 PM, Mike Schwab wrote: > What you have to do is take the file layout and code SORT or

Re: Active versus archive log data sets in DB2

top posting - yes I know - 1. yes, there are buffers for log activity - see DSNZPARM values - not the size of database buffers but not small either 2. Archive logs are recorded in BSDS with start and end logrba 3. If an active log has not been reused, DB2 will search it first not the archive log

Re: S0C2 in DB2 application program (was Stored Procedure) IFF run from a PDSE

the first thing to check would be entry point - a non-zero entry point is one of the easiest things to loose in a LKED. On Fri, Feb 21, 2014 at 10:37 AM, Chase, John jch...@ussco.com wrote: -Original Message- From: IBM Mainframe Discussion List On Behalf Of Lizette Koehler My

Re: Differences between CPU values from SMF30 and DB2 stats

There is a basic issue with DB2 statistics for CPU - they start with the first SQL statement. Everything that happens before that is not recorded in the DB2 cpu times. This is WAD. There used to be some presentations on what was included in DB2 cpu and why. I haven't looked for them in a long

Re: Reader Comment on SA22-7832-08 (PoPS), should I?

many of the redbooks now supply epub format - And yes, I still miss bookmanager. Mike On Thu, Jun 27, 2013 at 11:12 AM, Tom Marchant m42tom-ibmm...@yahoo.comwrote: On Thu, 27 Jun 2013 10:48:57 -0500, John McKown wrote: why is this publication [Principles of Operation] still formatted in two

Re: Slightly OT: How to interpret this DB2 message

You are getting there. correlation name is never blank. either null or non-blank. consider SQL statement like select cola from tablea corra inner join tablea corrb. you will have two rows in plan table for the same table but the correlation name will be different so you can tell them apart.

Re: Slightly OT: How to interpret this DB2 message

which is why I always test hints with SPUFI - it will give you the reason code. I don't know a better way to test the hint unless you have a product. Mike On Mon, Jun 24, 2013 at 9:55 AM, Lizette Koehler stars...@mindspring.comwrote: Did you check out Mike Bell's Presentation from 2008?