Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
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    Post subject: What is max. no. of entries a TABLE in Easytrieve can have?
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

Site Director


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

PostPosted: Wed Mar 19, 2008 8:09 pm    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Wed Apr 09, 2008 11:46 am    Post subject:
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: 2150
Location: At my coffee table

PostPosted: Wed Apr 09, 2008 4:03 pm    Post subject: Re: What is max. no. of entries a TABLE in Easytrieve can ha
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    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 READ A PACKED "NEGATIVE" FI... jdesouza CA Products 3 Tue May 02, 2017 11:43 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us