#DateForumTypeThreadPost
19801 Jan 2009 @ 11:23 PSTDatabaseReplyCannot Insert Feb 29 2009 Leap Year valueHello,It works fine. What error are you facing? Following example may be of some help:CREATE VOLATILE TABLE Table1 (col1 DATE FORMAT 'YYYY-MM-DD') ON COMMIT PRESERVE ROWS;INSERT Table1 VALUES ('200...
19731 Dec 2008 @ 11:19 PSTDatabaseReplyDECLARE variable like ROWTYPE in TeradataHello,You can use volatile/temporary tables instead.Regards,Adeel
19603 Dec 2008 @ 06:27 PSTDatabaseReplyHow can we find dipendency in Teradata databaseTriggers are only created on tables!Regards,Adeel
19503 Dec 2008 @ 05:41 PSTDatabaseReplyHow can we find dipendency in Teradata databaseWell, yes Teradata do have triggers and you can do this in them but I am not convinced why you really want to implement such a trigger? And also what type of trigger will you like to use? AFTER/BEF...
19402 Dec 2008 @ 06:20 PSTDatabaseReplyUse of order byThis time without going into details, the data read first will be sent first if it satisfies the given condition/order.Regards,Adeel
19328 Nov 2008 @ 07:04 PSTUDAReplychar to timestampWell, about the SQL Assistant and BTEQ check the link below:http://www.teradata.com/teradataforum/Topic13488-9-1.aspx#bm13500Try following:INSERT destination_table (date_modified)SELECT CAST('28/02...
19228 Nov 2008 @ 06:28 PSTUDAReplychar to timestampHello,First of all, why are you casting it to VARCHAR to put it in TIMESTAMP(0), after converting it to TIMESTAMP(0)?Second, paranthesis are not ok.Third, following should work, if the column reall...
19127 Nov 2008 @ 04:36 PSTDatabaseReplyUse of order byAgain....how can you expect the result to be ordered on something, without mentioning it!As per my knowledge, it returns the rows on the AMP basis, it has nothing to do with rowid or the sequence y...
19027 Nov 2008 @ 02:54 PSTDatabaseReplyUse of order byHello,In case of specifying single column in ORDER BY, it orders the column values of a single column, regardless of other column values. If you apply ORDER BY on a column containing 1, it will alw...
18927 Nov 2008 @ 02:14 PSTDatabaseReplyHow can we find dipendency in Teradata databaseWell, for similar information you can use the table named "DBC.TVM".If you are looking for this table, to get the database object's definition, then you should be using SHOW command. Some examples ...
18827 Nov 2008 @ 01:46 PSTDatabaseReplyHow can we find dipendency in Teradata databaseExactly this is what I wanted to say....Till V2R6 it is not available, and am not sure about the later versions if they have something similar! :)Regards,Adeel
18727 Nov 2008 @ 01:26 PSTDatabaseReplyHow can we find dipendency in Teradata databaseHello,Till Teradata V2R6, no there is no such table. Though, you can always do that by parsing the definitions, but for that you must have good programming skills.Regards,Adeel
18627 Nov 2008 @ 12:29 PSTDatabaseReplySelecting multiple rows using Stored ProcHello,You need to put "DYNAMIC RESULT SETS " clause as well.Example (from manual):CREATE PROCEDURE Sample_p (INOUT c INTEGER)DYNAMIC RESULT SETS 2BEGINDECLARE cur1 CURSOR WITH RETURN ONLY FORSELEC...
18526 Nov 2008 @ 11:34 PSTDatabaseReplyNeed help in finding (Oracle dynamic Sql with using class) equivalent to TeradataHello,Well, for dynamic-sql in stored-procedures, you can use:CALL DBC.ExecSQL('your sql here');In your example, it will be translated to:CALL DBC.ExecSQL('INSERT dept VALUES (' || CAST(50 AS VARCH...
18426 Nov 2008 @ 11:23 PSTAnalyticsReplycast teradataHello,Is there any chance, that "$1" and "$2" are replaced with some values by UNIX (e.g. using shell script) before it is executed?Regards,Adeel
18324 Nov 2008 @ 04:52 PSTDatabaseReplySelect only when changing is occuredHello,Following may help you out:DROP TABLE Table1;CREATE VOLATILE TABLE Table1(Col1 VARCHAR(10), Col2 VARCHAR(10), Col3 DATE) ON COMMIT PRESERVE ROWS;INSERT Table1 VALUES('A', '001', '2008-10-10')...
18223 Nov 2008 @ 11:52 PSTTrainingReplyNew to TeraDataHello,Well, you can start by getting the demo version from following website:http://www.teradata.com/expressAnd, the manuals from following website:http://www.info.teradata.com/DataWarehouse/eTerad...
18123 Nov 2008 @ 11:45 PSTDatabaseReplyNeed Tutorials on Teradata SQLHello,As they say, practice makes a man perfect, this is what can be very useful. Additionally, for references you can find Teradata SQL manuals at:http://www.info.teradata.com/DataWarehouse/eTerad...
18023 Nov 2008 @ 11:43 PSTToolsReplytechnologiesHello,I have couple of questions, firstly, what exactly is the point behind posting same question 11 times? Please don't post any question more than once! Secondly, I couldn't find any "Technology"...
17920 Nov 2008 @ 06:26 PSTDatabaseReplyProblem while creating NUSIAnd one more suggestion, if you can use Teradata 12 Express, it supports more space than Teradata V2R5 Demo.You can download Teradata 12 Express from http://www.teradata.com/express.Regards,Adeel
17820 Nov 2008 @ 06:22 PSTDatabaseReplyProblem while creating NUSIHello,Try running following query and check the results then:For output in GBs:SELECT databasename , SUM ((((MaxPerm) / 1024) /1024) / 1024) AS Maximum_Space_GB , SUM ((((CurrentPerm) / 1024)...
17718 Nov 2008 @ 08:07 PSTDatabaseReplyExcution plan change when increase field(have example)Hello,Just a small suggestion, it is very good for "all" to state problem clearly and comprehensively; and using attachment feature where necessary!Best Regards,Adeel
17618 Nov 2008 @ 06:44 PSTDatabaseReplyDBQL - Database Query LoggingI couldn't understand your question completely, but what I did has the following answer:Following are the possible ways of getting the access to DBQL tables:- Any user can be "granted" a SELECT acc...
17518 Nov 2008 @ 06:36 PSTUDAReplyIs INSTR type function available in Teradata...UDF cannot be compiled using ODBC, try a BTEQ script in that zip file, offcourse, using bteq; and don't forget to change the database name.For example of SUBSTR and INDEX you can check following UR...
17418 Nov 2008 @ 04:37 PSTDatabaseReplyDBQL - Database Query LoggingHello,I seriously doubt, if it possible to change the DBQL tables. But offcourse, you need to implement some sort of archiving strategy for DBQL tables as per business requirements, otherwise some ...

Pages