SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
10-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 10-16.
Converting SQLCI Commands to MXCI Commands
In your OBEY command files, change the SQLCI commands to MXCI commands. See
Table 10-1
.
Table 10-1. SQLCI Commands and MXCI Commands (page 1 of 7)
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 10-15.
BREAK ON Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
BREAK TITLE Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
CANCEL Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
CATALOG No