246 | 05 Feb 2008 @ 01:00 PST | Tools | Reply | COMP causing Mload faliure | Mainframe COBOL PIC S9(13)V99 COMP would be stored as an 8-byte binary integer with implied decimal.So in MLOAD .LAYOUT use .FIELD BALANCEIN * BIGINT;and in the DML use CAST(:BALANCEIN AS DECIMAL(... |
245 | 04 Feb 2008 @ 01:47 PST | Database | Reply | Problems with a cursor... | As you seem to suspect, COMMIT applies to the entire transaction - so you would not normally include a COMMIT within an "internal procedure". Teradata does not currently support intermediate SAVEPO... |
244 | 01 Feb 2008 @ 07:12 PST | Database | Reply | Problems with a cursor... | To do this, you'll need to run in ANSI session mode (not Teradata BT/ET mode). ANSI transaction semantics roll back the current request without failing the entire transaction. That should let you d... |
243 | 01 Feb 2008 @ 06:43 PST | Database | Reply | Desc command | HELP TABLE MyDB.MyTable; |
242 | 31 Jan 2008 @ 05:34 PST | Tools | Reply | Mload a COMP field from mainframe | COBOL COMP with 1-2 digits = BYTEINT3-4 digits = SMALLINT5-9 digits = INTEGER10-18 digits = BIGINTIf you also have an implied decimal point in your COMP field, you will need to scale the number (di... |
241 | 31 Jan 2008 @ 05:33 PST | Tools | Reply | COMP causing Mload faliure | COBOL COMP fields correspond to Teradata BYTEINT, SMALLINT, INTEGER, or BIGINT depending on the number of digits (1-2,3-4,5-9, or 10-18). If you have an implied decimal point in the COBOL PICture, ... |
240 | 25 Jan 2008 @ 04:59 PST | Database | Reply | ResUsageSldv vs ResUsageSvdsk | SLDV data can be SCSI or PDISK level information. See the xctl / ctl utility. There's nothing "in between" AMP and PDISK level. |
239 | 22 Jan 2008 @ 08:23 PST | Tools | Reply | SQL Assistant tools for Windows x64 | The 64-bit drivers are available now for embedded SQL applications. But most Teradata-supplied client utilities and applications are still 32-bit (and usually require corresponding 32-bit drivers).... |
238 | 15 Jan 2008 @ 08:17 PST | Tools | Reply | Casting Zoned decimal into readable decimal | The S must be the last format specifier, and you must specify both the format and the new datatype clauses in the same CAST.SELECT CAST(field1 AS DECIMAL(11,2) FORMAT '9(9)V99S') |
237 | 14 Jan 2008 @ 12:26 PST | Database | Reply | Timestamp calculation | How about select local_timestamp - (difference * interval '1' minute) from table_1; |
236 | 10 Jan 2008 @ 02:55 PST | Database | Reply | DELETE ALL vs DELETE | I believe Dieter is correct. The only difference is syntax - choosing to explicitly state ALL rather than just omitting the WHERE clause. There is no difference in semantics or database behavior.If... |
235 | 10 Jan 2008 @ 02:16 PST | Database | Reply | Finding the last full week | Is this join syntax clearer?...INNER JOIN (Select calendar_date-day_of_week-6 as min_date, calendar_date-day_of_week as max_datefrom sys_calendar.calendar where calendar_date = current_date) date_r... |
234 | 07 Jan 2008 @ 06:18 PST | Database | Reply | Finding the last full week | How about something like this:FROM...(Select calendar_date-day_of_week-6 as min_date, calendar_date-day_of_week as max_date from sys_calendar.calendar where calendar_date = current_date) date_range... |
233 | 07 Jan 2008 @ 06:02 PST | Tools | Reply | AM/PM in TIMESTAMP | It's not clear from your example what you are trying to do, but perhaps one of these will help:Convert text input to Teradata TIMESTAMP field:SELECT CAST('20041212143245' AS TIMESTAMP(0) FORMAT 'yy... |
232 | 07 Jan 2008 @ 05:35 PST | Tools | Reply | Decimal error in Mload JCL | Note that .LAYOUT datatypes describe the input file data, not the table column.It's not clear what you mean when you say the field occupies only 5 positions. Do you mean it looks like x'12 34 56 78... |
231 | 31 Dec 2007 @ 12:49 PST | Database | Reply | How to use decision logic in Macro? | Teradata macros are multistatement requests. There are no control statements for macros (unless you count the ABORT test to roll back the entire unit of work).You can do what you outline with Terad... |
230 | 31 Dec 2007 @ 10:57 PST | Database | Reply | subtracting from Timestamp column. | Tryselect current_timestamp(0) - interval '6' hour; |
229 | 31 Dec 2007 @ 10:50 PST | Tools | Reply | Funny characters in Fastexport script...Please suggest... | You need to specify a client characterset for the output data, e.g. "-c UTF16". The default is ASCII (or EBCDIC for mainframe). |
228 | 11 Dec 2007 @ 05:27 PST | Database | Reply | Prodreadysum and sw_event_log | DBC.ResUsageSPMA.ProcReadySum is not populated on Linux or Windows (under any release), only MP-RAS.DBC.SW_Event_Log is not populated on Linux or Windows prior to TD12.0.For V2R6.2 on Linux you nee... |
227 | 09 Dec 2007 @ 09:21 PST | Database | Reply | Prodreadysum and sw_event_log | Are you running Teradata on Windows? ProcReadySum is only available on MP-RAS, and then only if you have ResUsage collection and logging active including table SPMA. Similarly SW_Event_Log is not u... |
226 | 04 Dec 2007 @ 03:01 PST | Third Party Software | Reply | How to exec macro from MS Access? | It depends on what you are doing in Access. If you are using VBA with ADO, you can use the nextResultSet method. You can also build a "MakeTable Query" on top of the pass-through query. Search MDSN... |
225 | 30 Nov 2007 @ 06:20 PST | Third Party Software | Reply | How to exec macro from MS Access? | A Teradata macro is a "multi-statement request" that can return multiple result sets. That requires special handling / workarounds within MS Access or any other client application. In particular, I... |
224 | 29 Nov 2007 @ 03:11 PST | Tools | Reply | Need info about exception handling in teradata | You can also check based on the "severity" (ERRORLEVEL). That allows you to use .SET ERRORLEVEL to (temporarily) modify the severity of selected ERRORCODEs. For example:* Change "object does not ex... |
223 | 26 Nov 2007 @ 03:01 PST | Analytics | Reply | WITH RECURSIVE | Because NOT IN is one of the elements not permitted within a recursive statement in a WITH RECURSIVE clause - see SQL Reference: Data Manipulation Statements; SELECT Statement, WITH RECURSIVE Claus... |
222 | 24 Nov 2007 @ 11:30 PST | Analytics | Reply | WITH RECURSIVE | The problem with SUBSTR is mixed syntax. You can either saySUBSTR(T.cbn_cls,T.str_len) or SUBSTRING(T.cbn_cls FROM T.str_len).As far as the recursion, there are two problems. First is the negated c... |