#DateForumTypeThreadPost
830 Oct 2006 @ 05:45 PSTDatabaseTopicPrepare statement in a stored procedureHello.Do you know if executing a prepared sql in a stored procedure is possible? I mean, I'd like to declare a new variable, compose a sql statement in that variable, and then execute it. That woul...
729 Sep 2006 @ 02:08 PDTDatabaseReplyCreating a Table in a Stored ProcedureThank you Fred. I see what you say, and this is what is happening. But isn't there any workaround to solve that?
627 Sep 2006 @ 07:07 PDTDatabaseTopicCreating a Table in a Stored ProcedureI'm trying to do something as simple as this:CREATE PROCEDURE P ()BEGIN CREATE MULTISET TABLE Test (N SMALLINT);END;It says:SPL1078:E(L2), User is not authorized to use the DDL/DCL/Dynamic SQL st...
520 Mar 2006 @ 04:14 PSTDatabaseTopicselect first N recordsIn Informix, I could do SELECT FIRST 10 * FROM T1 , to get the top 10 records.In Sql Server or Access I could write SELECT TOP 10 * FROM T1.Any way to do it in Teradata?
420 Mar 2006 @ 03:20 PSTDatabaseReplyRun an Update with a subselectI reply to myself:UPDATE T1 FROM (SELECT t2_1, MIN(t2_2) from T2 group by 1) as D (D1, D2) SET Field2 = D2 WHERE Field1 = D1Got it :-)
320 Mar 2006 @ 03:12 PSTDatabaseTopicRun an Update with a subselectIs it possible to build an update statement with a subselect? I mean, I have a table T1 with two fields: Field1 (PRIMARY KEY), Field2. I have another table T2 with two fields: T2_1, T2_2. I need so...
220 Mar 2006 @ 03:06 PSTDatabaseReplyCan't connect to TeradataThank you. Now i'm able to log on. I hadn't installed the Demo, so I didn't have the Teradata Service Control and I couldn't start the database. Once I did that, I logged on as you said, with dbc, ...
116 Mar 2006 @ 04:26 PSTDatabaseTopicCan't connect to TeradataHi. I have installed the Teradata 7 Demo Database.I just can't do anything!!What can I do? How can I create a Database and tables and run a query?I've tried using the BTEQ program. I type .logon lo...