Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: scarletAni
  • Content: Threads
  • Order by date
  1. scarletAni

    concatenate character column

    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...
  2. scarletAni

    ODBC Connectivity

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

    Object DEpendancy

    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
  4. scarletAni

    Print option in Queryman

    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...
  5. scarletAni

    User defined Error Messages

    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 ?
  6. scarletAni

    Error handling in Teradata Procedures

    I have the following procedure 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...
  7. scarletAni

    Wildcard characters

    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...
  8. scarletAni

    Collect Statistics and EXPLAIN

    On giving the EXPLAIN statement affter collecting statistics also , I get to see "no confidence" rows. How does Collect Statistics help ? And how does and EXPLAIN statement help to identify whether a collect statistics was done or not ?
  9. scarletAni

    double selection of max values in a table

    I have a table JUNK such as junk_id junk_chk_date junk_chk_nbr junk_itm_no I need to select the value of junk_itm_no base on max(junk_chk_date) and max(junk_chk_nbr) Eg: 1 A001 1999-10-03 012 2 A001 1999-10-05 011 3 B001 1999-07-04 010 4 B001 1999-07-08 009 I want the...

Part and Inventory Search

Back
Top