CA 7 Workload Automation

 View Only
  • 1.  Getting started withDBSQLPR and not working

    Posted Oct 22, 2020 04:37 PM
    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 ******************


  • 2.  RE: Getting started withDBSQLPR and not working

    Posted Oct 22, 2020 05:25 PM
    The default AUTHID in DBSQLPR is SYSADM. So it is trying to find a table called SYSADM.CA7_QUEUE, which does not exist.
    All the CA 7 tables are defined under authid MFWA. So if you change your query to...

    SELECT JOB, JOB# FROM MFWA.CA7_QUEUE WHERE DB='CA7SYSF' ; ​...then it should work fine.
    Alternatively you could code the following in the OPTIONS DD...

    //OPTIONS DD * AUTHID=MFWA ​ /*...so that you don't have to qualify the table name with the authid in the FROM clause.

    ------------------------------
    Technical Consultant
    Dixons Carphone
    ------------------------------



  • 3.  RE: Getting started withDBSQLPR and not working

    Posted Oct 22, 2020 05:32 PM
    Sorry the formatting went haywire. That OPTIONS alternative should have been...

    //OPTIONS DD *
    AUTHID=MFWA ​
    /*

    ------------------------------
    Technical Consultant
    Dixons Carphone
    ------------------------------



  • 4.  RE: Getting started withDBSQLPR and not working

    Posted Oct 23, 2020 08:50 AM
    Also, there is no Job# in that table.  There is a CA7# and JES#.

    --

    Earl McKenzie

    Operations Consultant

     

    TSYS

     

    +1 706.649.4957 O

    +1 706.325.4478 M

    emckenzi@tsys.com

     

    A Global Payments Company

     

    NOTICE: This email message is for the sole use of the addressee(s) named above and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this message or any attachments is expressly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies and backups of the original email.


    NOTICE: This email message is for the sole use of the addressee(s) named above and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this message or any attachments is expressly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies and backups of the original message.