SQL Statements MOD009610

• Customizer Master Data SQL Statements

Information

• This module is a central administration center of the source texts, that are used in Python value ranges, macros, etc. for example.
• Here, already existing statements can be viewed or edited and new statements can be created.

Details

• PLANTA project can work with several databases, therefore the database source texts must be outsourced to an own data table.

Procedure

• Enter the name for the new statement in the Name field.
  • The ID in the Statement field is generated automatically.
• Right-click on the new statement record and select Insert SQL procedure code.
  • A record for the definition of a procedure code is created.
  • In the DI VR field, the query string with the number of the statement is created that is subsequently entered in the required value ranges, macros, etc. and refers to the current statement.
• Enter the source text of the procedure in the Source text field.
• Select the database dialect in which the source text is written in the DBMS field.
• Save.