Asset Suite / PassPortGeek

Create a text file of DD elements newly created in the Analyst Workbench (AWB) via File, Export, Incremental.

This example is going to assume PassPort is running on Unix. FTP the text file of DD elements to the Unix box. Let's say the DD file is DD_file and all new DD elements look like NEW00001, NEW00002, etc. Use the Unix command: cat DD_file | grep NEW0 > DD_file_new to extract the new elements into file DD_file_new.

Create example load files for tables TIDDDELE and TIDDDMST

Use PassPort Duty Free tool dftbunld to unload tables TIDDDELE and TIDDDMST. This creates TIDDDELE.ctl and TIDDDMST.ctl, the load control files, and TIDDDELE.dat and TIDDDMST.dat, the unloaded data. Use an editor on the .dat files to eliminate all but a couple of records. These records will serve as templates for adding the new element data.

Create load files with new element data

A positional editor such as ISPF or UltraEdit will make this much easier. The editor needs to align data into columns, allow over typing and does not do any formatting.

FTP the chopped down TIDDDELE.dat and TIDDDMST.dat files. Open them in the editor and manually add new lines with values from DD_file_new. The load control files describe what positions hold what data and use a tool like DBArtisan or Golden to display existing data to help see what goes where.

FTP the new TIDDDELE.dat and TIDDDMST.dat to the Unix box.

Append the new elements to the server DD

Try this in a test region a few times before doing it in a critical region. Use PassPort Duty Free tool dftbld to load tables TIDDDELE and TIDDDMST with the new element data. Be certain to specify APPEND. Data misalignment problems and typos will most likely surface here.

SQL to view DD elements within the server database

select * from tidddele where elem_nbr like 'NEW0%';
select * from tidddmst where elem_nbr like 'NEW0%';