Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB Tools

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 06-03-2013, 03:21 PM
DbBanjo DbBanjo is offline
Member
 
Join Date: Jan 2005
Location: Maryland
Posts: 77
Default DB2 - Reserved Word \ Function list ...

Howdy,

Would anyone know if it's possible to obtain a listing of
DB2 Reserved Words \ Functions via a (DB2) query? I've
never tried to do this before and I was "hoping" this could
be obtained via something in the form of:

"SELECT * FROM syscat.reservedwords"

Yes, I know the above won't work and Lol, it's probably
not this simple (or possible) - but I thought I would ask ...

For ref, I have found a DB2 query which will yield a listing
of just the DB2, system functions:

"SELECT DISTINCT RoutineName
FROM syscat.Routines
WHERE ( RoutineSchema = 'SYSFUN' )"

Thanks for any or all help,
Reply With Quote
  #2  
Old 06-05-2013, 04:25 PM
DbBanjo DbBanjo is offline
Member
 
Join Date: Jan 2005
Location: Maryland
Posts: 77
Default

Howdy,

An update: I appear to be able to obtain almost ALL
DB2 reserved words & functions via a few queries to
the DB2 syscat tables: CastFunctions, Columns,
DataTypes, Routines, Procedures, ProcParms, Tables,
TableSpaces & Views (ie: "Select From syscat.CastFunctions ..." -
as per example in my original posting).

Oddly enough, I haven't found a DB2, system table
which contains an entry for either of the two, probably
most important keywords: "Select" and "Where", Lol.
If anyone knows where these two are located - I'd be
interested to know.

Thanks,

DbBanjo (Marc Bolen)
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:13 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.