MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 307 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: SOC4 Error in MOVE
jsharon1248

Replies: 4
Views: 4582

PostForum: 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: 4631

PostForum: 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: 2078

PostForum: 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: 4306

PostForum: 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: 4009

PostForum: 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: 17111

PostForum: 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: 4337

PostForum: 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: 4337

PostForum: 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: 4749

PostForum: 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: 7655

PostForum: 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: 1846

PostForum: 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: 7655

PostForum: 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: 7655

PostForum: 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: 4138

PostForum: 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: 4138

PostForum: 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 ...
 
Page 1 of 21 Goto page 1, 2, 3 ... 19, 20, 21  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group