For that many rows I would use a Database, or SQLite 3 (CBT Tape #965 and there is compile JCL on the CBT Tape the can be used against the current version of SQLite from the sqlite.org website). BPXWDYN makes a great interface to SQLITE via REXX (my preference for ISPF Apps), or there is an include API for COBOL.
_______________ Al Ferguson | mailto:afergu...@neptunescove.org Milwaukee, WI USA | http://www.neptunescove.org Dulcius ex Asperis > On 17 December 2019, at 09:40, Lizette Koehler <stars...@mindspring.com> > wrote: > > Everything depends on what your application needs to do. > > 1_ What type of performance is excepted from the application? As others > have stated, the number of rows will make it very slow to use > > 2_ how many users will be in the table at one time? > > 3_ Is it going to be shared in multiple LPARs or one LPAR? > > 4_ What is the backup and recovery process you will be using for this > application? > > 5_ What is the business impact if it is unavailable - for an hour, a day, a > week? > > 6_ Do you have any Database products? (IMS, VSAM, DB2, DataCom, etc?) > > > You want to write an application that is more robust than what you will get > in an ISPF Table with this amount of data. > > Once you determine the who, what, when, why and OMG answers, you should be > able to determine how best to create the application. > > Lizette > > >> -----Original Message----- >> From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of >> Billy Ashton >> Sent: Tuesday, December 17, 2019 7:19 AM >> To: IBM-MAIN@LISTSERV.UA.EDU >> Subject: Max Size of ISPF table? >> >> Hello, I am working with an application team, and they are creating an ISPF >> application. One of the options is to use an ISPF table for the data in one >> component, but they will have between 50,000 and 80,000 rows in the table. >> >> What are your experiences with large ISPF tables, and is a table of 80,000 >> rows acceptable or practical? Another option is to write the ISPF application >> in COBOL and use VSAM or a database (although having only a single table in >> the database doesn't sound like the best course of action, >> either.) Data is loaded on a monthly basis (maybe 500-700 records) and >> otherwise this is a read-only ISPF application. >> >> Thanks for your thoughts. >> >> Billy. >> >> ---------------------------------------------------------------------- >> For IBM-MAIN subscribe / signoff / archive access instructions, send email to >> lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
