#DateForumTypeThreadPost
428 Jan 2014 @ 08:29 PSTConnectivityTopicSAS via OLEDB and Null ValuesI am trying to load a small SAS table into Teradata via SAS/ACCESS connectivity  & OLE DB. The table is mostly NULL and consists of: id, SiteA, SiteB, SiteC, SiteD.  The Site va...
312 Sep 2013 @ 02:35 PDTDatabaseReplyVolatile Table Use, Scope, & Ownership within Stored ProceduresI have found a way to dynamically name the tables within the procedure which will reduce the likelihood of such conflicts.  However, I am still not clear out how to structure the continue hand...
212 Sep 2013 @ 02:17 PDTDatabaseTopicStored Procedure: Validating Volatile Table Output NamesI have a stored procedure with a call like this: REPLACE PROCEDURE databasename.ProcedureName (    IN  tblInput1   VARCHAR(300) NOT CS,  IN  tblInput2  ...
110 Sep 2013 @ 10:49 PDTDatabaseTopicVolatile Table Use, Scope, & Ownership within Stored ProceduresI would like to do some select queries within a stored procedure and store the output to a volatile table.  I am not clear on the owernship and scope of the volatile tables. I have r...