Mainframe, MVS and zOS Discussion

Explicitly link with the necessary interface module.

It depends; what, if any, backups are being run?

You can get information on recent releases of DB2 here.

Although DB2 is not my area of greatest expertise, I believe that your process would be REORG, RUNSTATS (to establish new access paths to the reorganized data), and (RE)BIND (to allow use of those new access paths).

But it's not October yet

But how does a length matter apart from an abend when we verify that the length is same at the time of abend as at the time of abend? If the lengths differ then the machine code (and static variables) differ; the two modules are very unlikely to abend at the same offset (indeed, one may not abend a...

Thanks but in JCL we always make use of LRECL which actually mean logical record length and relate to the dataset mentioned there. Then is it actually relating to the records and not the data set? That is basically correct, although that you won't "always make use of LRECL"; you do not us...

HI,Can we code DB2 queries using rexx? Certainly. How can we do that? By establishing a DB2 environment via RXSUBCOM (most shops use the IBM-supplied DSNREXX command processor; mine, however, uses Open Software's RXTASQL). Then, you can use embedded or dynamic SQL as with any other language. Can yo...

I believe that it is obsolete and has been replaced by LOBs. Moreover, VARCHAR has a maximum length of 32,704 in DB2 V11.0.

narinderc, you may find this of use.

Are you using DSNTIAD to format the message? If not, do so and display to a suitable DDname.

You can easily write an exec fulfilling this requirement by reading the data set and incrementing a counter each time a record is read, then SAYing that counter at the end. Performance may range from adequate to unacceptable depending on the size of the data set. Note that what Mr. Collins and Dr. S...

Yes; although my health sometimes precludes cooking, I generally cook at least once a week (making several portions each time, so that a lot of my meals are leftovers ) and often bake breakfasts or desserts.

Chili Chicken Monterey 4 boneless, skinless chicken breast halves 1½ tsp. salt ¾ tsp. freshly ground black pepper 1 Tbsp. butter 8 oz. portobello mushrooms, sliced 2 jalapeños, seeded and chopped 1½ tsp. onion powder ½ cup shredded cheese[sup]1[/sup] Pre-heat oven to 375°F. Place chicken in baking ...

The EXPORT command can also be used in CICS, albeit with different syntax and to different ends; therefore the manual distinguishes between the two environments.

But what are the practical usage of alternate INDEX in ESDS? Can this concept mimic the functionality of KSDS then? It could be used, for example, if name and address are being written to the ESDS in fixed positions to index the zip code for retrieval by location instead of however they were entere...

The alternate keys for an ESDS do not relate to primary keys (which you correctly state do not exist for ESDS) but to RBAs. You may benefit from reading VSAM Demystified.

The IDCAMS command is wrong; it should be DELETE FILE(ddname), hence the RC=8. If the disposition is (MOD,DELETE), the data set is deleted by the OS, not IDCAMS; if the disposition is OLD (which implies KEEP, KEEP), it is not deleted.

What information are you seeking?