ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-94
Examples
Examples
The following batch sets PARSEONLY to ON and executes several INSERT
statements. The INSERT statements are not executed.
set parseonly on
insert into employee
(empnum, first_name, last_name, deptnum,
jobcode, salary)
values (2001, "Dana", "Hall", 1010, 3001, 40000)
insert into employee
(empnum, first_name, last_name, deptnum,
jobcode, salary)
values (2003, "Jeff", "Brown", 1030, 3001, 35000)
The following statements set TEXTSIZE to 100, then create a table with a TEXT
column. Because TEXTSIZE is set to 100, the text column will be 100 bytes wide:
set textsize 100
create table abstracts
(book_id int,
book_title char (25),
description text)
NonStop ODBC Server Compared With SQL Server
When used through the NonStop ODBC Server, SET differs from the SQL Server
implementation in the following ways:
NonStop ODBC Server Compared With NonStop SQL/MP
NonStop SQL/MP does not have a statement that corresponds to SET.
Feature In SQL Server
In Programs Used With the
NonStop ODBC Server
Parameters
available
All PARSEONLY and TEXTSIZE
Default TEXTSIZE 4096 bytes 512 bytes
Effect of setting
TEXTSIZE to 0
TEXTSIZE is set to the default
(4096 bytes).
TEXTSIZE is unchanged.