#DateForumTypeThreadPost
3012 Jan 2015 @ 02:48 PSTGeneralReply6706: The string contains an untranslatable characterHi,   Please share sample data of "DB.TABLE".   Thanks, Rohan Sawant
2910 Jan 2015 @ 05:40 PSTDatabaseReplyHow to create a loopHi Johnsnow, In case you have more than one entry for a particular week you could modify Dieter's query as follows:   ----Creating test data CREATE MULTISET VOLATILE TABLE VT_TEST...
2809 Jan 2015 @ 05:25 PSTAnalyticsReplySyntax error due to Stored Proc ParameterHi Zkuza,   Can you please share some data of the source table Tbl1 with the table structure?   Thanks, Rohan Sawant
2709 Jan 2015 @ 05:07 PSTDatabaseReplyAdding a date filterHi Saranya Karthi, The following query will do the required: CREATE MULTISET VOLATILE TABLE TESTTABLE ( WEEKENDINGDATE DATE ) ON COMMIT PRESERVE ROWS; INSERT INTO TESTTABLE SELECT ...
2609 Jan 2015 @ 04:25 PSTDatabaseReplyVariable results from an sql statementHi Raja, I answered your query in previous post http://forums.teradata.com/forum/database/error-while-executing-a-dynamic-sql-in-teradata-stored-procedure-0#comment-138854
2509 Jan 2015 @ 04:24 PSTDatabaseReplyFind position of first non-digit or space from the backHi Eric_td, The below query would do the required CREATE MULTISET VOLATILE TABLE VT_TEST ( TXT VARCHAR(30) ) ON COMMIT PRESERVE ROWS; INSERT INTO VT_TEST ('abc def 234'); ...
2409 Jan 2015 @ 04:18 PSTDatabaseReplyReverse string search (right to left)?Hi Eric_td, The below query would do the required CREATE MULTISET VOLATILE TABLE VT_TEST ( TXT VARCHAR(30) ) ON COMMIT PRESERVE ROWS; INSERT INTO VT_TEST ('abc def 234'); INS...
2309 Jan 2015 @ 03:22 PSTDatabaseReplyError while Executing a Dynamic SQL in Teradata Stored ProcedureHi Raja M,   Please refer the below link: http://forums.teradata.com/forum/database/error-while-executing-a-dynamic-sql-in-teradata-stored-procedure-0#comment-138854   Thanks, Rohan...
2209 Jan 2015 @ 03:20 PSTDatabaseReplyError while Executing a Dynamic SQL in Teradata Stored ProcedureHi Raja M, I am not still not clear about what you want to achieve through this procedure. But as far as the error is concerned set my_sql ='select count(*) into v_COUNT from t3_rita....
2109 Jan 2015 @ 02:43 PSTDatabaseReplyQuery to Filter latest 1 year dataHi SarranyaNithya, The following query will do the required: SELECT A.* FROM TESTTABLE A , (SELECT MAX(WEEKDATE) AS MAX_WEEKDATE FROM TESTTABLE) B WHERE WEEKDATE BETWEEN ADD_MONTH...
2024 Dec 2014 @ 04:00 PSTDatabaseReplySomething ) Expected Between DESC and RESET Hi AmarnathG,   Hope the below query helps. You could try and shorten the same. I have just given it a try.   SELECT COL1 , COL2 , MAX(COL3_TEST) OVER (PARTITION ...
1922 Dec 2014 @ 10:12 PSTDatabaseReplyHow to store output of show table in a variable in Stored procedure @Dieter,   I understand that RequestTest column of dbc.TablesV truncates the definition. But if you check the query which I had provided in my earlier post doesnt use dbc.TablesV. T...
1822 Dec 2014 @ 01:52 PSTDatabaseReplySelect Access Error in Procedure Hi,   Can you share what is stored in "V_QUERY_STMT"?   Thanks, Rohan Sawant
1722 Dec 2014 @ 01:39 PSTDatabaseReplySelect Access Error in Procedure Hi,   Try granting "PRD_RS_Hst" SELECT access to prd_DB.Prd_tbl. i am quite sure your error will be solved.   Thanks, Rohan Sawant
1622 Dec 2014 @ 01:07 PSTDatabaseReplyHow to store output of show table in a variable in Stored procedureHi teradatauser2, The sql which i shared above give you the whole table table defination. You just need to concatenate them. Please check. Thanks, Rohan Sawant.
1522 Dec 2014 @ 01:06 PSTDatabaseReplySelect Access Error in Procedure Hi Sandeep Yadav, Can you please tell the database in which the procedure is compiled? Thanks, Rohan Sawant
1420 Dec 2014 @ 12:23 PSTDatabaseReplycreate a composite Collect stats command Hi,   Can you please share your table "MENSA_TABLE.TACCOUNT_HIST INDEX " DDL so that I could map your requirement with DDL. I thought you just want to know how to combine ...
1320 Dec 2014 @ 12:19 PSTDatabaseReplyHow to store output of show table in a variable in Stored procedureHi teradatauser2, The following query would help you to do the required. But it depends on total size (DDL size) of table. You can merge the datarows and get your table definition. Try using a rec...
1219 Dec 2014 @ 02:56 PSTDatabaseReplySQL to TERADATA MigrationHi Sherin, If you are talking about raising errors in TD objects as such for particular situation could be seen only in STORED PROCEDURES. We specially handle errors in STORED PROCEDURES by using ...
1119 Dec 2014 @ 01:07 PSTDatabaseReplycreate a composite Collect stats commandHi v_gabrielli, The following recursive query will do the task. Enter your filter. If your tables have keywords as columns use "SYSLIB.SQLRESTRICTEDWORDS" and put " around keyw...
1018 Dec 2014 @ 04:58 PSTDatabaseReplyDynamic Date Range in where clause Hi Vinay,   As per the query you pasted here the data will be pulled (I am quite sure on this. I suppose you ran both queries on different days). As per the time perspective,var...
918 Dec 2014 @ 02:49 PSTGeneralReplyHelp in writing SQLHi Rajesh, I have created the above scenario and made a recursive query to achieve the above.   CREATE MULTISET VOLATILE TABLE VT_ZONE_CITIES ( "ZONE" VARCHAR(10) , CIT...
818 Dec 2014 @ 12:34 PSTGeneralReplyDynamic Date Range in where clause Hi Vinaynaran,   I have already posted the same reply in your previous post: The above solution provided by Dieter is for TD 14 release I suppose. In case you ne...
717 Dec 2014 @ 09:53 PSTToolsReplyTERADATA PROFILER QUERIESHi Raja_KT, I could see the SQL's in SQL tab but I just want the standard queries used in Profiler. I wanted to understand the standard ways in which a Profiler does profiling of data. If some...
617 Dec 2014 @ 05:20 PSTToolsTopicTERADATA PROFILER QUERIESHi All, Can anyone please help me out in extracting the Teradata Profiler queries? I would like to know what kind of queries does the Teradata Profiler make in detail if possible

Pages