pears.IQXNetRequestAction

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

Original SQL

CREATE PROCEDURE "pears"."IQXNetRequestAction"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "pWebUserID" CHAR(20),IN "pActionType" CHAR(50),IN "pTargetType" CHAR(20),IN "pTargetID" CHAR(20) ) 
BEGIN
  INSERT INTO "IQXNetAction"( "IQXNetActionID","IQXNetUserID","ActionType","TargetType","TargetID","ActionState","WhenRequested" ) VALUES
    ( "uniquekey"("pActionType"+"pTargetType"+"pTargetID"),"pWebUserID","pActionType","pTargetType","pTargetID",'0',CURRENT TIMESTAMP ) 
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."IQXNetRequestAction" IS 
{CREATE PROCEDURE IQXNetRequestAction 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN pWebUserID CHAR(20),IN pActionType CHAR(50),IN pTargetType CHAR(20),IN pTargetID CHAR(20))
BEGIN
  INSERT INTO IQXNetAction( IQXNetActionID,IQXNetUserID,ActionType,TargetType,TargetID,ActionState,WhenRequested) VALUES( 
    uniquekey(pActionType+pTargetType+pTargetID),pWebUserID,pActionType,pTargetType,pTargetID,'0',CURRENT TIMESTAMP) 
END
}