Consolidating Telon Design Facilities

Products

• Telon Application Generator

Issue/Introduction

 

Consolidate many Telon Design Facilities, into One.

Looking at combining all our existing Telon TDFs in to one and would like to transfer all existing imported views in to the single TDF from all other TDFs, to avoid the overhead of doing this manually as the source code is imported.

 

 

Environment

Telon Generator Application, many releases

Resolution

 

Using the Telon Transport utility, will bring VIEWS(TLNROWS) from Data Administration out to a flat file, for transporting into another TDF.

Using the following JCL of;

CAWLINST(JUTRANO)

CAWLINST(TLNOTRAN)

 

000096 //TRANPORT EXEC TLNOTRAN,TRNFILE='your.TRANOUT'

000099 //TRANPORT.TPCTL DD *

000100 TRANPORT EXPORTSELAUTOREF

000101 TABLE TELON.TRGEMPL

000102 END

000103 /*

000104 //

 

Produces a Transport file out of the TDF as(just the first few lines);

 

TRANPORT 07/25/1613:58:15

TABLE BASE

QUAL TELON

TBLNAME TRGEMPL

LASTUSER CERRI01

LASTUPD 160725

UPDTIME 1340

CRTDATE 150211

DESC CREATED BY DB2 CATALOG IMPORT

TLNNAME TRGEMPL

LABEL TRGEMPL

DCLCOPY TRGEMPL

COPY NONE

SYNONYM Y

RDBMS DB2

TLNROW TRGEMPL

DCLCOL EMPL_ID

KEY Y

NOTNULL Y

TYPE CHAR

LTH 00006

END DCLCOL

 

Additional Information:

With regards to other questions/concerns; 

 

1. This will export selected / all Tlnrows from one Telon depending on the JCL used? 

YES: 

You can supply one of these types of values: 

? * (or *.* for TABLEs or JOINs)—Causes all key values for the identified object to be processed. 

? Exact value—Specifies that the object identified by the exact value is processed. 

? Partial key—Indicates a partial key followed by a wildcard character (*) that causes processing of all key values that begin with the same partial key. For example, ABCD* causes all key values beginning with ABCD to be processed. In a partial key value, the asterisk represents one or more characters. 

? Wildcard pattern—Specifies a combination of exact value and one or more wildcards, represented by an asterisk (*), that causes processing of all key values that match the pattern. For example, TP**LS causes processing of all key values beginning with TP followed by any two characters and ending with LS. In a wildcard pattern, each asterisk represents one and only one character. 

 

TRANPORT EXPORTSELAUTOREF 

TABLE *.* 

JOIN CASCHED.* 

END 

/* 

 

2. Does CA supply a job to import as well? 

YES: 

Using the following JCL of; 

CAWLINST(JUTRANI) 

CAWLINST(TLNITRAN) 

 

3. Is there a way of specifying if an imported view ovewrites / is ignored if the same view already exists in the destination TDF. 

 

Function Valid value Meaning 

 

Transport out AUTOREF Automatically transport out referenced items 

when primary items are specified (auto-reference processing). 

 

NOREF (Default) Do not use auto-reference processing. 

 

Transport in IGNORE Do not replace an existing object, but add 

the specified object if it does not exist on the TDF 

 

REPLACE Replace an existing object, or add the specified 

object if it does not exist on the TDF. 

AUTOMnn Use auto-merge processing with a maximum security level of nn. 

 

//TRANPORT.TPCTL DD * 

TRANPORT IMPORTALLAUTOM00 

END 

/* 

// 

//TRANPORT.TPCTL DD * 

TRANPORT IMPORTALLIGNORE 

END 

/* 

// 

//TRANPORT.TPCTL DD * 

TRANPORT IMPORTALLREPLACE 

END 

/* 

//