[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | DBSTARS Conference |
|
| Moderator: | BROKE::BASTINE |
|
| Created: | Wed Feb 02 1994 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 791 |
| Total number of notes: | 1521 |
780.0. "Using DBKEY in interactive SQL" by BROKE::BITHER () Sat May 03 1997 14:16
Make NCV.
From: BROKE::BASTINE "please reply to [email protected]" 2-MAY-1997 20:11:39.70
Subj: Using DBKEY in interactive sql
<<< NOMAHS::DISK$NOMAHS1:[NOTES$LIBRARY]RDB_40.NOTE;1 >>>
-< Rdb/VMS - Digital's Strategic Relational Database >-
================================================================================
Note 2193.4 Using DBKEY in interactive SQL 4 of 5
UTRTSC::SOBCZAK 11 lines 24-DEC-1991 02:45
--------------------------------------------------------------------------------
Shin,
You can use DBKEYs in interactive SQL as follows:
decl schema file personnel;
declare db_key char(8);
select dbkey into db_key from employees where employee_id='00416';
select * from employees where dbkey = db_key;
Remember - this is undocumented and unsupported.
| T.R | Title | User | Personal
Name | Date | Lines
|
|---|