NonStop NS-Series Database Migration Guide

Migrating SQL/MP, SQL/MX, and Enscribe

Applications

HP Integrity NonStop NS-Series Database Migration Guide—540469-001

4-5

TAL and pTAL Programs That Use Embedded

SQL/MP

Example: Combining TNS Libraries

This example combines TNS libraries.

BIND

@SELECT LIST * OFF

@ADD * FROM myuserlb

@ADD * FROM $SYSTEM.ESCORT.ESCRUNTM

@SET LIKE $SYSTEM.ESCORT.ESCRUNTM

@SET HIGHPIN ON

@SET HIGHREQUESTERS ON

@BUILD myuserlb!

Use the file myuserlib as the LIBRARY libname option in the Escort SQL

PREPARE command as shown in Example: Preparing a TNS File Object File on

page 4-3.

Example: Combining TNS/E Libraries

Combining the user library with the Escort SQL runtime is not required for TNS/E user

libraries or DLLs. However, preparing the user library or user DLL establishes the

Escort SQL runtime DLL as a DLL of the user’s library or DLL. This example shows

how you PREPARE the DLL for TNS/E programs that use a custom DLL.

26> escort

Escort Command Interpreter - Version 1.7.0 - 01MAY2005 - System

\DRPSOC

Escort 1? prepare myusrdll;

--- $DATA5.TEST.MYUSRDLL preparation complete

--- Escort SQL DLL $DATA.ESCORT.ESCRUNDL

Additional Sources of Information

For more information about using the Escort SQL PREPARE command, see the

ESCORT SQL User’s Guide (Version 1.7.0), which can be obtained from Carr Scott

Software Inc. at:

http://www.carrscott.com/evaluation_prog.shtml

For more information about efficiently and successfully migrating applications that

access Enscribe files to applications that access SQL/MP tables, including a full

project-cycle example, see the white paper at:

http://www.carrscott.com/migrateonce.pdf

TAL and pTAL Programs That Use Embedded

SQL/MP

When migrating TAL and pTAL programs that contain embedded SQL/MP queries to

an Integrity NonStop NS-series system, follow these guidelines: