#DateForumTypeThreadPost
1611 Feb 2016 @ 03:54 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language? But, is there a way with this VARRAY data type in Teradata to do things like the following in a simple way?: MY_ARRAY(2) = 5 MY_ARRAY(2) = MY_ARRAY(3) Because with Oracle you...
1511 Feb 2016 @ 12:17 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language? Hello again, I've been reading in the web "http://www.info.teradata.com/" the next short article: http://www.info.teradata.com/htmlpubs/db_ttu_14_00/index.html#page/SQL...
1410 Feb 2016 @ 05:17 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language? Ok. At the moment, supposedly, I can do whatever I need, so I've just redefined the head of the procedure adding "SQL SECURITY CREATOR" and now it works! As a last test, I'...
1310 Feb 2016 @ 01:24 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language? I think that is a good idea and it could work for me :) I've executed your procedure "testproc" and the message of table not existing comes as an error, so I can't create t...
1209 Feb 2016 @ 04:45 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language? Yes, I want to use it in loops... and try to maintain the estrcuture of the original Oracle code as much as possible. I'm using arrays: As "in" and "out" para...
1108 Feb 2016 @ 10:04 PSTDatabaseReplyQuestion about "regexp_replace" Deiter, you are a genius! I had been looking for it for a long while... and I just needed a "?". Thanks! I know that I could use REGEXP_SUBSTR, but sometimes, I need to get a subex...
1008 Feb 2016 @ 09:07 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language? Thanks for your quick reply. I haven't used cursors in Oracle yet, but maybe I'll do it in Teradata, so it's good to know. After giving the privileges, now I can define an instan...
908 Feb 2016 @ 07:21 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language? Sorry but, because of the way the procedures are already done in Oracle PL-SQL, I think i'll have to continue with the idea of ussing arrays, due to that's the most direct and easy way t...
808 Feb 2016 @ 05:03 PSTDatabaseReplyAlternative to Oracle's packagesOk. Thanks for the answer!
708 Feb 2016 @ 04:57 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language?Thanks for the answer. About what I wrote on my post, I have to say that the type "SYSUDTLIB.array_strings" is one that I created myself, it doesn't exist by default, sorry...
608 Feb 2016 @ 12:24 PSTDatabaseReplyQuestion about "regexp_replace"Thanks yuvaevergreen, but the thing is that I don't know if I'll have two "(A[0-9])" expressions... I could have 3, 4... or just 1. I wonder why I have to say explicitl...
505 Feb 2016 @ 04:14 PSTDatabaseTopicAlternative to Oracle's packages Hello to everybody, I'm starting to carry out a migration from Oracle PL-SQL to Teradata Stored Procedure Language and I can't find how to declare my own packages. I've alrea...
405 Feb 2016 @ 03:58 PSTDatabaseTopicHow to define an array of varchars in Stored Procedure Language? Hello to everybody, I'm studying a migration from Oracle PL-SQL to Teradata Stored Procedure Language and I'm having problems trying to find a way to declare an array of varchars ins...
305 Feb 2016 @ 02:15 PSTDatabaseTopicQuestion about "regexp_replace"Hello to everyone, When I execute this sentence: select REGEXP_REPLACE('XXX A1 A2 XXX', '.*( )(A[0-9]).*', '\2', 1, 1, 'i'); I get the second "...
205 Feb 2016 @ 01:45 PSTDatabaseReplyEquivalent sentence in Teradata for the Oracle "CONVERT"?Thanks for the answers. David, I think you didn't understand what I want to do. I have a text parser in Oracle that clean and translate arrays of characters, and I want to get the same in T...
104 Feb 2016 @ 07:53 PSTDatabaseTopicEquivalent sentence in Teradata for the Oracle "CONVERT"?Hello everybody, I can't find a sentence to make the same as "CONVERT" does in Oracle. For example: select CONVERT('José se comprò un camiôn', ...

Pages