Getting "305 NOREQUEST Specified request does not exist." Error while creating Volatile table through SAS connection string.
What could be the issue ?
Thanks in Advance.
If you have assigned a libname ( perhaps to preserve volatile tables across PROC SQL instances ), and some time has elapsed, Teradata may have terminated the connection to your SAS session. When the PROC SQL with connection=global is invoked again, I suspect SAS is trying to reuse the old connection / request which Teradata can no longer find. The solution is to clear or reinstantiate the libref:
libname td clear;
libname td teradata user=&_bmbiUser pass="&_bmbipass" server=&_bmbiServer mode=teradata connection=global dbmstemp=yes;
proc sql noprint;
connect to teradata ( user=&_bmbiUser pass="&_bmbipass" server=&_bmbiServer mode=teradata connection=global);
execute ( create volatile table &_intTable._raw as (