"Create Temporary Table" and "Create Like" function in the Object Explorer produce the following error:
Quest.Comapre.Schema.Common.PI.CNSLoader+ModelException
System.ApplicationException: Query: SELECT * FROM QUEST.QCTEMPLATE_REPO200
where name in ('QCSORTIN', 'QCSORTO', 'QCERROR', 'QCMAP', 'QCDISC', 'QCUNLDDN', 'QCERROR', 'QCSORTIN', 'QCSORTO', 'QCCPY1')
FOR READ ONLY WITH UR
Could be a rights issue with the Quest table that Toad DB2 needs
QUEST.QCTEMPLATE_REPO200
1. Run the following query to see if results return.
SELECT * FROM QUEST.QCTEMPLATE_REPO200
where name in ('QCSORTIN', 'QCSORTO', 'QCERROR', 'QCMAP', 'QCDISC', 'QCUNLDDN', 'QCERROR', 'QCSORTIN', 'QCSORTO', 'QCCPY1')
FOR READ ONLY WITH UR
2. If not grant then necessary permission to the QUEST.QCTEMPLATE_REPO200
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center