Recent content by scarletAni

Hi!! The material that NCR offers is enough for the certification. I have taken the Basics and the SQL specialist. At that time my company had the license. But it got expired 3 months back :( You need to know everything thats there in the course for the certification. Ani.

Roger, How have you arrived at 6 joins ? Is it because There are 6 'A' entries ? In that case if we are not sure of hte number of entries for each id 'A', 'B' etc, then how do we arrive at the number of joins ?

I have a table with values 1 the 1 value 1 is 1 one 2 the 2 value 2 two I need the output as 1 The value is one 2 the value two as in the character column containig some description needs to be concatenated. Its if it were an integer, then we can do a SUM and group by. Since its a...

What is the odbc driver to connect to Teradata from .NET ?

SHOW <SQL> works for a single SQL stmt only... For Ex : SHOW SELECT * FROM TableA; SELECT * FROM TableB; Gives only TableA defenition... Thats too much information for me... I just need to know the Table names that a procedure uses. SHOW CALL ... Doesn't work !! Thanx for that info...

Is there any data dictionary table that will let us know Procedure Name : what objects (views/ tables ) the procedure depends on ? Is there a system table that will give this info ? Need to know this urgently.... Thanx, Ani

Thans for all those inputs !! Yeah !! Waiting for a debugger for SPs...

I want to print some results in a procedure and check for the correctness of values... REPLACE Procedure A.proc1 (OUT dt1 varchar(10), OUT dt2 Varchar(18)) Begin DECLARE maxdttm_crfh char(18); DECLARE maxdttm_dsth char(18); call A.pr_get_next_asof( 'Temp1', 'Depnd1', :maxdt_dsth...

Since the distribution of datais on the Primary Index, the join on Sec Index will cause the spool to be created. May be you can create global temp table with the sec Index columns are the Primary Index and then try to join.

So, ABORT may not work for me. I must try ROLLBACK. How do I check the SQLCODE value once the procedure is complete ?

Also how can we check the value 3513 has been assigned to SQLCODE ?

Can we use ABORT 'Error Occurred'. Will it shange the value of SQLCODE ?

Hi !! Is there any way of raising a user defined exception in Teradata ? I need one and am not able to find relevant material. Can someone help ?

Dieter, If I use sql_cd it works and exits correctly. This is because of the LEAVE statement within the IF block. Wanted to know more about how the Error handling actually works.

You may not be able to use SELECT name ,phone ,blah1 ,blah2 ,transaction ,blah3 ,blah4 ,CSUM(1,1) AS trs_seq FROM table1 ,table2 ,table3 ,table4 WHERE state =...