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
 

 

Tables limits in Easytrieve

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

New User


Joined: 10 Mar 2005
Posts: 1

PostPosted: Thu Mar 10, 2005 1:58 pm    Post subject: Tables limits in Easytrieve
Reply with quote

Could anyone tell about the maximum size of tables that can be created in a Easytrieve program?
Back to top
View user's profile Send private message

rakeshraut

New User


Joined: 17 May 2005
Posts: 3
Location: mumbai,india

PostPosted: Mon Jul 04, 2005 2:04 pm    Post subject:
Reply with quote

Table Definition

Instream Tables

Instream tables are specified by the INSTREAM subparameter of the TABLE option on the FILE statement. Instream tables are created by coding the table data immediately following the associated library definition statements for the table
file. Table data is ended by the word ENDTABLE in the first eight positions of a
record. Instream data is 80 characters per record. Table size is limited only by the
amount of available memory. The next exhibit illustrates an instream table
definition.
FILE WEEKDAY TABLE INSTREAM
ARG 1 1 A
DESC 3 9 A
1 SUNDAY
2 MONDAY
3 TUESDAY
4 WEDNESDAY
5 THURSDAY
6 FRIDAY
7 SATURDAY
ENDTABLE

External Tables

If you specify the TABLE option with no subparameter, the file is an external table whose maximum number of entries is limited by a value in the options table established at installation.
Check with your data center to determine this value.
If the number of entries in your external table is larger than the default value, you
can code a numeric literal as the subparameter of the TABLE option to specify
the maximum number of entries.
A file which meets the following criteria can be defined as an external table:
 An existing file that is in ascending order by the field used as a search
argument
 A file created by having its name specified as the TO parameter of a SORT
statement which is sorted into ascending order by the search argument.

Regards,
Rakesh
Back to top
View user's profile Send private message
pkmainframe

New User


Joined: 14 Jun 2005
Posts: 16
Location: India

PostPosted: Mon Jul 04, 2005 6:04 pm    Post subject:
Reply with quote

Hi,
the size of the external table by default of CA-Eztrieve on any installation is 300,000 records as external table, should be in sorted order,
for the instream table i think it will be only 256 datalines i am not pretty much sure on the instream coorect me if i am wrong.

Tx
kumar
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 Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts ISPF Tables Creation newsysprg TSO/ISPF 6 Wed Jul 13, 2016 2:21 pm
No new posts RACF Easytrieve Plus macro Susan Jackson CA Products 0 Fri Jun 03, 2016 8:25 pm
No new posts New DB2 tables creation kishpra DB2 3 Tue Feb 02, 2016 7:00 pm


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