Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Changed: | ||||||||
< < | The Use of Cached FilesAPPX 4.1 introduces the ability to create and access a cached instance of a file in memory. The CREATE, OPEN, SCRATCH, and IF EXIST statements have been modified to include new syntax to support this feature: CREATE statement:The CREATE statement can now create and open a cached instance of a file. Specifying a CACHE option other than 'NONE' causes a cached instance of a file to be created in memory and opened instead of the normal disk instance of the file. The value of the CACHE option determines how the cached instance of the file is populated. If --- NEXT DATABASE is specified for a CREATE statement which creates a cached file, then the value of next database determines the source database for loading the cache. Otherwise the current database determines the source of the file used to load the cache. CREATE ___ ________ SHARE? _ FAIL _ CACHE _______ | |||||||
> > | The Use of Cached FilesAPPX 4.1 introduces the ability to create and access a cached instance of a file in memory. The CREATE, OPEN, SCRATCH, and IF EXIST statements have been modified to include new syntax to support this feature:CREATE statement:The CREATE statement can now create and open a cached instance of a file. Specifying a CACHE option other than 'NONE' causes a cached instance of a file to be created in memory and opened instead of the normal disk instance of the file. The value of the CACHE option determines how the cached instance of the file is populated. If --- NEXT DATABASE is specified for a CREATE statement which creates a cached file, then the value of next database determines the source database for loading the cache. Otherwise the current database determines the source of the file used to load the cache.CREATE ___ ________ SHARE? _ FAIL _ CACHE _______ | |||||||
(1) (2) (3) (4) (5) | ||||||||
Changed: | ||||||||
< < | (1) Application ID CACHE: NONE - Create and open the file as a normal, non-cached file.
| |||||||
> > |
(1) Application ID (2) File Name (3) Share Y/N? (4) Fail Type (5) Cache type { blank || NONE, LOAD, AUTO, NOLOAD || NO LOAD } CACHE: NONE - Create and open the file as a normal, non-cached file. NO LOAD - Create and open the cached instance of the file but do not load any records into the cache file. LOAD - Create and open the cached instance of the file and load cache file from the disk instance of file. AUTO - (Currently same as LOAD) Create and open the cached instance of the file. Dynamically populate the cache from the disk instance of the file as records are individually read.
A parameter added to the OPEN statement allows it to open either the cached instance of a file or the disk instance of the file.
If CACHE=Y and the cached instance of the file does not exist, then the OPEN statement will fail. So, a CREATE statement must be used to create the cached instance of a file before the OPEN statement can be used to open it.
If --- NEXT DATABASE is specified in conjunction with CACHE=Y, then --- NEXT DATABASE is cleared and ignored.
| |||||||
* loads it with the "Inside" salesreps * * Create a cache instance of the SALESREP file | ||||||||
Line: 69 to 96 | ||||||||
* Close the disk instance and open the cached instance - all * references in the process will now use the cached instance OPEN CCA SALESREP SHARE? Y FAIL 0 CACHE? Y | ||||||||
Changed: | ||||||||
< < | -- JoeOrtagus - 2012-01-18 | |||||||
> > | -- JoeOrtagus - 2012-01-18 | |||||||
\ No newline at end of file |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
Added: | ||||||||
> > |
The Use of Cached FilesAPPX 4.1 introduces the ability to create and access a cached instance of a file in memory. The CREATE, OPEN, SCRATCH, and IF EXIST statements have been modified to include new syntax to support this feature: CREATE statement:The CREATE statement can now create and open a cached instance of a file. Specifying a CACHE option other than 'NONE' causes a cached instance of a file to be created in memory and opened instead of the normal disk instance of the file. The value of the CACHE option determines how the cached instance of the file is populated. If --- NEXT DATABASE is specified for a CREATE statement which creates a cached file, then the value of next database determines the source database for loading the cache. Otherwise the current database determines the source of the file used to load the cache. CREATE ___ ________ SHARE? _ FAIL _ CACHE _______ (1) (2) (3) (4) (5) (1) Application ID CACHE: NONE - Create and open the file as a normal, non-cached file.
|