To set a value, simply click on the parameter’s Value cell and enter a value. Options for determining if both the header and the body are both compiled when compile is executed can be set in File -> Options -> Procedure Editor.Įxecute Function - Displays the Execute Function dialog to let the user specify parameters before execution. To jump to the source of a compilation error, double-click on the line in the Compilation Messages grid. Cursor left open for client applicationĪqua Data Studio’s PL/SQL and Function editor offers the user a compilation and execution environment for the development of functions.Ĭompile - Compiles the function, logs any compilation messages in the result grid below it. SELECT F_NME,L_NME,TITLE,CITY,ZIP FROM DB2ADMIN.AQUA_CUSTOMER If it's all the Managers which are needed, just specify input parameter AQUA_CODE as 'MANAGER'.Ī cursor is declared which loops through each row in the Table.ĬREATE PROCEDURE "DB2ADMIN"."SAMPLE_SP_1" ( IN Aqua_Code CHARACTER(10) ) For example, if it's desired for the stored procedure to return all rows from the table with TITLE=CTO, specify the input parameter AQUA_CODE as 'CTO'. This stored procedure, when executed, will return all rows from the table DB2ADMIN.AQUA_CUSTOMER based on the condition that Aqua_Code parameter is equal to the specified TITLE column in the table. INSERT INTO DB2ADMIN.AQUA_CUSTOMER(F_NME, L_NME, TITLE, ADDR_1, ADDR_2, CITY, ZIP) When Packages, Functions or Procedures are Invalid, a red invalid indicator appears in the Schema Browser tree over the object's icon.Ĭreating and Executing a Sample Stored Procedure in Aqua Data Studio (DB2 UDB)ĬREATE TABLE "DB2ADMIN"."AQUA_CUSTOMER" ( To execute, click the Execute button or click the Cancel button to abort execution. Options for determining if both the header and the body are both compiled when compile is executed can be set in File -> Options -> Procedure Editor.Įxecute Procedure - Displays the Execute Procedure dialog to let the user specify parameters before execution. To the right of it is a similar button with a gear behind it for executing the procedure.Ĭompile - Compiles the procedure, logs any compilation messages in the result grid below it. When a Procedure has been opened with the Procedure Editor, the button normally associated with Executing a statement becomes associated with compiling. Options for determining if both the header and the body are both compiled when compile is executed can be set in File -> Options -> Procedure Editor.Īqua Data Studio’s PL/SQL and Procedure editor offers the user a compilation and execution environment for the development of stored procedures.
Expanding marked objects in the Schema Tree shows which specific Package contents are invalid. When Procedures, Functions and Packages are invalid, they are marked in the Schema Browser with a red box icon overlay. They provide containers for related items.ĭepending on the database version and vendor, Package, Procedure and Function debugging is also available. Packages have specifications (definitions) and bodies. Packages, in Oracle, are used for encapsulating a group of functions, procedures and other program objects. They can be used for converting and evaluating data or performing other actions. User defined functions are defined with CREATE FUNCTION in SQL statements.
#AQUA DATA STUDIO MAC CODE#
They collect logic usually spread across several statements in complex actions for access from a single call.įunctions are blocks of code to perform a series of actions used to extend the functionality of a database server. Stored Procedures are subroutines stored in a database's dictionary and are often used for data validation and access control. Aqua Data Studio can access and edit Procedures, Functions and Packages through the Schema Browser.
0 kommentar(er)
