#DateForumTypeThreadPost
1417 Dec 2009 @ 07:48 PSTUDAReplycreating stored procedureshi All,thanks , i have re-installed teradata and its working fine now.
1317 Dec 2009 @ 04:20 PSTUDAReplycreating stored procedureshi,i have given the required grants , now i am stuck with error 'C\C++ compiler not installed'I installed vc++ express edition and followe the steps prescribed in one of the post:------------------...
1217 Dec 2009 @ 04:16 PSTUDAReplyCompiling Stored Proc - VC++ not installed errorhi,i am also facing the same issue. I installed MVC++ express edition and executed the commands for compiler and link path (as described in above post).Still i am getting the error 'C\C++ compiler ...
1116 Dec 2009 @ 08:32 PSTUDAReplycreating stored procedureshithanks for the information. I am trying to assign rights explicitely to DBC using teradata administrator. I want DBC to have rights on mis_monitoring schema.Please let me know how can i assign th...
1011 Dec 2009 @ 05:57 PSTUDAReplycreating stored procedureskindly update !!!
910 Dec 2009 @ 11:11 PSTUDAReplycreating stored proceduresi tried making the procedure in SQL assistant:CREATE PROCEDURE DDD()BEGINDECLARE a INTEGER; SELECT application_key into a from dim_application ;END;Its throwing error :SPL1040:E(L3), Invalid defi...
810 Dec 2009 @ 10:32 PSTUDATopiccreating stored procedureshi,I am trying to create stored procedure in BTEQ but getting error.Procedure:CREATE PROCEDURE DDD()BEGIN DECLARE e CURSOR FOR SELECT * from dw_indial.dim_application FOR READ ONLY;END;Error:DECLA...
709 Dec 2009 @ 07:13 PSTUDAReplyAuto-increment columnHi,Thanks for the reply. Actually we have created a column without auto-increment. Now i want to alter the table to make the column as auto incremented.i tried alter command to include the code sha...
609 Dec 2009 @ 01:19 PSTUDATopicAuto-increment columnDo we have feature for auto-increment in Teradata tables? We have teradata 12.
508 Dec 2009 @ 09:52 PSTUDATopicSummary loading in teradataHi,I am new to teradata database and its different utilities. We are building a datawarehouse where we are processing raw data to warehouse hables using some ETL tool. Now we need to create data ma...
407 Dec 2009 @ 11:41 PSTToolsReplyData modelling for Teradatakindly update!!!
307 Dec 2009 @ 01:38 PSTToolsTopicData modelling for TeradataHi,We need to design a data model for DWH with underlying database as Teradata. Prior to teradata we had MySQL and we used 'Enterprise Architect' data modelling tool.But EA does not support for ter...
202 Dec 2009 @ 09:16 PSTConnectivityReplyTeradata JNDI connectivitythanks a lot, it worked :)
102 Dec 2009 @ 06:15 PSTConnectivityTopicTeradata JNDI connectivityHi,We have teradata12 installed on my machine. I am trying to connect to teradata from a java application. When i try to connect through JDBC, i can connect. But when we try to connect using jndi, ...