IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

What is max. no. of entries a TABLE in Easytrieve can have?


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
thisak

New User


Joined: 09 Jun 2006
Posts: 14

PostPosted: Wed Mar 19, 2008 3:29 pm
Reply with quote

Hi,

Can anybody tell me what is max. no. of entries(SIZE) a TABLE in Easytrieve can have? When I referring to few documents, - there will be system default and used when we are not mentioning anything. Else, we can specify Literal which will override default. What can be max. value of this Literal?

Thanks,
Sakthi
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Wed Mar 19, 2008 8:09 pm
Reply with quote

Hello,

Are you just curious or is there some reason to find the "max" ezt will allow?

If you post what you need to do (rather than looking for some limit), we may be able to offer more usable suggestions.

If you are looking for the max to detrmine if an entire file will fit into an array, there are almost certainly much better ways to meet your need.
Back to top
View user's profile Send private message
thisak

New User


Joined: 09 Jun 2006
Posts: 14

PostPosted: Wed Apr 09, 2008 10:41 am
Reply with quote

Thanks Dick.

Actually, in our production we use lot of Easytrieve programs. In most of them we use TABLE. And due to some enhancement in functionality, we need to have more (add) entries in it. Then we have to increase the table size in program. When we compile it is throwing error - 'Table size exceeding the limit'; that is reason why we need maximum limit of table.

Please, let me know how it can found?

Thanks,
Sakthi.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Wed Apr 09, 2008 11:46 am
Reply with quote

Hello,

I believe there is an overall limit that is described in the documentation for your version of easytrieve.

If you are getting the "exceeded maximum" error, the way the proceess is implemented needs to be modified.

As i mentioned before, if you post the requirement, we may have suggestions.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Wed Apr 09, 2008 4:03 pm
Reply with quote

thisak wrote:
Can anybody tell me what is max. no. of entries(SIZE) a TABLE in Easytrieve can have? When I referring to few documents, - there will be system default and used when we are not mentioning anything. Else, we can specify Literal which will override default. What can be max. value of this Literal?
Is this what you are looking for?
CA-Easytrieve/Plus Reference Guide wrote:
The options table (EZTPOPT) provides the basic parameters that control
CA-Easytrieve/Plus operation.

TBLMAX=nnnnn
Specifies the maximum number of entries for a table which is loaded from an
external file (not instream). The valid range is 0 to 32767. Override is through the
TABLE parameter of the FILE statement. If the value that you specify for
TBLMAX is excessively high, then the total amount of storage required for
CA-Easytrieve/Plus is inflated. If the value that you specify for TBLMAX is too
low, then CA-Easytrieve/Plus issues a diagnostic message as the file is loaded.
Specify a value that is adequate for 90 percent to 95 percent of the tables, then use
the FILE statement override for particularly large tables.
Default - 256
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top