#DateForumTypeThreadPost
1914 Sep 2015 @ 12:33 PDTDatabaseTopicQueryGrid: Teradata - BigInsightsHi - Our Platform Setup is like this: Teradata 15.00 and IBM BigInsights Flavor of Hadoop Implementation. We are trying to explore the option of implementing TD Query Grid to connect to Data in Big...
1821 May 2015 @ 09:49 PDTDatabaseTopicTDWM in Active-Active ScenarioHi - We have a Active-active setup and are looking for options in case of a failover. I wasnt sure where to start, can experts help me with suggestions please?     Thanks,
1721 Oct 2013 @ 09:59 PDTDatabaseReply3706 Error Executing a ProcedureCan anyone Help me get this resolved Please.
1618 Oct 2013 @ 12:34 PDTDatabaseTopic3706 Error Executing a Procedure REPLACE  PROCEDURE Dev_DB.CollectStats_New( IN in_db_name VARCHAR(64), IN in_table_name VARCHAR(255), OUT Ret_Code  VARCHAR(200)) CollectStats: BEGIN DECLARE  Actvty_F...
1509 Oct 2013 @ 11:58 PDTDatabaseReplyConvert Teradata Mode Procedure to ANSI ModeI Changed my ODBC Connection to use 'ANSI' instead of 'System Default' and it worked fine, Thanks for all Help.
1409 Oct 2013 @ 08:22 PDTDatabaseTopicConvert Teradata Mode Procedure to ANSI ModeHi - I have Created it using SQL Assistant but getting error that ..'the proc. is in Teradta Mode' for some other user who was trying to execute it.  After Changing View--> ANSI...
1327 Sep 2013 @ 02:37 PDTDatabaseTopicIssue when Creating a AJI Hello All -   In my scenario we are thinking of creating multi-level views on top of some 10 - 15 tables altogether for business to query the views as needed. The moment we get to 2...
1214 Jun 2012 @ 08:20 PDTDatabaseReplyEquivalent of TSQL RAND Function in Teradata Hi - The Result of it changes all the time. SEL cast(random(0,1000000000) as decimal(20,10))/1000000000;   Result1: 0.9268257100 Result2: 0.8241862190 etc...., My need ...
1112 Jun 2012 @ 01:44 PDTDatabaseTopicEquivalent of TSQL RAND Function in Teradata Hi Friends - In TSQL RAND function returns a decimal value between 0 and 1 and for a given value the result obtained is always same. I Mean SELECT RAND(9) would always return 0.7137410569829...
1012 Jun 2012 @ 01:37 PDTDatabaseReplyUse Return Value of a Procedure in another Procedure Hi - I found a solution for this, thought it would help someone:   CREATE  PROCEDURE SP2(ID INTEGER)  DYNAMIC RESULT SETS 1  MAIN:BEGIN -- Main BEGINS Here &nbs...
905 Jun 2012 @ 07:02 PDTDatabaseTopicUse Return Value of a Procedure in another Procedure Hi - I am working on converting TSQL Procedues into TD and need to call a SP [say SP2] from SP1 and in SP1 use the results obtained from SP2. Tried couple of things and lastly this as below: ...
824 May 2012 @ 02:04 PDTDatabaseReplyRetrieving Data based on a hashrow generated value Hi Dieter - You are right. But i couldnt think of any other way of generating an ID based on couple of fields which represents the same value all-the-time. Please share your thoughts with a smal...
724 May 2012 @ 09:13 PDTDatabaseReplyIssue with DAYOFWEEK in a Teradata Procedure Thanks Carlos, it worked for me.
624 May 2012 @ 09:05 PDTDatabaseReplyRetrieving Data based on a hashrow generated value Thanks Angellore, it worked as expected, i tried 'xb' but used the exact value to search including the '-' hence didnt work. Now that u say that its a bad idea to g...
523 May 2012 @ 05:48 PDTDatabaseTopicRetrieving Data based on a hashrow generated value Hi - We have created a Table where CUST_ADDR_ID is a hashrow (combination of few columns) as shown below. Now we would like to query data based on that value but having trouble, Can someone plea...
423 May 2012 @ 03:30 PDTDatabaseTopicIssue with DAYOFWEEK in a Teradata Procedure Hi - We have a table which has 3 columns pattern, tdquery and pattern_value. for example (LastCalanderDayofNextMonth)- LCDOFNM_MMDD          ...
317 Jan 2012 @ 11:35 PSTGeneralReplyGet returnCode of Mload from Shell Script BTW - Mload is getting invoked fine and the load is also working fine...only the returncode issue remains.
217 Jan 2012 @ 11:34 PSTGeneralTopicGet returnCode of Mload from Shell Script Hello All - I have a shell script which reads all files [a given pattern] in a directory and then invokes mload like below to load these files. returnCode=`mload < PostCampaigns.mload` ...
108 Nov 2011 @ 04:12 PSTDatabaseTopicStored Procedure Behaving Differently when run multiple times Hi - I have two stored procedures, P1 which doesnt return returnCode as OUT and P2 with returncode as OUT paramter. P1 works as-expected on multiple runs b ut P2 behaves differently when ru...