Skip to content

Instantly share code, notes, and snippets.

@accasey

accasey/update_psversion_pslock_qdm.sql

Created April 10, 2019 14:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save accasey/e85b6ffd694a1f3643d7000e8162af30 to your computer and use it in GitHub Desktop.
Save accasey/e85b6ffd694a1f3643d7000e8162af30 to your computer and use it in GitHub Desktop.
Download ZIP
Update version of Query Manager via sql
Raw
update_psversion_pslock_qdm.sql
UPDATE PSLOCK SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME = 'QDM'
/
UPDATE PSVERSION SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME IN ('QDM','SYS')
/
UPDATE PSQRYDEFN SET VERSION = (SELECT VERSION FROM PSLOCK WHERE OBJECTTYPENAME = 'QDM')
WHERE OPRID = :1
AND QRYNAME = :2
/
COMMIT
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment