280 | 04 Oct 2007 @ 02:11 PDT | UDA | Reply | Difference 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... |
279 | 04 Oct 2007 @ 01:36 PDT | UDA | Reply | Fastload | It'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 ... |
278 | 25 Sep 2007 @ 11:03 PDT | Connectivity | Reply | SQL using JDBC driver | Ideally 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 ... |
277 | 24 Sep 2007 @ 01:11 PDT | Database | Reply | Age Calculation | SELECT DT1, DT2, DT2-DT1 YEARFROM MYTABLE; |
276 | 20 Sep 2007 @ 04:24 PDT | Database | Reply | Querying table stats from dbc tables | Dieter made some SQLs for this .... check if it would suffice your requirement.You can find it here http://www.teradataforum.com/attach.htm |
275 | 18 Sep 2007 @ 03:52 PDT | Tools | Reply | Inserting Integer into Varchar | whenever 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... |
274 | 17 Sep 2007 @ 06:52 PDT | Analytics | Reply | months_between terradata | You 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... |
273 | 10 Sep 2007 @ 11:31 PDT | Analytics | Reply | Deducting Values | SELECT 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 |
272 | 10 Sep 2007 @ 04:42 PDT | Database | Reply | Join Index | Once 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... |
271 | 09 Sep 2007 @ 11:13 PDT | Third Party Software | Reply | Pls help, for TeraData function | You 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 ... |
270 | 07 Sep 2007 @ 02:57 PDT | Tools | Reply | Longest Running Query | There'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... |
269 | 07 Sep 2007 @ 02:05 PDT | Database | Reply | Join Index | One 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 ... |
268 | 06 Sep 2007 @ 10:57 PDT | Tools | Reply | Longest Running Query | if you enable DBQL, you will get most of the info you are looking from the Qry logs views .. |
267 | 06 Sep 2007 @ 04:13 PDT | Tools | Reply | SQL assistant vs BTEQ | Bteq 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 ... |
266 | 05 Sep 2007 @ 10:13 PDT | Database | Reply | what is cover index | Teradata 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... |
265 | 03 Sep 2007 @ 05:40 PDT | Tools | Reply | SQL 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... |
264 | 03 Sep 2007 @ 05:18 PDT | Database | Reply | Join Index | Creating 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... |
263 | 03 Sep 2007 @ 12:07 PDT | Database | Reply | Unbounded 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... |
262 | 02 Sep 2007 @ 11:57 PDT | Database | Reply | Tables to Views Cross Reference | Oops it does :o , I over looked the multiple result tabs of the queryman ;-) May be I should start working on the script now :-) |
261 | 31 Aug 2007 @ 08:45 PDT | Tools | Reply | show views | You 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... |
260 | 31 Aug 2007 @ 12:20 PDT | Database | Reply | Tables to Views Cross Reference | Hmm... 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... |
259 | 29 Aug 2007 @ 08:52 PDT | Tools | Reply | 2631-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 ... |
258 | 29 Aug 2007 @ 06:40 PDT | Connectivity | Reply | Creating UDF's | You 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... |
257 | 22 Aug 2007 @ 06:08 PDT | Connectivity | Reply | UDF and mainframe | The 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... |
256 | 20 Aug 2007 @ 11:18 PDT | Tools | Reply | Delete from teradata using BTEQ /MLOAD with parameters | May 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 ? |