#DateForumTypeThreadPost
4106 Sep 2016 @ 03:14 PDTDatabaseTopicHow to return the result of a select query in a function Hello to everybody, I'm trying to return the result of a select query in a function. Something like: REPLACE FUNCTION F_SIGUIPUNTERO_F (nPunt number, nLimite number) RETURNS int LA...
4002 Sep 2016 @ 01:09 PDTDatabaseReplyI can't execute an SP that calls another SP inside Thanks a lot! It has worked! GRANT EXECUTE PROCEDURE ON novaquality TO novaquality; I never thought I would have to give permissions to the database to execute its own procedures.....
3901 Sep 2016 @ 04:05 PDTDatabaseTopicI can't execute an SP that calls another SP inside Hello, I'm trying to execute a procedure (F_SEPARA_LETRAS_Y_NUMEROS) with another procedure called inside (F_QUITA_REPES) but I get the following error: CALL Failed. [3523] F_NOT...
3830 Aug 2016 @ 04:57 PDTDatabaseTopicRemote desktop to TD Express 15.10 Virtual Machine is not workingHello, I'm using the TD Express 15.10 Virtual Machine but I've discovered that UltraVNC is not woking for doing a remote desktop from Windows. Could anyone tell me how to fix it? Th...
3730 Aug 2016 @ 04:50 PDTDatabaseReplyTeradata: No more room in journal table for novaquality.journalsOk, Thanks!
3626 Aug 2016 @ 06:07 PDTDatabaseTopicTeradata: No more room in journal table for novaquality.journals Hello,   When I tried to insert more than a million of rows in a table, I got the following error: No more room in journal table for novaquality.journals I have a...
3525 Aug 2016 @ 04:03 PDTDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GBThanks! I downloaded and installed the Teradata Express 15.10 VM and It seems to be possible to install SAP DS here :) But on the other hand, I've fount that UltraVNC (to make a remote deskto...
3423 Aug 2016 @ 05:22 PDTTeradata Database on VMWareTopicUltraVNC is not working in Teradata Express 15.10Hello, I can't make UltraVNC work in the TD Express 15.10 Virtual Machine to make a remote desktop connection from Windows. It's strange because in the TD Express 15.00 it worked fine, bu...
3322 Jul 2016 @ 04:32 PDTDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GB In the end, I'll probably have to change to a Teradata Express 15.10... Is there a Teradata Express 15.10 available to download where SAP DS (the Server side) can work? And, if that...
3221 Jul 2016 @ 07:19 PDTDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GB Hello again, Thanks for the answers but, apparently, SAP DS works in Linux too. In fact, I have the software for the installation. I've read that the Product Availability Matrix post...
3121 Jul 2016 @ 05:25 PDTDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GB Hello again, When I execute the first commands, at Run an Online Update, it seems to do nothing: TDExpress15.00.02_Sles11:/ # zypper ref -s All services have been refre...
3021 Jul 2016 @ 03:51 PDTDatabaseTopicProblems installing in TDExpress15.00.02_Sles11_40GB Hello everybody, I downloaded the Teradata Express 15.00.02 for VMware Player from the website and I'm trying to install SAP Data Services but I receive the following error: Fail...
2918 Feb 2016 @ 02:08 PSTDatabaseReplyHow to create a function similar to Oracle (or a procedure with a return value)? Ok Dieter, thanks again! Anyway, that already was enough for me. But also, I wanted to add some reflexion... The fact that TRIM's and REGEXP's are living together in the same functio...
2817 Feb 2016 @ 09:05 PSTDatabaseReplyHow to create a function similar to Oracle (or a procedure with a return value)? That way can generates some conflict if the character in delchar is a number, "n", "\n", "t" or "\t", for example. I guess it's quite difficult to mak...
2717 Feb 2016 @ 06:55 PSTDatabaseReplyHow to create a function similar to Oracle (or a procedure with a return value)?Haha, that's true... I'm included sometimes ;) As a curiosity, in the function you made, I've found a character that I can't introduce for delchar: the question mark as a literal. ...
2617 Feb 2016 @ 06:26 PSTDatabaseReplyHow to create a function similar to Oracle (or a procedure with a return value)?Ah ok! I didn't look at it well before. Sorry! Just to finish about this issue, in case I needed... Is there a way to do an intermediat step in a Teradata function, like declaring an auxiliar ...
2517 Feb 2016 @ 05:55 PSTDatabaseReplyHow to make an anonymous piece of code to execute it once?Ok, I'll have a look at the manual! And well, respecting to cSubCad, also, I can just convert it to an INOUT parameter... Both alternatives can be fine for me :) Thanks!
2417 Feb 2016 @ 05:49 PSTDatabaseReplyHow to create a function similar to Oracle (or a procedure with a return value)? Ok, thanks again Dieter! By the way, the function you made has only one part of the code I exposed before, the first IF-THEN-ELSE, but not the second IF with the WHILE inside. According ...
2317 Feb 2016 @ 04:57 PSTDatabaseReplyHow to make an anonymous piece of code to execute it once? Thanks Dieter and Carlos! Dieter, I'm calling it standalone... I guess it fails, as Carlos said, because it's an INOUT parameter and not just an OUT parameter. Altho giving it a ...
2217 Feb 2016 @ 03:06 PSTDatabaseReplyHow to make an anonymous piece of code to execute it once?I've tried with a procedure I've just created and that doesn't work: CALL F_QUITA_REPES(' Hola amigos qué tal? ', ' ', Resul); I obtain the error mess...
2117 Feb 2016 @ 02:59 PSTDatabaseReplyHow to create a function similar to Oracle (or a procedure with a return value)? Ok Dieter, thanks for the information! Anyway, I have functions more complex than that in Oracle to translate (and also, sometimes is easier just to try a translation of code and not a big c...
2017 Feb 2016 @ 02:07 PSTDatabaseTopicHow to make an anonymous piece of code to execute it once? Hello everybody, I would like to know how to make a piece of code like an stored procedure, but just for one execution. For example, if I already have a stored procedure with a header li...
1916 Feb 2016 @ 09:20 PSTDatabaseTopicHow to create a function similar to Oracle (or a procedure with a return value)? How to create a function similar to Oracle (or a procedure with a return value)? Hello everyone, Functions defined by the user in Teradatab seem to be quite different to the concept lear...
1816 Feb 2016 @ 08:58 PSTDatabaseReplyQuestion about "regexp_replace"Ok, thanks!
1716 Feb 2016 @ 08:56 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language?Thanks for all the given information, Carlos and Dieter. It will be usseful for me. Best regards

Pages