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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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