pears.sa_conn_properties_by_name

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE PROCEDURE "pears"."sa_conn_properties_by_name"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "connidparm" VARCHAR(255) DEFAULT NULL ) 
RESULT( "Number" INTEGER,"PropNum" INTEGER,"PropName" VARCHAR(255),"PropDescription" VARCHAR(255),"Value" VARCHAR(255) ) 
BEGIN
  DECLARE LOCAL TEMPORARY TABLE "t_conn_properties"(
    "Number" INTEGER NULL,
    "PropNum" INTEGER NULL,
    "PropName" VARCHAR(255) NULL,
    "PropDescription" VARCHAR(255) NULL,
    "Value" VARCHAR(255) NULL,
    ) IN "SYSTEM" ON commit preserve ROWS;
  INSERT INTO "t_conn_properties" SELECT * FROM "sa_conn_properties"("connidparm");
  SELECT * FROM "t_conn_properties" ORDER BY "PropName" ASC,"Number" ASC
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."sa_conn_properties_by_name" IS 
{CREATE PROCEDURE sa_conn_properties_by_name 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN connidparm VARCHAR(255) DEFAULT NULL)
RESULT(NUMBER INTEGER,PropNum INTEGER,PropName VARCHAR(255),PropDescription VARCHAR(255),VALUE VARCHAR(255))
BEGIN
  DECLARE LOCAL TEMPORARY TABLE t_conn_properties(
    NUMBER INTEGER NULL,
    PropNum INTEGER NULL,
    PropName VARCHAR(255) NULL,
    PropDescription VARCHAR(255) NULL,
    VALUE VARCHAR(255) NULL,
    )
    IN SYSTEM ON commit preserve ROWS;
  INSERT INTO t_conn_properties SELECT * FROM sa_conn_properties(connidparm);
  SELECT * FROM t_conn_properties ORDER BY PropName ASC,NUMBER ASC
END
}