pears._NetPushNotificationsDeviceAdd

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

Original SQL

CREATE PROCEDURE "pears"."_NetPushNotificationsDeviceAdd"( IN "pWebUserID" CHAR(20),IN "pDeviceID" CHAR(20),IN "pDeviceToken" long VARCHAR,IN "pDeviceName" CHAR(100),IN "pDeviceType" SMALLINT ) 
RESULT( "pResult" CHAR(255) ) 
BEGIN
  INSERT INTO "PushNotificationDevice"( "PushNotificationDeviceID","DeviceToken","DeviceName","DeviceType","WebUserID" ) ON existing UPDATE defaults off VALUES
    ( "pDeviceID","pDeviceToken","pDeviceName","pDeviceType","pWebUserID" ) ;
  SELECT '0:~Success'
END /* DOC
 
2019-10-04 GJ Creation.
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."_NetPushNotificationsDeviceAdd" IS 
{CREATE PROCEDURE pears."_NetPushNotificationsDeviceAdd"( IN pWebUserID CHAR(20), IN pDeviceID CHAR(20), IN pDeviceToken long VARCHAR, IN pDeviceName CHAR(100), IN pDeviceType SMALLINT )
RESULT(pResult CHAR(255) )
BEGIN
    INSERT INTO PushNotificationDevice (PushNotificationDeviceID, DeviceToken, DeviceName, DeviceType, WebUserID) ON existing UPDATE defaults off 
    VALUES (pDeviceID, pDeviceToken, pDeviceName, pDeviceType, pWebUserID);
 
    SELECT '0:~Success';
END
 
/* DOC
 
2019-10-04 GJ Creation.
 
*/
}