Querybanding in Oracle,SQL server,Db2

General
Enthusiast

Querybanding in Oracle,SQL server,Db2

Hi,

Like how we have queryband in teradata, do we have one for oracle,db2,udb and sql server.

Also is there any MD5 function in Oracle,Db2,SQL server

Thanks,

4 REPLIES
Senior Apprentice

Re: Querybanding in Oracle,SQL server,Db2

MD5 should be easy, all those DBMSes suppport UDFs.

But afaik none supports a functionality similar to Querybanding.

Dieter

Teradata Employee

Re: Querybanding in Oracle,SQL server,Db2

Oracle has a similar function to queryband, can't remember the name at the moment. It is used particularly in the session pool area. Spelled differently of course but similar goal.

Teradata Employee

Re: Querybanding in Oracle,SQL server,Db2

The JDBC API Specification refers to this kind of database feature as "Client Info".

The Teradata JDBC Driver implements the JDBC API Client Info feature using the underlying Teradata Database Query Band feature. (However, a Java application can still use the SET QUERY_BAND command directly.)

Oracle provides a built-in procedure dbms_application_info.set_client_info to set Client Info, and Oracle stores the Client Info in a column in Oracle's v$session table.

That is very similar to how a Teradata Database Query Band is stored in a column in DBC.SessionTbl.

Enthusiast

Re: Querybanding in Oracle,SQL server,Db2

Hi ,

Aany one can help me to understand what is the use of QUERY_BAND in Teradata .

Where we have to use this ...