MVSFORUMS.com

S0C4. The abend code is S0C4. This is a protection exception. Your program is referencing storage that it is not authorized to access. Make sure that your program is not trying to access data beyond t ...

How are you doing it now? Even file transfer dialogs in emulators provide the ability to transfer multiple files saved in a list. FTP might also be an option as well as the ISPF C/S (option 3.7).

Depending on how much Dynamic SQL your shop uses, you might not get a complete picture using SYSTABAUTH. You'd need to look into DB2 Auditing. Another option would be to create an Insert Trigger and w ...

You could code a REDEFINES following the copybook.

First, DB2 doesn't work that way. Indexes are not standalone objects. They require tables. Tables can be created without indexes, but indexes cannot be created without tables. Look at the syntax,

...

The defined ASUTIME seems adequate. Have you done analysis to see which process is the hog? If not, load up the stored proc with DISPLAYs to show the start/end times of each process. That won't show C ...

Are you implying that DB2 returned the -805 on the bind? Do you know what causes a -805?

Are you using VALIDATE(BIND), or VALIDATE(RUN) in your package BIND? You should be using VALIDATE(RUN).

Another possibility is that DB2 bypassed the sort and used an index to satisfy the ORDER BY requirements.

From the Implementing Indexes section in Chapter 4 of the Administration Guide
Using inde ...

dbz, aggressive is what we like about you. You backed it up with a detailed explanation, and quite frankly, my response was not well thought out. No apology necessary.

kolusu and NASCAR set you on the right course. The CASE is adding confusion. Code the predicates with simple ANDs and ORs and use parenthesis to make sure you're getting what you want.

If you're s ...

Brain cramp. Thanks for highlighting the version differences dbz.

Wouldn't a SELECT INTO and an ORDER BY be mutually exclusive? SELECT INTO demands that a single record will be returned, so the ORDER BY would have no meaning. Something like this untested SQL might ...

I understand the need to get fancy with solutions at times, but getting fancy to avoid dynamic sql is unnecessary. Dynamic sql is an extremely valuable often underutilized feature. Why mix in trickery ...

I have supported custom and packaged applications with high volumes of database activity that use dynamic sql exclusively. I have never experienced any performance issues associated with the prepare ...