#DateForumTypeThreadPost
807 Jun 2016 @ 06:11 PDTGeneralReplyHow to download and install teradata on windows 10You can install Teradata on Windows 10. First you install VMWare Player (free for non commercial use), then download the virtual machine from Teradata and open it in VMWare Player. This will give y...
704 Mar 2016 @ 01:13 PSTDatabaseReplyQuery to remove some characters from a columnHi, You can replace %[ with OReplace, but you will need to use a regular expression in conjunction with REGEXP_REPLACE to remove the ]Q1_1%. Here is the code to handle the example ...
628 Oct 2015 @ 08:20 PDTDatabaseReplyOREPLACE Hi Shivyani, You can escape single quotes by doubling them up, ie if you want a single quote literal within a string just use ''. So in your example: SEL '''a'',...
528 Oct 2015 @ 07:14 PDTDatabaseReplyRANK() Tiebreaker?Hi Eady, You could include MAX(LOC_VST_DT) in the subquery, and then include it in ORDER BY clause when RANKing. SEL T1.PERIOD_START, T1.PERIOD_END, T1.EMPID, T1.LOCID, RANK() OVER (P...
412 Oct 2015 @ 01:48 PDTDatabaseReplyLOG file for Stored Procedure in Teradata. Hi Lata, There is a status variable ACTIVITY_COUNT that stores the number of rows impacted by the previous DML statement in the procedure. Regards, Steve.
330 Sep 2015 @ 02:15 PDTDatabaseReplyWhen does the value in a stored procedure variable change?No problem JoyC. If you can't persuade your DBA to grant you CREATE PROCEDURE privileges then Teradata also has a free edition -  Teradata Express for VMware - which you could install on y...
230 Sep 2015 @ 01:29 PDTDatabaseReplyWhen does the value in a stored procedure variable change?Hi JoyC, The last statement will return ABC because nowhere has the code changed the value of vFld1 from the first SELECT. This can be easily verified by creating a simple stored procedure to tes...
116 Sep 2015 @ 12:19 PDTDatabaseReplyStored procedure runs in SQL assistant but given error when triggered through InformaticaHi Arpit,   This sounds like Informatica is adding additional single quotes around the value when it is calling the stored procedure - so effectively generating: CALL MDM_D1.SRC_VNDR_FNDT...