Skip to content

Instantly share code, notes, and snippets.

@accasey

accasey/update_psoprdefn.sql

Created May 30, 2019 15:19
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save accasey/019ae9305156d63708bb65b8c207fe13 to your computer and use it in GitHub Desktop.
Save accasey/019ae9305156d63708bb65b8c207fe13 to your computer and use it in GitHub Desktop.
Download ZIP
Updates to PSOPRDEFN handling the VERSION
Raw
update_psoprdefn.sql
UPDATE PSVERSION SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME IN ('UPM','SYS')
/
UPDATE PSLOCK SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME = 'UPM'
/
DELETE FROM PSROLEUSER WHERE ROLEUSER = :1 AND ROLENAME LIKE '%%'
/
UPDATE PSOPRDEFN SET VERSION = (SELECT VERSION
FROM PSVERSION
WHERE OBJECTTYPENAME = 'UPM'
)
WHERE OPRID = :1
/
COMMIT
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment