Search results for query: *

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 &quot;a&quot; is visible to only &quot;b&quot; 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...

Your select statement in the procedure should be something like : select count(*) into :x from t1;

yes, you can use it as a input for fastload or multiload

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