All Forums Database
jwh_ws 15 posts Joined 04/11
04 Aug 2011
Is there a "reserved words" table/view?

I've looked through DBC and can't find one. I'd rather not have to maintain my own table containing Reserved and new Non-Reserved words by DBS version.

tomnolan 594 posts Joined 01/08
04 Aug 2011

Teradata Database 13.10 introduced the SYSLIB.SQLRestrictedWords view.

sonali 1 post Joined 08/11
23 Aug 2011

Can anyone suggest what is the keyword for fetching data in read only mode ... as UR keyword in DB2

barryhull 31 posts Joined 05/11
26 Aug 2011

When you do your SELECT, put the phrase "LOCKING ROW FOR ACCESS" in front of it:

LOCKING ROW FOR ACCESS
SELECT...

;

That will cause the SQL to use access locking which will read uncommitted data and will not cause your program to keep others from updating the data while you're reading it.

 

Karam 75 posts Joined 07/09
26 Aug 2011

If you refer to Teradata  documentation- SQL Fundamental then there is Appendix B: Restricted Words. Another document is Release Summary for a given release.

You must sign in to leave a comment.