CA7 AL2DBI03 SQLCODE -118 SQLSTATE=RNFTE
Article ID: 233654
Updated On:
Products
Issue/Introduction
AL2DBI03 to rename columns in the CA 7 tables fails with:
--+----1----+----2----+----3----+----4----+---
INPUT STATEMENT:
ALTER TABLE CA7_QUEUE
RENAME RFFUC01 TO JOB# QUERYNO 549915448 ;
___________SQL ERROR SUMMARY START___________
SQLCODE = -118, SQLSTATE=RNFTE
MESSAGE = DSF 'NFTE' N
____________SQL ERROR SUMMARY END____________
INPUT STATEMENT:
ALTER TABLE CA7_MANUAL_RESRC
RENAME RFFUC01 TO JOB# QUERYNO 171592910 ;
___________SQL ERROR SUMMARY START___________
SQLCODE = -118, SQLSTATE=RNFTE
MESSAGE = DSF 'NFTE' N
____________SQL ERROR SUMMARY END____________
INPUT STATEMENT:
ALTER TABLE CA7_ZERO_RECORDS
RENAME RFFUC01 TO RELEASE QUERYNO 469709300 ;
___________SQL ERROR SUMMARY START___________
----+----1----+----2----+----3----+----4----+---
SQLCODE = -118, SQLSTATE=RNFTE
MESSAGE = DSF 'NFTE' N
____________SQL ERROR SUMMARY END____________
Environment
CA 7 Workload Automation
Version: 12.1
Datacom/AD
Version: 15.1
Cause
Columns are already renamed.
Resolution
Nothing needs to be done . All is fine.
Additional Information
Datacom DSF error FTE is documented here
Feedback
