#DateForumTypeThreadPost
2727 Nov 2009 @ 01:23 PSTDatabaseTopicComment string is longer than permittedHi,I have executed first the table scripts :CREATE TABLE cust_val_add_tax_rgstr ( asof_src_dt DATE NOT NULL, asof_src_tm TIME(0) NOT NULL, asof_trgt_dt DATE NOT NULL, asof_trgt_tm TIME(0) NOT ...
2607 Aug 2009 @ 06:51 PDTDatabaseTopicCAST TIME(0) to INTERVAL HOUR TO SECONDHi,Can you pleae help to CAST a TIME(0) data type to INTERVAL HOUR TO SECOND.Regards,Koushik
2526 May 2009 @ 12:46 PDTDatabaseTopicHierarchical Query - Help RequiredHi,I have a table in which I have parent_value and child_value columns. Now I want to display all the values in relation to parent-child. Means emp1 is manager of emp2 and emp1 is also manager of e...
2418 May 2009 @ 11:55 PDTDatabaseTopicCHAR-COMPRESS vs VARCHAR datatypeHi,I am trying to do a comparison between CHAR-COMPRESS and VARCHAR and I found the below information from Teradata Whitepaper.- VARCHAR will be more efficient when the difference of maximum and av...
2303 Feb 2009 @ 02:48 PSTDatabaseTopicRegarding LEAD (analytical function) function in TERADATAHi,Can you please let me know how the following functionality can be handeled in Teradata, as I haven't found that there is no LEAD function in teradata.SELECT last_name, hire_date, LEAD(hire_da...
2220 Jan 2009 @ 01:06 PSTDatabaseTopicPackage writing in teradataHi,Like stored procedure, can I write a package in teradata? If yes, can you please give me few examples, which can help me to write a package syntatically.
2103 Dec 2008 @ 06:23 PSTDatabaseReplyHow can we find dipendency in Teradata databaseHi,I want a AFTER trigger CREATION/UPDATION of any procedure.
2003 Dec 2008 @ 05:29 PSTDatabaseReplyHow can we find dipendency in Teradata databaseHi,Can we write any database trigger in Teradata which will log in a table the procedure name against those table names which are used in that procedure. Means proc1 a procedure uses two tables cal...
1903 Dec 2008 @ 01:18 PSTDatabaseTopicNested table in teradataHi,Can you please let me know that the concept of "nested table" is there in teradata V6. If it is not does it there can you please let me know that is it there in Teradata V12.
1827 Nov 2008 @ 02:04 PSTDatabaseReplyHow can we find dipendency in Teradata databaseHi,Can you please let me know what is the equivalent dictionary table/view in tearadata for user_source/all_source/dba_source of Oracle. Using which I can view the source data for procedure etc.
1727 Nov 2008 @ 01:42 PSTDatabaseReplyHow can we find dipendency in Teradata databaseThanks for your answer. Can you please let me know from which version of Teradata it is available.Regards,Koushik
1627 Nov 2008 @ 12:57 PSTDatabaseTopicHow can we find dipendency in Teradata databaseHi,Can you please let me know how can find out a particular teradata table is used in how many and which procedures.Actually in Oracle there is a dictionary table called "dipendency$" using which w...
1521 Nov 2008 @ 03:31 PSTDatabaseReplyRegarding Teradata MERGE statementHi,I am able to resolve the update part. The query should be like below :update fact_upsd_new from (select dt_key ,cust_name ,itm_cd_key ,itm_cd ,opr_cd ,opr_dsc ,chpst_ty...
1421 Nov 2008 @ 02:31 PSTDatabaseTopicRegarding Teradata MERGE statementHi,Can you please let me know that can I use merge statement in teradata version 06.02.0250?As I am not sure that merge statement is supported or not in that version of teradata, so I have used a s...
1309 Sep 2008 @ 09:16 PDTDatabaseTopicSaving Query output in a fileHi,I want to execute a query and want to save the output including column header in a xls file. i.e. something like colheader, spool etc. of Oracle.In the result set one of the column is large obje...
1212 Aug 2008 @ 02:45 PDTDatabaseTopicUser PROMPTHi,Can any one please let me know how user input can be taken in teradata?Example of which is &variable / :variable in Oracle. What is the equivalent of it in Teradata.Thanks in Advance,Koushik
1126 Jun 2008 @ 02:15 PDTUDATopicTeradata as active dataware house?Hi,Can teradata be considered as a active dataware house. If it is then what feature actully helps for ETL processing regularly & loading and as well as fetching reports.I am considering an active ...
1016 Jun 2008 @ 01:51 PDTDatabaseReplyFew basic queriesHi,In addition to the above queries can you please also let me know what is the basic difference between a macro and a procedure in teradata. What ever we are doing in a macro that we can do in a p...
916 Jun 2008 @ 01:43 PDTDatabaseReplyFew basic queriesHi,I think we can find out week no, month of the year etc from the view sys_calendar.calendar, like below:select * from sys_calendar.calendar where year_of_calendar=2008 order by calendar_datePleas...
810 Jun 2008 @ 05:40 PDTDatabaseReplyFew basic queriesHi,Can you please also let me know that is there any concept of static and dynamic dictionary tabes in Teradata.
710 Jun 2008 @ 12:40 PDTDatabaseReplyFew basic queriesHi,Can you please let me know what is equivalent statement for DBMS_OUTPUT.PUT_LINE in Teradata.
605 Jun 2008 @ 04:16 PDTDatabaseReplyFew basic queriesHi,I am looking for a front end application where in backend the database will be in Teradata. The front end application will be used to create/modify users for a new application etc. Actually I am...
503 Jun 2008 @ 07:54 PDTDatabaseReplyFew basic queriesThanks for your reply.If I want to take the month name as "MON" i.e. MAY - from a timestamp datatype, then how do I have to cast it.Similar questions if I want to take the week no/ quarter no/ year...
403 Jun 2008 @ 02:55 PDTDatabaseReplyFew basic queriesThanks for the reply.Is there any concept of TRUNC function in TEREDATA. Means is there any data type which hold data as well as time part in the same column, and if user want to extract only the d...
330 May 2008 @ 06:45 PDTDatabaseReplyFew basic queriescan you also please let me know the equivalent query for teredata :select empno,ename from emp start with empno=5126 connect by empno= prior mgr;The above query is valid in oracle.

Pages