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

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
4-9
Converting SQLCI Scripts to NonStop SQL/MX
OBEY Command Files
OBEY command files are supported by NonStop SQL/MP in the SQL/MP
conversational interface, SQLCI, and by NonStop SQL/MX in the SQL/MX
conversational interface, MXCI. Unlike SQLCI, which runs as a TACL process, MXCI
runs as an OSS process and must be started in the OSS environment.
In NonStop SQL/MP, OBEY command files are EDIT files (type 101) with Guardian
names that you run in SQLCI.
In NonStop SQL/MX, OBEY command files are typically OSS text files (type 180) that
you run in MXCI. You can also use EDIT files as OBEY command files in MXCI if you
specify a Guardian path name.
Changes to SQL Syntax
In your OBEY command files, change the SQL/MP statements to SQL/MX statements.
See Changes to SQL Syntax
on page 4-16.
Converting SQLCI Commands to MXCI Commands
In your OBEY command files, change the SQLCI commands to MXCI commands. See
Table 4-1
.
Table 4-1. SQLCI Commands and MXCI Commands (page1of6)
SQLCI Commands
Implemented
in MXCI? Comments
ADD DEFINE Yes This command applies to SQL/MP tables only.
ALTER DEFINE Yes This command applies to SQL/MP tables only.
APPEND No
APPENDCANCEL No
APPENDRESTART No
BREAK FOOTING Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
BREAK ON Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
BREAK TITLE Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
CANCEL Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
CATALOG No