Re: udf with imbedded SQL

[rob@xxxxxxxxx]

runqry qryfile(sysfuncs)

SPECIFIC_SCHEMA  SPECIFIC_NAME  ROUTINE_SCHEMA  ROUTINE_NAME

QDIRSRV          QGLDRSDX       QDIRSRV         QGLDRSDX
ROB3             ONHAND         ROB3            ONHAND
ROB              FAXA           ROB             FAXA
ROB              FAXN           ROB             FAXN
ROB              FAXAREACODE    ROB             FAXAREACODE
ROB              FAXEXCHANGE    ROB             FAXEXCHANGE
ROB              FAXNUMBER      ROB             FAXNUMBER
ROB              FAXNEWAREA     ROB             FAXNEWAREA

ROUTINE_CREATED             ROUTINE_DEFINER ROUTINE_BODY

2001-03-10-08.21.26.962000  QDIRSRV           EXTERNAL
2001-11-30-08.02.52.040000  ROB               EXTERNAL
2002-02-01-14.34.45.394000  ROB               EXTERNAL
2002-02-01-14.35.09.230000  ROB               EXTERNAL
2002-02-01-14.35.45.376000  ROB               EXTERNAL
2002-02-01-14.35.57.685000  ROB               EXTERNAL
2002-02-01-14.36.15.262000  ROB               EXTERNAL
2002-02-12-11.09.37.984000  ROB               EXTERNAL

EXTERNAL_NAME                EXTERNAL_LANGUAGE  PARAMETER_STYLE

QSYS/QGLDRSDX                    C                  SQL
ROB3/INVENTORY(ONHAND)           RPGLE              GENERAL
ROUTINES/SRVPGM(FAXA)            RPGLE              GENERAL
ROUTINES/SRVPGM(FAXN)            RPGLE              GENERAL
ROUTINES/SRVPGM(FAXAREACODE)     RPGLE              GENERAL
ROUTINES/SRVPGM(FAXEXCHANGE)     RPGLE              GENERAL
ROUTINES/SRVPGM(FAXNUMBER)       RPGLE              GENERAL
ROUTINES/SRVPGM(FAXNEWAREA)      RPGLE              GENERAL

IS_DETERMINISTIC  SQL_DATA_ACCESS  SQL_PATH  IN_PARMS  LONG_COMMENT

      YES            NONE          -               1   -
      YES            NONE          -               4   -
      YES            NONE          -               1   -
      YES            NONE          -               1   -
      YES            NONE          -               1   -
      YES            NONE          -               1   -
      YES            NONE          -               1   -
      YES            READS         -               2   -

ROUTINE_DEFINITION  FUNCTION_ORIGIN  FUNCTION_TYPE  EXTERNAL_ACTION

-                          E               S               N
-                          E               S               N
-                          E               S               N
-                          E               S               N
-                          E               S               N
-                          E               S               N
-                          E               S               N
-                          E               S               N

IS_NULL_CALL  SCRATCH_PAD  FINAL_CALL  PARALLELIZABLE  DBINFO

    NO                  0     NO            YES         NO
    NO                  0     NO            YES         NO
    NO                  0     NO            YES         NO
    NO                  0     NO            YES         NO
    NO                  0     NO            YES         NO
    NO                  0     NO            YES         NO
    NO                  0     NO            YES         NO
    NO                  0     NO            YES         NO

SOURCE_SPECIFIC_SCHE SOURCE_SPECIFIC_NAME
MA
-                    -
-                    -
-                    -
-                    -
-                    -
-                    -
-                    -
-                    -



Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin