CA Tech Tip : CA Datadictionary and SQL - 14.0 DDTRSLM IMPORT PLAN fails with SQLCODE -20 using a TRANSF file created by running DDTRSLM from RO82735

Document created by KarinaPulinx Employee on Oct 16, 2015
Version 1Show Document
  • View in full screen mode

 

 

CA Tech Tip from Karina Pulinx , Principal Support Engineer , for October 16 , 2015 .

 

DDTRSLM EXPORT PLAN ( DDTRSLM is the utility to transport SQL Objects ) ran successfully in the source

CA Datacom Multi-User ( MUF ) environment  where RO82735 has been installed.

 

DDTRSLM IMPORT PLAN fails in the target environment with 

 

DDTRS0016E DBQPRPS FAILED SQL COMMAND QPRPS, RC: -20.

SQL ERROR MESSAGE: BAD SYNTAX

 

RO82735 is not yet active in the target MUF environment .

 

To resolve the SQLCODE -20 use DDTRSLM from RO82735 in both the EXPORT and the IMPORT PLAN jobs .

We missed to indicate this in the HOLD ACTION from RO82735 . CA will soon provide another PTF with the correct HOLD ACTION . 

 

 

Attachments

    Outcomes