@@ -135,30 +135,30 @@ To use PAL functions, you must do the following:
135135Use the following code to generate the wrap procedure:
136136
137137``` sql
138- -- Prepare Table Types
139- DROP TYPE PAL_ABC_DATA_VIEW_T;
140- CREATE TYPE PAL_ABC_DATA_VIEW_T AS TABLE (" SOMEOBJECT" NVARCHAR(80 ), " SOMEAMOUNT" DOUBLE);
141- DROP TYPE PAL_CONTROL_T;
142- CREATE TYPE PAL_CONTROL_T AS TABLE(" Name" VARCHAR (100 ), " intArgs" INT , " doubleArgs" DOUBLE, " strArgs" VARCHAR (100 ));
143- DROP TYPE PAL_ABC_RESULT_T;
144- CREATE TYPE PAL_ABC_RESULT_T AS TABLE(" ABC" NVARCHAR(10 ), " SOMEOBJECT" NVARCHAR(80 ));
145-
146- -- Create the proc using the wrapper
147- -- -Define and populate parameters table
148- DROP TABLE PAL_ABC_PDATA_TBL;
149- CREATE COLUMN TABLE PAL_ABC_PDATA_TBL(
150- " POSITION" INT ,
151- " SCHEMA_NAME" NVARCHAR(256 ),
152- " TYPE_NAME" NVARCHAR(256 ),
153- " PARAMETER_TYPE" VARCHAR (7 )
154- );
155- INSERT INTO PAL_ABC_PDATA_TBL VALUES (1 ,' TUTORIAL_PAL_ABC' ,' PAL_ABC_DATA_VIEW_T' , ' in' );
156- INSERT INTO PAL_ABC_PDATA_TBL VALUES (2 ,' TUTORIAL_PAL_ABC' ,' PAL_CONTROL_T' , ' in' );
157- INSERT INTO PAL_ABC_PDATA_TBL VALUES (3 ,' TUTORIAL_PAL_ABC' ,' PAL_ABC_RESULT_T' ,' out' );
158-
159- -- -Call the wrapper procedure to generate our ABC calculation procedure
160- CALL SYS .AFLLANG_WRAPPER_PROCEDURE_DROP (' TUTORIAL_PAL_ABC' , ' PAL_ABC_CALCULATE' );
161- CALL SYS .AFLLANG_WRAPPER_PROCEDURE_CREATE (' AFLPAL' , ' ABC' , ' TUTORIAL_PAL_ABC' , ' PAL_ABC_CALCULATE' , " TUTORIAL_PAL_ABC" ." PAL_ABC_PDATA_TBL" );
138+ -- Prepare Table Types
139+ DROP TYPE PAL_ABC_DATA_VIEW_T;
140+ CREATE TYPE PAL_ABC_DATA_VIEW_T AS TABLE (" SOMEOBJECT" NVARCHAR(80 ), " SOMEAMOUNT" DOUBLE);
141+ DROP TYPE PAL_CONTROL_T;
142+ CREATE TYPE PAL_CONTROL_T AS TABLE(" Name" VARCHAR (100 ), " intArgs" INT , " doubleArgs" DOUBLE, " strArgs" VARCHAR (100 ));
143+ DROP TYPE PAL_ABC_RESULT_T;
144+ CREATE TYPE PAL_ABC_RESULT_T AS TABLE(" ABC" NVARCHAR(10 ), " SOMEOBJECT" NVARCHAR(80 ));
145+
146+ -- Create the proc using the wrapper
147+ -- -Define and populate parameters table
148+ DROP TABLE PAL_ABC_PDATA_TBL;
149+ CREATE COLUMN TABLE PAL_ABC_PDATA_TBL(
150+ " POSITION" INT ,
151+ " SCHEMA_NAME" NVARCHAR(256 ),
152+ " TYPE_NAME" NVARCHAR(256 ),
153+ " PARAMETER_TYPE" VARCHAR (7 )
154+ );
155+ INSERT INTO PAL_ABC_PDATA_TBL VALUES (1 ,' TUTORIAL_PAL_ABC' ,' PAL_ABC_DATA_VIEW_T' , ' in' );
156+ INSERT INTO PAL_ABC_PDATA_TBL VALUES (2 ,' TUTORIAL_PAL_ABC' ,' PAL_CONTROL_T' , ' in' );
157+ INSERT INTO PAL_ABC_PDATA_TBL VALUES (3 ,' TUTORIAL_PAL_ABC' ,' PAL_ABC_RESULT_T' ,' out' );
158+
159+ -- -Call the wrapper procedure to generate our ABC calculation procedure
160+ CALL SYS .AFLLANG_WRAPPER_PROCEDURE_DROP (' TUTORIAL_PAL_ABC' , ' PAL_ABC_CALCULATE' );
161+ CALL SYS .AFLLANG_WRAPPER_PROCEDURE_CREATE (' AFLPAL' , ' ABC' , ' TUTORIAL_PAL_ABC' , ' PAL_ABC_CALCULATE' , " TUTORIAL_PAL_ABC" ." PAL_ABC_PDATA_TBL" );
162162```
163163
164164You should see following objects create in the ` TUTORIAL_PAL_ABC ` schema:
0 commit comments