BookmarkSubscribeRSS Feed
sasbeginner_us
Calcite | Level 5

Hi, I have a libname stmt to connect to teradata and I need to add the Query_band option to it. I am trying as below but getting error: How do i use query_band here ?

libname test_conn teradata

        schema=&db

        server=&dbserver

        sessions=1

        user="&dbuid"

        password="&dbpw"

        UTILCONN_TRANSIENT=YES

        QUERY_BAND="UtilityDataSize=SMALL";

Error log:

2065               user="&dbuid"

TERADATA_0: Executed: on connection 0
SET QUERY_BAND='UtilityDataSize=SMALL' UPDATE FOR SESSION;
2066               password="&dbpw"
2067       X       UTILCONN_TRANSIENT=YES
2068               QUERY_BAND="UtilityDataSize=SMALL";
ERROR: Error in processing session query band: A syntax error was found in the QUERY_BAND
ERROR: Error in the LIBNAME statement.

3 REPLIES 3
Haikuo
Onyx | Level 15

This is just a hunch from some legacy code using Query_band, it may or may not relevant, but you may need to add a semi-colon?

QUERY_BAND="UtilityDataSize=SMALL;";

sasbeginner_us
Calcite | Level 5

It worked !!! Thanks a lot...

Reeza
Super User

Please mark question as answered. Thanks.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1387 views
  • 0 likes
  • 3 in conversation