Chapter Contents |
Previous |
Next |
SELECT |
Required statement | |
Applies to: | view descriptor |
Syntax | |
Details |
Syntax |
SELECT ALL |
<">column-identifier-1<">
<...<">column-identifier-n<">>; |
Details |
The SELECT statement specifies which DBMS columns in the access descriptor to include in the view descriptor. This is a required statement and is used only when defining view descriptors.
The SELECT statement can take one of the following arguments:
select 1 2 3;
If the CA-DATACOM/DB field name contains special characters or national characters, enclose the name in quotes. You can select as many DBMS columns as you want in one SELECT statement.
SELECT statements are cumulative within the same view creation. That is, if you submit the following two SELECT statements, columns 1, 5, and 6 are selected, not just columns 5 and 6:
select 1; select 5 6;
To clear all your current selections when creating a
view descriptor, use the
RESET ALL
statement; you can then
use another SELECT statement to select new columns.
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.