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!

  • Congratulations strongm 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: SL23
  • Order by date
  1. SL23

    what do this evaluate in Java script?

    What do these evaluate to in Javascript? 2+5+"8" = "1"+2+4 = Is any one know this answer? please help!
  2. SL23

    create 1000 tables using script

    Thanks a lot, sorry I was so busy and did not get a chance to thank you! thanks I tried with some modification in the sql and it worked... thanks a lot!
  3. SL23

    create 1000 tables using script

    I want to create 1000 tables using one script. Sam set of tables but the table name and the pk should be incremented, Is there a way to do this in teradata... CREATE SET TABLE s.at1 ( student_number INTEGER NOT NULL, f_name VARCHAR(30) CHARACTER SET LATIN NOT...
  4. SL23

    Procedure Please very urgent

    Hi this is very urgent Please give me the solution as early as possible please. I have a table in oracle when it goes to teradata it should carry 4 additional columns for each table to carry on the versioning: eff_strt_tsp TIMESTAMP(6), eff_end_tsp TIMESTAMP(6)...
  5. SL23

    how to insert a text file or a picture in a cloumn

    I HAVE REPLICATED A CLOB VALUES FROM ORACLE TO TERADATA TABLE. IS ANY ONE KNOW HOW TO RETRIVE THE DATA IN TERADATA. AND THE TABLE IS LOOKS LIKE THIS: CREATE SET TABLE DEV.t1 ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( USR_ID DECIMAL(18,4)...
  6. SL23

    how to insert a text file or a picture in a cloumn

    I have a table in teradata and want to insert a text file in one of the column. How could I do this in teradata? Any help please.
  7. SL23

    Connection Reset By peer

    I was trying to connect to the teradata box, always getting this error. I have bounced the server. still getting the same error. There are two process are keep going down and not connecting at all. Please let me know if you have any idea... thanks!
  8. SL23

    LOCKS in teradata

    If two queries running against one table, one is inserts and another one updates. The tables keep locking and says there is a deadlock. How can we check this in teradata. I cannot use multitool, is that any other option.
  9. SL23

    Teradata question insert

    Question: I am using two table to populate odd numbers(tbl1) and even numbers (tbl2). and loading the data in to tbl3. I want to run both the queries at the same time. When start the two queries, it is not populating the data. If I run one query it loads data. Is that any way I can run both...
  10. SL23

    Teradata question insert

    IT WORKS PERFACT, TDATGOD THANKS!
  11. SL23

    Teradata question insert

    In oracle the table valuse looks like this: "1","FirstName","LastName","Major","55000","05/31/2006" "2","FirstName","LastName","Major","55000","05/31/2006" "3","FirstName","LastName","Major","55000","05/31/2006" "4","FirstName","LastName","Major","55000","05/31/2006"...
  12. SL23

    Teradata question insert

    Hi, I have this script in oracle, begin for i in 1..100000 loop INSERT INTO STUDENT VALUES (i,'FirstName','LastName','Major' ,55000,'2006-06-05'); commit; end loop; end; Can some one help me to write this in teradata. the table is create table student , no fallback , no before...

Part and Inventory Search

Back
Top