Datacom

 View Only

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 

Oct 16, 2015 05:33 AM

 

 

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 . 

 

 

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.