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 3 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Embedded SQL select with ORDER BY and FETCH FIRST
suhas_pm

Replies: 8
Views: 3408

PostForum: Database   Posted: Tue Jul 19, 2005 6:18 am   Subject: Embedded SQL select with ORDER BY and FETCH FIRST
following are the probable reasons for DSNH109I:
1. ORDER BY not allowed since result of SELECT is single row (at max)
2. SELECT used in cursor declaration can not have an INTO clause

Looks like ...
  Topic: EXTENDED keyword on KSDS file Organisation
suhas_pm

Replies: 5
Views: 2660

PostForum: Job Control Language(JCL)   Posted: Tue Jul 19, 2005 5:49 am   Subject: EXTENDED keyword on KSDS file Organisation
Looks like storage class was specified while allocating the cluster. Remove specification for storage class and then allocate the cluster.
-suhas
  Topic: Checking existence of a dataset in JCL at runtime
suhas_pm

Replies: 2
Views: 2160

PostForum: Utilities   Posted: Tue Oct 12, 2004 5:47 am   Subject: Checking existence of a dataset in JCL at runtime
In a JCL, I want to execute a step on the basis of existence of a particular version of a GDG. How to do this?

e.g. consider that I want to execute STEP020 only if dataset NODE1.NODE2.NODE3.NODE4(- ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group