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.
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;";
It worked !!! Thanks a lot...
Please mark question as answered. Thanks.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.