#DateForumTypeThreadPost
2522 Jul 2006 @ 06:06 PDTDatabaseReplyProblem with Recursive ViewCould you include the DDL for the recursive view?
2420 Jul 2006 @ 10:28 PDTDatabaseReply"Select Into" can't be used in teradata?SELECT INTO is supported in Teradata stored procedures. V2R5 and above.
2319 Jul 2006 @ 07:38 PDTDatabaseTopicrisk associated with dynamic sqlCan anyone relate any risks they have encountered using dynamic sql in Teradata stored procedures?Rumors that I have head (but have not seen any documentation on):a) it is policy to not grant perm ...
2210 Jul 2006 @ 01:24 PDTAnalyticsReplyIS-NUMERIC functionsthe UDF to_number function returns 7504 error if you pass it a non-numeric: "INVALID CHARACTER .. IN NUMBER STRING"
2127 Jun 2006 @ 12:27 PDTToolsReplyStored ProceduresAnother disadvantage is the inability of Teradata stored procedures to return a data-set. The typical approach to circumvent this limitation is to insert to a temporary table and then - while main...
2013 Jun 2006 @ 12:49 PDTTrainingReplywhat is wrong with prometric?I contacted the Teradata certification group regarding Prometric's web-site. Teradata informed me that Prometric is attempting to fix the web-site. I have not tried since last week so I don't kno...
1907 Jun 2006 @ 11:08 PDTDatabaseReplyFinding Foreign Key for Primary Key ColumnIf you are using V2R6 then this will identify all dependencies. Replace the literals with the db and table you want to trace all dependencies from. I had to use a staging table because the view db...
1801 Jun 2006 @ 12:16 PDTUDAReplyAll the GURU'S out theirIf your shop is using V2R6 you could try the WITH RECURSIVE clause to concatenate a column in an arbitrary number of rows into a single string. There is an example in this forum if you look at my ...
1701 Jun 2006 @ 12:12 PDTDatabaseReplyIs not [] supported by like pattern in TeraData?You are probably thinking of regular expressions which are not supported in Teradata. The only wild-card options you can use in the LIKE pattern match are % (any match of zero or more characters)...
1631 May 2006 @ 11:08 PDTTrainingTopicwhat is wrong with prometric?Has anybody had trouble registering on the prometric website? I have tried with both a PC and a MAC and with different browsers but am unable to submit the registration.Calling the help line gets ...
1531 May 2006 @ 10:25 PDTAnalyticsReplypartitioning results of queryYou can find a detailed introduction in "SQL Reference: Data Manipulation Statements" from the NCR website.
1430 May 2006 @ 05:15 PDTAnalyticsReplypartitioning results of query I'd venture to guess you will not need to "partition" your results once you tune the SQL. Suggest you run an EXPLAIN on the INSERT..SELECT and determine where the bottle-neck is in you SQL. This s...
1330 May 2006 @ 05:09 PDTTrainingReplyTactical queries vs analytical queriesAre you referring to strategic vs. tactical queries? If so you can read about them in the NCR manual: "Introduction to Teradata Warehouse, Teradata Database V2R6.0, Teradata Warehouse 8.0, B035-10...
1230 May 2006 @ 03:57 PDTDatabaseReplycan we run bteq script/stored procedure from mload?The error you are having with abort is simple - Don't prefix the ABORT with a dot "."There are two different ABORT commands. One is SQL based and works with any Teradata SQL interface. The other A...
1125 May 2006 @ 12:07 PDTDatabaseReplyCLOB in Stored Procedure is not workingMy bad - the SP is actually defined as shown, but still produces the error. Hopefully we will get the fix soon. ThanksREPLACE PROCEDURE brin_dev.clob_test(IN myclob CLOB)BEGINDECLARE myclob2 CLOB;...
1025 May 2006 @ 10:32 PDTDatabaseReplycan we run bteq script/stored procedure from mload?Here's one way - create a bteq step that runs first (before the mload):.logon....abort 'Error table exists - cannot continue'where 0 < (select count(*) from dbc.tables where tablename='ET_MY_TABLE...
925 May 2006 @ 10:12 PDTToolsReplyis it possible to display contents of a table through stored procedure?No you cannot do this (display the results), but you can create the table in the SP. I've heard V2R7 will have the ability to display the results but I don't know that for sure.The standard way to...
824 May 2006 @ 12:30 PDTToolsReplyCan we make a MLOAD script fail when the error tables are created?Try this - sets the RC to the max rc + uv + et + reject count .logoff &SYSUVCNT + &SYSRJCTCNT + &SYSETCNT + &SYSRC;
724 May 2006 @ 10:52 PDTDatabaseTopicCLOB in Stored Procedure is not workingAnyone run into this yet? I can't find any information on this. The documentation claims that CLOB is supported in SP.REPLACE PROCEDURE clob_test(IN myclob CLOB)BEGIN DECLARE myclob CLOB; EN...
624 May 2006 @ 10:30 PDTDatabaseReplyif statment in bteq?Q: Is there any way i can use a if statment in bteq.If so can anyone provide me with the syntaxA: Limited to test condition: ERRORCODE, ACTIVITYCOUNT and ERRORLEVELTests conditions you can use= (e...
523 May 2006 @ 11:35 PDTDatabaseReplyCan I catch an OUT variable(s) from a stored procedure?Unfortunately error handling with SP in Teradata is none too clean.You can display an OUT using SQL Assistant and in BTEQ. You can also use an OUT from another SP called within the SP. From SQL As...
418 May 2006 @ 12:44 PDTDatabaseReplyReverse string search (right to left)?Are you on V2R6? WITH RECURSIVE is only supported in V2R6.
318 May 2006 @ 10:29 PDTUDAReplySQL to retrieve datatype of a columnselect type(my_foo_col) from foobar group by 1;orselect distinct type(my_foo_col) from foobar;
217 May 2006 @ 06:29 PDTUDAReplyMload delimited file with delimiter embedded in fieldExample of MLOAD using pipe delimiters.LOGTABLE ML_FOO;.LOGON ......BEGIN IMPORT MLOAD SESSIONS 4 TABLES FOO WORKTABLES WT_FOO ERRORTABLES ET_FOO UV_FOO ERRLIMIT 100;.LAY...
117 May 2006 @ 02:22 PDTDatabaseReplyReverse string search (right to left)?This sql will search a string from left to right using recursive SQL. The output is the LAST section of the string where string is divided with the "_" character. You can probably modify it to sea...

Pages