SQL/MP to SQL/MX Database and Application Migration Guide

Overview
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
1-8
Assessing Your Current Application and Database
Environment
FORTRAN (NonStop SQL/MX cannot
be embedded in this language.)
Pascal (NonStop SQL/MX cannot be
embedded in this language.)
TAL or pTAL (NonStop SQL/MX
cannot be embedded in this
language.)
Whether each source code
component uses SQL/MP statements
or SQL/MX statements.
Number of SQL-compiled programs
Identify these elements in the source
code:
Compilation directives
DEFINEs
SQL/MP aliases
CONTROL TABLE statements
CONTROL QUERY DEFAULT
statements
CONTROL QUERY SHAPE
statements (NonStop SQL/MX only)
Whether parallelism is on or off
Use of indexes
Information about query plans to use
for evaluation and comparison with
new query plans
Number of executable objects and
how the executable objects are
stored and versioned
Scripts by quantity of type (For
example, when converting SQL/MP
commands to SQL/MX commands,
you must convert TACL macros that
run in SQLCI to OSS shell scripts that
run in MXCI.)
Table 1-3. Database Applications (page 2 of 2)
Obtain this information