Author |
Message |
Topic: SOC4 Error in MOVE |
jsharon1248
Replies: 4
Views: 4783
|
Forum: Application Programming Posted: Wed Nov 09, 2011 8:46 am Subject: SOC4 Error in MOVE |
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 ... |
Topic: is it possible to download a mainframe file through rexx? |
jsharon1248
Replies: 4
Views: 4847
|
Forum: TSO and ISPF Posted: Thu May 12, 2011 7:49 am Subject: is it possible to download a mainframe file through rexx? |
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). |
Topic: need to know programs which do inserts into particular table |
jsharon1248
Replies: 2
Views: 2254
|
Forum: Database Posted: Wed May 11, 2011 7:34 am Subject: need to know programs which do inserts into particular table |
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 ... |
Topic: Selecting a field from cobol copybook layout |
jsharon1248
Replies: 6
Views: 4641
|
Forum: Application Programming Posted: Mon May 02, 2011 7:33 am Subject: Selecting a field from cobol copybook layout |
You could code a REDEFINES following the copybook. |
Topic: Index only |
jsharon1248
Replies: 9
Views: 4277
|
Forum: Database Posted: Thu Mar 03, 2011 8:45 am Subject: Index only |
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,
... |
Topic: SQL0905N Unsuccessful execution due to resource limit - DB2 |
jsharon1248
Replies: 15
Views: 18211
|
Forum: Application Programming Posted: Wed Feb 16, 2011 8:36 am Subject: SQL0905N Unsuccessful execution due to resource limit - DB2 |
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 ... |
Topic: Binding a program to 2 differnt subsystems |
jsharon1248
Replies: 10
Views: 4834
|
Forum: Database Posted: Tue Jan 18, 2011 8:36 am Subject: Binding a program to 2 differnt subsystems |
Are you implying that DB2 returned the -805 on the bind? Do you know what causes a -805? |
Topic: Binding a program to 2 differnt subsystems |
jsharon1248
Replies: 10
Views: 4834
|
Forum: Database Posted: Wed Jan 12, 2011 8:39 am Subject: Binding a program to 2 differnt subsystems |
Are you using VALIDATE(BIND), or VALIDATE(RUN) in your package BIND? You should be using VALIDATE(RUN). |
Topic: question about "fetch 1st n rows only" |
jsharon1248
Replies: 11
Views: 5076
|
Forum: Database Posted: Wed Dec 15, 2010 2:50 pm Subject: question about "fetch 1st n rows only" |
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 ... |
Topic: PL1 and SQL |
jsharon1248
Replies: 13
Views: 8098
|
Forum: Application Programming Posted: Wed Nov 03, 2010 8:15 am Subject: PL1 and SQL |
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. |
Topic: help with CASE |
jsharon1248
Replies: 3
Views: 2006
|
Forum: Database Posted: Wed Nov 03, 2010 8:11 am Subject: help with CASE |
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 ... |
Topic: PL1 and SQL |
jsharon1248
Replies: 13
Views: 8098
|
Forum: Application Programming Posted: Tue Nov 02, 2010 7:49 am Subject: PL1 and SQL |
Brain cramp. Thanks for highlighting the version differences dbz. |
Topic: PL1 and SQL |
jsharon1248
Replies: 13
Views: 8098
|
Forum: Application Programming Posted: Mon Nov 01, 2010 3:59 pm Subject: PL1 and SQL |
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 ... |
Topic: Dynamic SQL versus Static SQL |
jsharon1248
Replies: 12
Views: 4620
|
Forum: Database Posted: Thu Oct 28, 2010 7:46 am Subject: Dynamic SQL versus Static SQL |
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 ... |
Topic: Dynamic SQL versus Static SQL |
jsharon1248
Replies: 12
Views: 4620
|
Forum: Database Posted: Wed Oct 27, 2010 8:35 am Subject: Dynamic SQL versus Static SQL |
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 ... |
|