ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-82
SELECT
create table employee
(empnum smallint,
first_name char(15),
last_name char(20),
deptnum smallint null,
jobcode smallint null,
salary float null)
save transaction create_tab
insert into test_disk01_persnl..employee
(empnum, first_name, last_name, deptnum, jobcode, salary)
values (1234, "Georgia", "Brown", 1001, 3004, 52300)
save transaction insert_emp1
insert into test_disk01_persnl..employee
(empnum, first_name, last_name, deptnum, jobcode, salary)
values (1234, "George", "Blue", 1002, 3002, 33500)
rollback transaction
When the ROLLBACK TRANSACTION statement is encountered, the entire
transaction is rolled back.
SELECT
Use SELECT to retrieve rows from database tables.