#DateForumTypeThreadPost
818 Sep 2014 @ 11:11 PDTGeneralReplyUSING DDMMYYYY INSIDE DBC.SYSEXECSQL() in Stored ProcedureThank you Dieter. Escaping single quotes issue in SP is solved for me too. Sujatha.
712 Sep 2014 @ 05:11 PDTDatabaseReplyPass single quote as parameter in stored procedurereplace procedure proc1 (in oprList varchar(500)) begin declare ssql1 varchar(1000); set ssql1=' create table table1 ( ' || oprList || ' );'; execute immediate ssql1; end ...
612 Sep 2014 @ 04:22 PDTDatabaseTopicPass single quote as parameter in stored procedureI'm creating a table in stored procedure which uses 'title' keyword. Create table t1 ( O1 varchar(5) title ' "O1 " ' , O2 varchar(5) title ' " O2" ...
507 Dec 2011 @ 12:40 PSTConnectivityReplyUnable to connect through .net odbc I solved it myself.. The error that i received was 'not enough information to logon'. Had to trim the username and password. The above connection string format is correct
406 Dec 2011 @ 10:02 PSTConnectivityTopicUnable to connect through .net odbc Im able to connect to teradata DB through SQL assistant with required credentials But unable to connect to teradata through .Net ODBC The connection string that i used is driver={Ter...
314 Sep 2011 @ 11:53 PDTDatabaseTopicTeradata client / server Greetings, My application works on Teradata client. I dont have access to server and hence i do not know what operations can be done at server . For e.g., at client side, DB updations , runn...
219 Nov 2010 @ 01:26 PSTDatabaseReplyConditional statement in Teradata macroThank you for responding. Yeah, SP (stored procedures) exist in teradata, but currently Im not provided with any access to write any SPs, I have only macros access and im looking to embed any p...
119 Nov 2010 @ 10:29 PSTDatabaseTopicConditional statement in Teradata macroI have a big list of stored procedures created in SQL server. I have to convert them to tereadata macros and need help in knowing logic for If and Else in a macro. Please help me with the macro str...