SYSLIB.QueryBandReservedNames

Database
Teradata Employee

SYSLIB.QueryBandReservedNames

Hi all,

 

I know teradata has the ReservedWord on each versions, and also I found the table QueryBandReservedNames in database syslib.

Is this the reserved word list of Query Band?

As a test, I tried to submit the listed word on set command ,e.g: (ACTION=test;), but it was accespted on TD15.10.

 

Thanks,


Accepted Solutions
Senior Apprentice

Re: SYSLIB.QueryBandReservedNames

Hi,

 

Yes that function does give you a list of 'reserved' QB names, but those names (as you have found out) are not prevented from bein gused.

 

Teradata recommends that QB Names on that list are only used for their intended purpose. There is nothing to stop you using them for other purposes. The following is from the 15.10 version of "SQL Data Definition Language Detailed Topics"

 

Note: As a general rule, customer applications should not use reserved query band names.
They are reserved for use by Teradata-written applications and applications written by third
party Teradata partners.
Except for the temperature-based block-level compression query bands, the reserved query
band names and values are documented only to make you aware that you should not use
them. These reserved query band names and values are intended for use only by Teradata
Enterprise Applications and by Teradata partner applications.

 

HTH

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
1 ACCEPTED SOLUTION
2 REPLIES
Senior Apprentice

Re: SYSLIB.QueryBandReservedNames

Hi,

 

Yes that function does give you a list of 'reserved' QB names, but those names (as you have found out) are not prevented from bein gused.

 

Teradata recommends that QB Names on that list are only used for their intended purpose. There is nothing to stop you using them for other purposes. The following is from the 15.10 version of "SQL Data Definition Language Detailed Topics"

 

Note: As a general rule, customer applications should not use reserved query band names.
They are reserved for use by Teradata-written applications and applications written by third
party Teradata partners.
Except for the temperature-based block-level compression query bands, the reserved query
band names and values are documented only to make you aware that you should not use
them. These reserved query band names and values are intended for use only by Teradata
Enterprise Applications and by Teradata partner applications.

 

HTH

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Teradata Employee

Re: SYSLIB.QueryBandReservedNames

Hi Dave,

 

Thank for your good answer.