#DateForumTypeThreadPost
28004 Oct 2007 @ 02:11 PDTUDAReplyDifference and concepts of ETL.Teradata has it's own version of stored procedure language, there are variations in syntax with oracle, but it's not that hard to grasp, and it's not as sophisticated as Oracle PL/SQL.Starting TD 1...
27904 Oct 2007 @ 01:36 PDTUDAReplyFastloadIt's a bteq feature, can't use in fastload.In fact it would be good design not to put any DDL operations in fastload, better put in a bteq script.That way your fastload script would be restartable ...
27825 Sep 2007 @ 11:03 PDTConnectivityReplySQL using JDBC driverIdeally there shouldn't be, could you be more specific about your issue... like SQL you were trying, the API call used (code snippet ?)... any error code / message etc ...
27724 Sep 2007 @ 01:11 PDTDatabaseReplyAge CalculationSELECT DT1, DT2, DT2-DT1 YEARFROM MYTABLE;
27620 Sep 2007 @ 04:24 PDTDatabaseReplyQuerying table stats from dbc tablesDieter made some SQLs for this .... check if it would suffice your requirement.You can find it here http://www.teradataforum.com/attach.htm
27518 Sep 2007 @ 03:52 PDTToolsReplyInserting Integer into Varcharwhenever you try to convert an numeric data type to character type, teradata would internally apply the formating associated with the numeric type to convert it to character data.127 in TD defaults...
27417 Sep 2007 @ 06:52 PDTAnalyticsReplymonths_between terradataYou can either join with the calendar tables or play around using the EXTRACT functions to build the logic to do the same in TD.something on this line .....SELECT DT1, DT2, ((EXTRACT(YEAR FROM DT1...
27310 Sep 2007 @ 11:31 PDTAnalyticsReplyDeducting ValuesSELECT VAL, VAL - COALESCE(SUM(VAL) OVER(ORDER BY VAL ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING), 0) DIFFFROM MYTABLE; VAL DIFF 0 0 17 17 23 6 25 2
27210 Sep 2007 @ 04:42 PDTDatabaseReplyJoin IndexOnce mload get's into the APPLY phase, ie., when it begins to apply the input records onto the target table, the worktable contents of an AMP reflects the records that should go into the target tab...
27109 Sep 2007 @ 11:13 PDTThird Party SoftwareReplyPls help, for TeraData functionYou probably need a UDF, these are programs written in C/C++ and installed into the database server, so you will be able to do things like SELECT MYFUNC(acct) FROM ACCOUNT; etc ...For more details ...
27007 Sep 2007 @ 02:57 PDTToolsReplyLongest Running QueryThere's a query that will you the Top 10 performers on time in the past one day ....SELECT UserName, QueryText, ElapsedTime, RANK() OVER(ORDER BY ElapsedTime DESC) AS RNKFROM DBC.QRYLOGWHERE STARTT...
26907 Sep 2007 @ 02:05 PDTDatabaseReplyJoin IndexOne of the critical working intrinsics of both Multi Load and Fast load are that they are AMP local. That's One good reason for not supporting JI...But yes you can have a single Table JI with same ...
26806 Sep 2007 @ 10:57 PDTToolsReplyLongest Running Queryif you enable DBQL, you will get most of the info you are looking from the Qry logs views ..
26706 Sep 2007 @ 04:13 PDTToolsReplySQL assistant vs BTEQBteq has no scheduler, it's just a utility to execute SQLS, do a little bit of formating, export/import small scale data and capable of doing teeny-weeny if else conditions. ... nothing more (that ...
26605 Sep 2007 @ 10:13 PDTDatabaseReplywhat is cover indexTeradata stores the values of the columns referred in the Index definition in the Index Subtable. Index subtables are generally smaller than data subtable. So if a query refers only to columns that...
26503 Sep 2007 @ 05:40 PDTToolsReplySQL assistant vs BTEQ"Bteq" script is nothing but a bunch of SQLs and any other Bteq commands (like logon, transaction mode, width etc etc .... ) wrapped in a file. (most of us save it with an extension of .bteq but it...
26403 Sep 2007 @ 05:18 PDTDatabaseReplyJoin IndexCreating a join index results in a JI subtable creation. The concept is similar to how Secondary index creation results in a SI subtable creation. Whenever the data subtable is updated, any updates...
26303 Sep 2007 @ 12:07 PDTDatabaseReplyUnbounded PRECEDING? how to use it in this case.Something like this ?SELECT ORDERID, ENTRY_TS, WORKED_BY, MAX(ENTRY_TS) OVER(PARTITION BY ORDERID ORDER BY ENTRY_TS ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) PREV_ENTRY_T, MAX(WORKED_BY) OVER(PART...
26202 Sep 2007 @ 11:57 PDTDatabaseReplyTables to Views Cross ReferenceOops it does :o , I over looked the multiple result tabs of the queryman ;-) May be I should start working on the script now :-)
26131 Aug 2007 @ 08:45 PDTToolsReplyshow viewsYou can do a SHOW VIEW yourdb.yourview;That will show view DDL even if it's on a different DBto change default DB to URI, use the commandDATABASE URI;(this is valid only in the session where it's e...
26031 Aug 2007 @ 12:20 PDTDatabaseReplyTables to Views Cross ReferenceHmm... There's the trouble with nested views ... ;-) CREATE VIEW V_TABLE_CNTASSELECT COUNT(*) AS TABLE_CNT FROM DBC.TABLES;SHOW SELECT * FROM V_TABLE_CNT;Request TextCREATE VIEW V_TABLE_CNTASSELEC...
25929 Aug 2007 @ 08:52 PDTToolsReply2631-Transaction ABORTed due to %VSTR.This normally happens when you have a dead lock situation.It's generally difficult to reproduce, you will have to know what other SQL operations where happening during the same time.Look for other ...
25829 Aug 2007 @ 06:40 PDTConnectivityReplyCreating UDF'sYou would want to read the UDF orange book, if you want to go through the step by step stuff. It should be available in The Teradata At your Service website. If you don't have login, your NCR suppo...
25722 Aug 2007 @ 06:08 PDTConnectivityReplyUDF and mainframeThe UDFs are actually stored in the DB nodes (TPA), it's irrelevant whether you access the from a client in the Windows/Unix or mainframe.UDFs can be written in C/C++ ... when you submit the code t...
25620 Aug 2007 @ 11:18 PDTToolsReplyDelete from teradata using BTEQ /MLOAD with parametersMay be I didn't get the Q right, but have you thought of just importing the contents of the text file into a temp table using bteq and doing a single DELETE using a join with that temp table ?

Pages