#DateForumTypeThreadPost
24605 Feb 2008 @ 01:00 PSTToolsReplyCOMP causing Mload faliureMainframe 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(...
24504 Feb 2008 @ 01:47 PSTDatabaseReplyProblems 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...
24401 Feb 2008 @ 07:12 PSTDatabaseReplyProblems 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...
24301 Feb 2008 @ 06:43 PSTDatabaseReplyDesc commandHELP TABLE MyDB.MyTable;
24231 Jan 2008 @ 05:34 PSTToolsReplyMload a COMP field from mainframeCOBOL 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...
24131 Jan 2008 @ 05:33 PSTToolsReplyCOMP causing Mload faliureCOBOL 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, ...
24025 Jan 2008 @ 04:59 PSTDatabaseReplyResUsageSldv vs ResUsageSvdskSLDV data can be SCSI or PDISK level information. See the xctl / ctl utility. There's nothing "in between" AMP and PDISK level.
23922 Jan 2008 @ 08:23 PSTToolsReplySQL Assistant tools for Windows x64The 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)....
23815 Jan 2008 @ 08:17 PSTToolsReplyCasting Zoned decimal into readable decimalThe 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')
23714 Jan 2008 @ 12:26 PSTDatabaseReplyTimestamp calculationHow about select local_timestamp - (difference * interval '1' minute) from table_1;
23610 Jan 2008 @ 02:55 PSTDatabaseReplyDELETE ALL vs DELETEI 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...
23510 Jan 2008 @ 02:16 PSTDatabaseReplyFinding the last full weekIs 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...
23407 Jan 2008 @ 06:18 PSTDatabaseReplyFinding the last full weekHow 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...
23307 Jan 2008 @ 06:02 PSTToolsReplyAM/PM in TIMESTAMPIt'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...
23207 Jan 2008 @ 05:35 PSTToolsReplyDecimal error in Mload JCLNote 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...
23131 Dec 2007 @ 12:49 PSTDatabaseReplyHow 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...
23031 Dec 2007 @ 10:57 PSTDatabaseReplysubtracting from Timestamp column.Tryselect current_timestamp(0) - interval '6' hour;
22931 Dec 2007 @ 10:50 PSTToolsReplyFunny 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).
22811 Dec 2007 @ 05:27 PSTDatabaseReplyProdreadysum and sw_event_logDBC.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...
22709 Dec 2007 @ 09:21 PSTDatabaseReplyProdreadysum and sw_event_logAre 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...
22604 Dec 2007 @ 03:01 PSTThird Party SoftwareReplyHow 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...
22530 Nov 2007 @ 06:20 PSTThird Party SoftwareReplyHow 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...
22429 Nov 2007 @ 03:11 PSTToolsReplyNeed info about exception handling in teradataYou 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...
22326 Nov 2007 @ 03:01 PSTAnalyticsReplyWITH RECURSIVEBecause 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...
22224 Nov 2007 @ 11:30 PSTAnalyticsReplyWITH RECURSIVEThe 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...

Pages