#DateForumTypeThreadPost
1403 Jun 2016 @ 01:19 PDTTeradata ApplicationsReplyUnity Source LinkWhere do/can we find QueryGrid documentation? Lokking for it but (so far) it has alluded me;-( Thanks - JK  
1310 May 2011 @ 09:01 PDTDatabaseTopicDetecting a 'return status' from a CALL to a Stored Procedure (TD13)Is there a way to 'signal' to the calling environment (in this case BTEQ) the successful 'logical' execution of a Stored Procedure? e.g. in my particular case, I want to be able to let the calling ...
1214 Dec 2010 @ 09:10 PSTToolsReplyDual Load with TPT?? JK Update. We've tested the single pull/dual system load question presented above and it works fine. We've proved this primitive approach and now wish to expand it out down the road to support ...
1113 Dec 2010 @ 09:59 PSTToolsTopicDual Load with TPT?? Question: Is it possible to create a TPT 'job' that would allow us to extract data with one Producer (Export Operator) and load that single data set to two different Consumers (Load Operators) on t...
1001 Dec 2010 @ 12:53 PSTDatabaseTopicExecute Macro from Stored Procedure??? i know you can execute MAcros from within a Stored procedure. Looking in the SPL manual it says you can't execute the macro with EXECURE ...(); There is reference to DECLARE CURSOR (MACRO) form. ...
921 Sep 2010 @ 11:31 PDTDatabaseTopicRecompiling all Stored Procedures???I'm in the process of planning a migration form 2.6.2 to TD13.00. In the planning process I see that we need to recompile all the Stored Procedures, once migrated. I'd like to create a script todo ...
810 Aug 2010 @ 03:19 PDTDatabaseReplySpool treatment for DISTINCT versus GROUP BYDistinct and Group By diferences have not changed in a long time (at least up to 2.6.2). Basically, the more distinct the values are, the faster/better DISTINCT runs. When teh values are less 'uniq...
710 Aug 2010 @ 01:54 PDTUDAReplyHow can I get stats recommendation from Explain?Just a word of 'caution' about the results you get. Some of the 'recommendations' may not be appropriate. You still need to 'experiment' with the recommendations you get to see if they actually...
602 Jul 2010 @ 07:58 PDTDatabaseReplyIdentifying Status of CALL to Stored Proc?Thank you so much Dieter. So I guess the answer is, there is no way to do this until 'maybe' TD13 (we're on 6.2 at the moment but planning to go to 13. I owuld hat thought there owuld be some way t...
530 Jun 2010 @ 01:57 PDTDatabaseReplyIdentifying Status of CALL to Stored Proc?I know how to exit using labels - not a problem. What exactly is a 'user defined return code'? Do you mean an OUT parameter that you set with a value? Not a problem, but, how do I then test that fr...
429 Jun 2010 @ 11:01 PDTDatabaseTopicIdentifying Status of CALL to Stored Proc?When creating Stored Procedures, we’d like to be able to ‘logically abnormally terminate’ the Proc. - i.e. we do a query to a table and if a ‘logical’ condition exists (not an error ...
328 Jun 2010 @ 08:05 PDTDatabaseReplyTransaction Units across Multiple Thanks for the reply Jimm - much appreciated. I suspected it was that way and just wanted to confirm. However, I did not think about 'RETRY OFF in the BTEQ script. Thanks!
225 Jun 2010 @ 01:42 PDTDatabaseTopicTransaction Units across Multiple Commitment units are owned by a session - correct? As such, if I have a BTEQ script and want to execute several CALLS to SPL procs, can I wrap the calls with a BT/ET so that all the coalls are part...
102 Jun 2010 @ 10:11 PDTUDAReplyRaise Error and Return value with in a stored procedureThis is interesting and might be what I'm looking for - i.e. send a return code that I can identify from a calling BTEQ script. Question thought, is SYSLIB.RaiseSQLSTATE() a TD provided proc? If so...