View previous topic :: View next topic
|
Author |
Message |
icetree521
New User
Joined: 04 Apr 2010 Posts: 13 Location: hangzhou, china
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
icetree521
New User
Joined: 04 Apr 2010 Posts: 13 Location: hangzhou, china
|
|
|
|
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. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
The bad news is dba always won't care small issue like this. |
why should we then ? |
|
Back to top |
|
|
icetree521
New User
Joined: 04 Apr 2010 Posts: 13 Location: hangzhou, china
|
|
|
|
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. [/quote] |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
icetree521
New User
Joined: 04 Apr 2010 Posts: 13 Location: hangzhou, china
|
|
|
|
Hello d.sch.
Yes. I have Datacom manual in our company. thanks |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome - good luck
d |
|
Back to top |
|
|
|