Its simple - Byte(8):
sel type(rowid) from dbcinfotbl;
*** Query completed. 2 rows found. One column returned.
*** Total elapsed time was 1 second.
Type(ROWID)
---------------------------------------
BYTE(8)
BYTE(8)
I don't think there is any way to speed up the insert process when there are foreign keys since the database has to validate every child row before doing the actual insertion. The other way would be to populate the tables first and then create the foreign keys. This may be a bit faster.
select a.dept,a.emp from ((select Distinct 1,2,3 from (select 1,2,3,4,5 from dept) as a) as b;
In the above query, derived table "a" is visible to only "b" not to the main level. So, your query should look like
select b.dept, <<---
b.emp <<---
from ((select...
You can use the fastexport script to generate the corresponding multiload script..here is how to do it ..
.logtable mylog;
.logon mytd/usr1,usr1
.begin export
sessions 4;
.export outfile out.dat
format fastload
mode record;
mlscript script.mdl;
sel * from t1;
.end export;
.logoff;
The above...
Hi smitakale,
You need to check two more things here ..the single sign on feature should be enabled in dbscontrol and also in gtwcontrol.
Go to Teradata Command prompt :
Say - gtwcontrol -d
You will see something like this :
d:\ncr\tdat>gtwcontrol -d
gdo version: 5, created on Thu Oct 18...
This is very simple - You can directly subtract two dates in Teradata like below ..
sel max(d1), min(d1), max(d1)-min(d1) from dt;
*** Query completed. One row found. 3 columns returned.
*** Total elapsed time was 1 second.
Maximum(d1) Minimum(d1) (Maximum(d1)-Minimum(d1))
-----------...
Currently, Teradata doesn't support the embedded queries at column level - only derived tables are supported. I guess, you need to rewrite your queries..
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.