Script tab

Use this tab to specify the properties of the table's DAL script. You can also link libraries to the table.

Data Access Layers (DALs) are program scripts to guarantee data integrity. The DAL script considers for all types of dependencies, various business rules, specific constraints and so on.

For more information on DALs and the availability of two versions of these scripts, see Data Access Layer (DAL).

To edit or view the DAL script, go to the Source tab.

For more information on the LN Studio Script editor, see Script Editor.

For more information about the script properties, see the Script tab of the session editor.

General Information

Script Type

The type of program script used for this table. The script type is DAL or DAL2.

Allowed values:

Select one of the following options:


DAL	Data Access Layer that contains the Business Logic related to a table. The DAL is called by the 4GL engine on certain events. Since version 2 of DAL is available, you are advised to use DAL (version 2) scripts.
DAL (version 2)	Data Access Layer that contains the Business Logic related to a table. The DAL is called by the 4GL engine on certain events. DAL (version 2) is more integrated with the Business Data Entity (BDE) interfaces and the integration software.
Not Applicable	No DAL script is used for this table.

DAL

The name and description of the DAL script.

Usually, a script is uniquely identified by the package code, module code, and script code. The code of a DAL script corresponds with the name of the table for which the script is used.

Compile Flags

The compile flag.

For details, see the Script tab of the Session Editor.

Tools Interface Version

The Tools Interface Version (TIV) number of the script/library.

For details, see the Script tab of the Session Editor.

License

Product ID Source: The product ID for which a license is needed to compile the object. If the field is empty, no license is needed to compile the object.; Note: This field only applies to internal Infor development systems. For other development environments, this field is not available.; Allowed values:; To enter a product ID, click Browse and select an ID from the select dialog box.
Product ID Object: The product ID for which a license is needed to run the object. If the field is empty, no license is needed to run the object.; Note: This field only applies to internal Infor development systems. For other development environments, this field is not available.; Allowed values:; To enter a product ID, click Browse and select an ID from the select dialog box.

Linked Libraries

This list contains the records of all libraries linked to the DAL script of the current table.

Sorting

To sort the libraries by position, name, or description, click the corresponding column header.
When you sort by position, the sort mode is always ascending. When you sort by name or description, click the involved column header to toggle between ascending and descending sort mode.
When you sort by name or description, the Up and Down commands are disabled.

Add / remove libraries, change linking order

You can only perform the following actions if you sort the libraries by position.

To add a library, click Add. Then, press CTRL+SPACE in the Name field and select a library from the select dialog box.
To remove a library, right-click a library and select Remove.
To change the linking order of the libraries, move them up or down the list.

Note: To edit a library, click the icon behind the library name.

Pos: The library sequence number (Position). This field indicates the linking order of the libraries.; This field is read-only. It is filled automatically when you link a library.
Name: The name of the library.; Allowed values:; To specify this attribute, press CTRL+SPACE and select a library from the select dialog box.
Description: The description of the library.; Allowed values:; This field is read-only. LN Studio automatically fills in the library description after you specified the Name of the library.

Documentation

Release Notes: Use this field to specify the release notes of the table's DAL script.
Technical Documentation: Use this field to specify the technical documentation of the table's DAL script.