Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Cmd 'GSETL' Return code '94' in DBTS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
icetree521

New User


Joined: 04 Apr 2010
Posts: 13
Location: hangzhou, china

PostPosted: Wed Dec 01, 2010 1:14 pm    Post subject: Cmd 'GSETL' Return code '94' in DBTS
Reply with quote

Hi, all

When I use 'GSETL' cmd in DBTS, I got return code '94', which means general error indicator as Datacom return code manual said.

I refer to the Datacom manual on 'GSETL'(shows below)

COMMAND CODE: GSETL
TABLE NAME: Specify the name of the table to be used.
KEY NAME: For fastest sequential retrieval, specify the Native Key. If you
specify a key other than the Native Key, the data is internally requested.
Random retrieval is of course slower than sequential retrieval.
DATABASE ID: You must supply the binary numeric value of the database
ID that you wish to use if your program uses the User Requirements Table
with SYNONYM=YES specified for the table being requested.
KEY VALUE AREA: To start at the beginning of the table, enter low key
values in the key area. You may also obtain a position within a set of key
values by supplying a full key value or a partial key value (the high-order
portion) left-justified and padded with blanks or low values. For information
on reading a range of key values with GSETL/GETIT, see page 9-40.
WORK AREA
Not required.
ELEMENT LIST
Not required.
REQUEST QUALIFICATION AREA (RQA)
Not required.

In DBTS, I passed the parameters accordingly, so I don't know why it return '94'. Can anyone help on this? :roll:
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Dec 01, 2010 9:07 pm    Post subject:
Reply with quote

Hello,

Suggest you work with your dba. . .

A GSETL typically preceeds a blocked GETIT (iirc) and this is not something done via DBTS. . . This is something to improve the performance of large batch processes.

Suggest you try your test in a bit of test code rather than DBTS.
Back to top
View user's profile Send private message
icetree521

New User


Joined: 04 Apr 2010
Posts: 13
Location: hangzhou, china

PostPosted: Thu Dec 02, 2010 11:55 am    Post subject:
Reply with quote

Hi d.sch,
The bad news is dba always won't care small issue like this.
I think you're right. 'GSETL' work well in PGM, but return '94' when using DBTS. So I guess DBTS doesn't provide surport for 'GSETL' CMD.
Thank you for your suggestion and explanation. icon_biggrin.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Thu Dec 02, 2010 12:32 pm    Post subject: Reply to: Cmd 'GSETL' Return code '94' in DBTS
Reply with quote

Quote:
The bad news is dba always won't care small issue like this.

why should we then ?icon_evil.gif
Back to top
View user's profile Send private message
icetree521

New User


Joined: 04 Apr 2010
Posts: 13
Location: hangzhou, china

PostPosted: Thu Dec 02, 2010 12:41 pm    Post subject:
Reply with quote

Quote:
why should we then ?


It was because I am an app programmer, not a dba. Making clear what's 'GSETL' going on can be somewhat helpful, excepically for a beginer like me. icon_rolleyes.gif [/quote]
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Dec 02, 2010 8:53 pm    Post subject:
Reply with quote

Hello,

It is unfortunate that some dbas are unwilling to help with things like this.

Do you have the Datacom manuals? If not, you can reference them or download them free from the CA Support site. All you have to do is register and this is free also.
Back to top
View user's profile Send private message
icetree521

New User


Joined: 04 Apr 2010
Posts: 13
Location: hangzhou, china

PostPosted: Fri Dec 03, 2010 3:03 pm    Post subject:
Reply with quote

Hello d.sch.
Yes. I have Datacom manual in our company. thanks icon_rolleyes.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Dec 03, 2010 8:15 pm    Post subject: Reply to: Cmd 'GSETL' Return code '94' in DBTS
Reply with quote

You're welcome - good luck icon_smile.gif

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Speed-up/reduce CPU use of code prino PL/I & Assembler 0 Tue Sep 26, 2017 12:05 am
No new posts Return a Non Numeric value from REXX Learncoholic CLIST & REXX 3 Fri Sep 01, 2017 8:33 pm
This topic is locked: you cannot edit posts or make replies. how to code for GDG in Rexx cvnlynn CLIST & REXX 13 Wed Aug 09, 2017 9:13 pm
This topic is locked: you cannot edit posts or make replies. rexx code to create a ps file Bharath Vikraman CLIST & REXX 4 Mon Aug 07, 2017 10:30 am
No new posts I want to retire TRX and use only Rex... Abhinav Sharma CLIST & REXX 6 Sat Jul 29, 2017 2:53 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us