This is the first time I'm trying to run this. Below is the output of a "simple?" DBSQLPR but I keep getting the message "table/view does not exist". The message manuals are not helping. Any suggestions?
INPUT STATEMENT:
SELECT JOB, JOB# FROM CA7_QUEUE
WHERE DB='CA7SYSF' ;
___________SQL ERROR SUMMARY START___________
SQLCODE = -14, SQLSTATE=42704
MESSAGE = TABLE/VIEW DOES NOT EXIST: CA7_QUEUE AUTHID: SYSADM
____________SQL ERROR SUMMARY END____________
=================================================
== DBSQLPR is completing with return code 0008 ==
== ==
== Statements Found: 00001 ==
== Statement Errors: 00001 ==
== Statement Warnings: 00000 ==
=================================================
******************************** BOTTOM OF DATA ******************