pjs.defineTable()
This API defines an physical file (table) or logical file (view) in the calling scope, defines the file's record formats and fields, and creates a file instance that can be used to perform record I/O operations on the file. This method serves the same purpose as an RPG disk file specification.
Parameters
Internal name - A String containing the desired internal file name. A variable of this name will be defined in the calling script and will be populated with a record file instance. I/O operations are then performed by calling file-specific API.
External name (optional) - A String specifying the external name of the file object. The name can optionally be qualified with a library. If the library is not specified, then the library list is used to resolve the file. If the external name is not specified, then the internal name is used instead. This parameter can be omitted; in this case, the file configuration is passed for parameter 2. This parameter can also be specified as an Object with the following properties in order to implement dynamic external file names:
field - The name of a declared character field that hold the external file object name
extDesc (optional) - The name of the file object to use for file discovery before the file is opened and before the field is declared. If omitted, the internal name is used.
File configuration (optional) - An Object that sets file options using the property names / values shown below. If the external file name parameter is omitted, then the configuration should be passed as parameter 2.
Element name | Element type | Description |
---|---|---|
read | Boolean | Set to True to allow records to be retrieved |
update | Boolean | Set to True to allow records to be updated |
delete | Boolean | Set to True to allow records to be deleted |
write | Boolean | Set to True to allow records to be inserted |
keyed | Boolean | Set to True to enable keyed record access. Otherwise records will be accessed by relative record number |
userOpen | Boolean | Set to True to enable user-controlled file open / close using the file.open() and file.close() methods. Otherwise the file will be opened automatically before this method returns and closed automatically when the calling function ends. |
infDS | String | Name of a File Information data structure which will be populated with feedback information after each file method call. The data structure must be defined in the calling scope using pjs.define(). |
ds | String | The default data structure used for database operations. The data structure is automatically created by the pjs.defineTable() API in the current calling scope. It should not be defined explicitly in the program. |
qualified | Boolean |
Some documentation pages have recently moved to a new section: Profound AppDev. If you are having trouble finding specific pages, try the documentation search capability or reach out to our Support team!