773 | 07 Mar 2016 @ 04:48 PST | Database | Reply | How to update the current row value based on the previous row value of the same column | You can use self-join using derived SQL. Once set with RANK and other set with RANK - 1.
|
772 | 06 Mar 2016 @ 08:47 PST | Database | Reply | Hierarchial Data Sorting | Whats the structure of the table? Parent & child are in separate columns or in one? Have you tried ORDER BY Parent, Child?
|
771 | 06 Mar 2016 @ 08:29 PST | Database | Reply | Varchar column reduces to 255 chars in result set | Does your query include UNION/UNION ALL? Can you share your query?
|
770 | 06 Mar 2016 @ 08:24 PST | Database | Reply | unknown data in table | Have you contacted Teradata CS? If no, you should. If yes, they must have an answer to why it happened.
|
769 | 06 Mar 2016 @ 08:22 PST | Database | Reply | Alternative for Multiple Left outer join | In one line, there is no alternative to LEFT OUTER JOIN.
Regarding fixing performance .... How are the tables designed? What the joining columns? What is the PI? .... search forum and you will get... |
768 | 06 Mar 2016 @ 08:17 PST | Database | Reply | Getting Error Message inside a Stored Proc Exception Handler | Looks good. Are you sure you want to continue after getting an exception?
|
767 | 06 Mar 2016 @ 08:16 PST | Database | Reply | BTEQ hangs for large BTEQ file | How are you processing the BTEQ file? Doesn't seem to be a BTEQ issue rather perhaps the shell issue perhaps.
|
766 | 06 Mar 2016 @ 08:14 PST | Database | Reply | LOCKING TABLE table_name FOR ACCESS can be blocked by other locks | LOCKING ROW FOR ACCESS will give you the dirty read. Check the Teradata documentation, there is a matrix of which locks can supercede and stuff. It would help.
|
765 | 06 Mar 2016 @ 08:09 PST | Database | Reply | MERGE statement problem with IDENTITY field on TARGET Table | The following should help resolving this issue:
https://forums.teradata.com/forum/database/using-merge-into-a-table-with-an-identity-column-result-failure-5758
|
764 | 06 Mar 2016 @ 07:54 PST | Database | Reply | need to test a query using three diff dates | SELECT CURRENT_DATE, CURRENT_DATE - 1, CURRENT_DATE - 2
|
763 | 06 Mar 2016 @ 07:42 PST | Database | Reply | Data type does not match a Defined Type name error | When you copy SQL from other tool (mostly) it can have some special characters. You might want to try pasting the SQL in Notepad++ or other tool which can show hidden characters as well.
|
762 | 06 Mar 2016 @ 07:33 PST | Database | Reply | Teradata Table Naming | Multi/Fast-Load are obsolete now. Can you try with TPT which is a replacement for them?
|
761 | 06 Mar 2016 @ 07:28 PST | Private Forum |
760 | 06 Mar 2016 @ 07:22 PST | Private Forum |
759 | 06 Mar 2016 @ 07:19 PST | Private Forum |
758 | 06 Mar 2016 @ 07:17 PST | Private Forum |
757 | 06 Mar 2016 @ 07:12 PST | Private Forum |
756 | 06 Mar 2016 @ 07:07 PST | Private Forum |
755 | 26 Jan 2016 @ 06:16 PST | Database | Reply | Date Setting | Do you keep a log table which has the dates for which you have ran your load for?
|
754 | 26 Jan 2016 @ 06:08 PST | Database | Reply | View details required for the underlying tablename | Alternatively, you can use 'References' in Teradata Admin.
|
753 | 26 Jan 2016 @ 06:05 PST | Database | Reply | Implement logic in a stored procedure | Or you can simply search for Transpose logic. Should be able to prepare 1 SELECT in SP and run it to INSERT in a table.
|
752 | 26 Jan 2016 @ 06:01 PST | Database | Reply | Query running for more than 16 hrs for insertion operation | Whats the PI of source table? Also, are there any stats collected on underlying tables?
And as Dieter asked, can you access check QryLogStepsV or viewpoint and see which actual step takes most of ... |
751 | 26 Jan 2016 @ 05:54 PST | Database | Reply | Invalid query while trying to run a file | Help me understand. You are trying to run a FastLoad script and you want to use .RUN command for login statement that sits in a separate file. Is that what you are trying to achieve?
|
750 | 26 Jan 2016 @ 05:50 PST | Database | Reply | need teradata logic | You can use following:
CREATE VOLATILE TABLE temp
(
col1 DATE
,col2 DATE
,col3 DATE
,col4 DATE
) ON COMMIT PRESERVE ROWS;
INSERT temp(col1) VALUES(CURRENT_DATE);
SELECT * FRO... |
749 | 26 Jan 2016 @ 04:58 PST | Database | Reply | TPT load in informatica giving CLI Error | What are the errors you are getting? And are/were you able to run the similar jobs using same TPT connection?
|