BTEQ + QUERY_BAND -> ERROR: Unrecognized command QUERY_BAND

Tools
Enthusiast

BTEQ + QUERY_BAND -> ERROR: Unrecognized command QUERY_BAND

Hi,

I have a ERROR when I run BTEQ with QUERY_BAND option
Is supported by BTEQ QUERY_BAND ???

BTEQ 12.00.00.09 Tue Jun 29 14:14:41 2010

+---------+---------+---------+---------+---------+---------+---------+----
.logon DWP/DBA,

*** Logon successfully completed.
*** Teradata Database Release is 12.00.02.35
*** Teradata Database Version is 12.00.02.36
*** Transaction Semantics are BTET.
*** Character Set Name is 'ASCII'.

*** Total elapsed time was 18 seconds.

+---------+---------+---------+---------+---------+---------+---------+----
.SET QUERY_BAND = 'JobID=PIYULA' FOR SESSION
*** Error: Unrecognized command QUERY_BAND
+---------+---------+---------+---------+---------+---------+---------+----

SELECT TIME;

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

Time
--------
14:09:55

+---------+---------+---------+---------+---------+---------+---------+----
SELECT GetQueryBand();

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

GetQueryBand()
---------------------------------------------------------------------------

+---------+---------+---------+---------+---------+---------+---------+----

.logoff
*** You are now logged off from the DBC.
+---------+---------+---------+---------+---------+---------+---------+----
.quit
*** Exiting BTEQ...
*** RC (return code) = 0

Regards,
GALPGR
1 REPLY
Junior Supporter

Re: BTEQ + QUERY_BAND -> ERROR: Unrecognized command QUERY_BAND

SET QUERY_BAND is Teradata DDL, not a bteq command. You must use it without leading dot (.)

SET QUERY_BAND = 'JobID=PIYULA;' FOR SESSION;

HTH

Cheers.

Carlos.