MVSFORUMS.com
A Community of and for MVS Professionals
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log 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
Forum:
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
Forum:
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
Forum:
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:
Select a forum
Announcements
----------------
MVSFORUMS - Announcements
Help Boards
----------------
Application Programming
Database
Utilities
Job Control Language(JCL)
CICS and Middleware
IMS
TSO and ISPF
Data Management
Problem Determination
Mainframe Challenge
About Mvsforums
Other Technical Topics
Related Non-Technical Topics
Interview Q & A
General
----------------
Tools and Downloads
IT News
Technical FAQ (Tips)
----------------
Programming Languages
DB2/IMS
JCL/SORT
TSO and ISPF
MVSFORUMS
Powered by
phpBB
© 2001, 2005 phpBB Group