pears.NetAudit

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

Original SQL

CREATE PROCEDURE "pears"."NetAudit"( IN "pWebUserID" CHAR(20),IN "pActionType" CHAR(20),IN "pDescription" long VARCHAR DEFAULT NULL,IN "pRecordID" CHAR(20) DEFAULT NULL ) 
RESULT( "pResult" CHAR(250) ) 
// IQXWeb
BEGIN
  INSERT INTO "IQXNetAuditLog"
    ( "IQXNetUserID","ActionType","Description","RecordID" ) VALUES
    ( "pWebUserID","pActionType","pDescription","pRecordID" ) ;
  SELECT '0:~Success'
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetAudit" IS 
{CREATE PROCEDURE pears.NetAudit(IN pWebUserID CHAR(20), IN pActionType CHAR(20), IN pDescription long VARCHAR DEFAULT NULL, pRecordID CHAR(20) DEFAULT NULL)
RESULT(pResult CHAR(250))
// IQXWeb
BEGIN
  INSERT INTO IQXNetAuditLog
    (IQXNetUserID, ActionType, Description, RecordID)
  VALUES
    (pWebUserID, pActionType, pDescription, pRecordID);
  SELECT '0:~Success'
END
}