CA Datacom/DB SQL DBSRFPR syntax error
search cancel

CA Datacom/DB SQL DBSRFPR syntax error

book

Article ID: 68797

calendar_today

Updated On:

Products

Datacom

Issue/Introduction

CA Datacom/DB SQL utility DBSRFPR job to rebind an SQL plan is failing with syntax error:


SYNTAX ERROR FOUND: CHECK PARAMETERS 

ECHO PRINT OF PARAMETER BEING PROCESSED:<PLAN> 


Environment

Release:  Any
Component:  CA Datacom SQL

Resolution

In this case, the parameter  being passed to DBSRFPR...

// PARM='PLAN authid.sqlname REBIND'

... was missing the character '=' as shown below correctly...      

// PARM='PLAN=authid.sqlname REBIND'

Additional Information

Refer to CA DATACOM CORE 15.1 documentation section "DBSRFPR Utility--SQL Upgrade Rebind"

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-mainframe-software/database-management/ca-datacom/15-1/using/using-sql/dbsrfpr-utility-sql-upgrade-rebind.html