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!
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...
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)...
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)...
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!
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.
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...
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"...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.