List of isql keywords?
Satoshi Ueno
I'm looking for a list of isql keywords (i.e., "select", "from",
"where", etc.) in text format.
I remember someone posted it in this newsgroup a while ago, but I
don't have that copy...
Thanks,
--
Satoshi Ueno Internet: satosh...@fi.gs.com
Goldman Sachs (Japan) Ltd. Tel:03-5563-7514 Fax:03-3589-5880
Daniel A. Graifer
>I'm looking for a list of isql keywords (i.e., "select", "from",
>"where", etc.) in text format.
I would think these are transact-sql (T-SQL) keywords. Isql keywords would
be things like "go" and "reset", no?
Dan
--
Daniel A. Graifer Coastal Capital Funding Corp. &
Sr. Vice President, Financial Systems Franklin Mortgage Capital Corp.
(703)205-5460 3190 Fairview Park Dr. Suite 200
uucp: uunet!fmccva!dag Falls Church, VA 22042
Ashutosh Joglekar
: Hi,
: I'm looking for a list of isql keywords (i.e., "select", "from",
: "where", etc.) in text format.
: I remember someone posted it in this newsgroup a while ago, but I
: don't have that copy...
I don't have a text copy but check out Appendix A of the Sys10 SysAdmin
Guide. They have separate lists of T-SQL, Apt-SQL, SQL-92 and potential
SQL-92 keywords. Perhaps some good samaritan could type them in
and post ? There's a sp_checkreswords ( spelling ? ) that actually
checks for reserved words usage. Maybe you could load a Sys10 version
of this procedure into a 4.9.2 database to check for potential
conflicts after upgrade ? But, I digress..
Cheers,
Ashu
--
<ashu...@panix.com> aka Ashutosh Joglekar
Van Scott
Satoshi,
look at the scripts that install the syntax database
(in something like /sybase/scripts) they have the
syntax for both tsql and dblibrary.
>> I'm looking for a list of isql keywords (i.e., "select", "from",
>> "where", etc.) in text format.
Van Scott
DRACS Consulting Group
813/738-3159
Bret Halford
That was me!
Here it is again....
---------------------------
Transact-SQL Reserved Words
The following words are reserved by SQL Server as keywords (command verbs) and cannot be used for the names of database objects. They may be used for the names of local variables and stored procedure parameter names
---------------------------
add
all
alter
and
any
arith_overflow
as
asc
at
authorization
avg
begin
between
break
browse
bulk
by
cascade
char_convert
check
checkpoint
close
clustered
commit
compute
confirm
constraint
continue
controlrow
convert
count
create
current
cursor
data_pgs
database
dbcc
deallocate
declare
default
delete
desc
disk
distinct
double
drop
dummy
dump
else
end
endtran
errlvl
errorexit
escape
except
exec
execute
exists
exit
fetch
fillfactor
for
foreign
from
goto
grant
group
having
holdlock
identity
identity_insert
if
in
index
insert
intersect
into
is
isolation
key
kill
level
like
lineno
load
max
min
mirror
mirrorexit
national
noholdlock
nonclustered
not
null
numeric_truncation
of
off
offsets
on
once
only
open
option
or
order
over
perm
permanent
plan
precision
prepare
primary
print
privileges
proc
procedure
processexit
public
raiserror
read
readtext
reconfigure
references
replace
reserved_pgs
return
revoke
role
rollback
rowcnt
rowcount
rows
rule
save
schema
select
set
setuser
shared
shutdown
some
statistics
stripe
sum
syb_identity
syb_restree
syb_terminate
table
temp
temporary
textsize
to
tran
transaction
trigger
truncate
tsequal
union
unique
update
used_pgs
user
user_option
using
values
varying
view
waitfor
where
while
with
work
writetext
---------------------------
New Keywords in System 10.x
The following keywords were added in System 10.x.
---------------------------
arith_overflow
at
authorization
cascade
check
close
constraint
current
cursor
deallocate
double
endtran
escape
fetch
foreign
identity
identity_insert
isolation
key
level
mirror
national
noholdlock
numeric_truncation
of
only
open
option
precision
primary
privileges
read
references
replace
role
rows
schema
shared
some
stripe
syb_identity
syb_restree
user
user_option
varying
work
----------------
APT-SQL Keywords
If you are planning to use APT-SQL, avoid using these words as identifiers.
----------------
$channel
$curfield
$curform
$curgroup
$curpick
$date
$index
$status
abort
and
append
apt
backtab
bell
binary
bit
call
callextern
callform
callreport
cancelform
case
channel
char
charindex
closesql
connect
curindex
cursqlindex
datalength
datename
datepart
define
disconnect
enter
entry
exitform
exp
false
fetchsql
field
float
foreach
form
global
hidden
image
int
interruptsql
list
local
log
lower
mchoice
menu
menubar
money
nextquery
nomsg
opensql
parentname
perform
positionform
post
printform
rchoice
remote
reset
schoice
scroll
shared
smallint
sqlbegin
sqlend
sqlexpr
sqlrow
submit
substring
switch
switchend
system
tab
text
textport
tinyint
trace
transfer
trim
true
upper
useform
variable
-----------------
SQL2 Keywords
SQL Server 10.x includes some support for entry-level SQL2 features. Keywords for the supported features are already included in the Transact-SQL list of keywords.
Full SQL2 implementation includes the words listed below. Sybase is providing this list for your convenience.
The publication of this information does not commit Sybase to providing all of these SQL2 features in subsequent releases.
Subsequent releases may include keywords not included in this list.
-----------------
absolute
action
allocate
are
assertion
bit
bit_length
both
cascaded
case
cast
catalog
char
character
char_length
coalesce
collate
collation
column
connect
connection
constraints
corresponding
cross
current_date
current_time
current_timestamp
current_user
date
day
dec
decimal
deferrable
deferred
describe
descriptor
diagnostics
disconnect
domain
end-exec
exception
external
extract
false
first
float
found
full
get
global
go
hour
immediate
indicator
initially
inner
input
insensitive
int
integer
interval
join
language
last
leading
left
local
lower
match
minute
module
month
names
natural
nchar
next
no
nullif
numeric
octet_length
outer
output
overlaps
pad
partial
position
preserve
prior
real
relative
restrict
right
scroll
second
section
session
session_user
size
smallint
space
sql
sqlcode
sqlerror
sqlstate
substring
system_user
then
time
timestamp
timezone_hour
timezone_minute
trailing
translate
translation
trim
true
unknown
upper
usage
value
varchar
when
whenever
write
year
zone
-------------
Potential SQL2 Reserved Words
If you are using the ISO/IEC 9075:1989 standard, avoid using the following words, as
these words may become SQL2 reserved words in the future.
-----------------------------
after
alias
async
before
boolean
breadth
completion
call
cycle
data
depth
dictionary
each
elseif
equals
general
ignore
leave
less
limit
loop
modify
new
none
object
oid
old
operation
operators
others
parameters
pendant
preorder
private
protected
recursive
ref
referencing
resignal
return
returns
role
routine
row
savepoint
search
sensitive
sequence
signal
similar
sqlexception
structure
test
there
type
under
variable
virtual
visible
wait
without
Karen Paulsell
>: Hi,
>
>: I'm looking for a list of isql keywords (i.e., "select", "from",
>: "where", etc.) in text format.
If you have System 10, run this in the master database:
select name from spt_values where type = 'W'
This information was added so the "sp_checkreswords" upgrade
procedure could help users locate 4.X object names that matched
the new reserved words for System 10.
I suggest you heed the lists of keywords that other posters
mentioned, and attempt to avoid the potential SQL2 additions,
these are NOT included in the spt_values list, only current
System 10 keywords are in that list.