Search results for query: *

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.

...SELECT CSUM(1,1) as cntr, <columns> FROM Table1 JOIN Table2 JOIN Table3 Now do a selectfrom the GTT_somtable using either MIN or MAX SELECT * FROM GTT_someTable t1 where cntr = (select MAX(cntr) from GTT_sometable t2 where t1.firstname = t2.firstname and t1.lastname = t2.lastname) This...

...and want to introduce error handling. Replace procedure appl_distrib_chnl_drv_01.pr_junk(OUT msg_txt VARCHAR(100)) lbl_sls_out_dtl : begin /* Variables for detecting SQL errors */ DECLARE sql_cd INTEGER; DECLARE sql_st CHAR(5); /* Declare continue on to next statement SQL standard error...

CVenom , In your case, I have to do the same for each character in the column. ie. SUBSTR(col from 1 for 1), then SUBSTR(col from 2 for 1) etc for each char. This may be tedious. Roger, This CAST(col as integer) still gives me a BAD character or format error.

When I use CAST to convert into an integer , I get the following error : 621: Bad character in format or data of <tablename> I want to know if there is anything like a IsNumeric() or some wildcard pattern against which we can check.

Hi !! I have a table with a character column Eg : Junk_tbl junk_id char(20) junk_acct_no char(20) I want to select only those rows which have all integer values in junk_acct_no. i.e junk_acct_no will contain values such as AA1234 123456 V56765 453533 I want the result to...

It works !! I had tried using the max . There is a small correction to the above data. Consider this data 1 A001 1999-10-03 012 1 A001 1999-10-05 011 1 B001 1999-07-04 010 1 B001 1999-07-08 009 2 A001 1999-10-03 012 2 A001 1999-10-05...