77307 Mar 2016 @ 04:48 PSTDatabaseReplyHow to update the current row value based on the previous row value of the same columnYou can use self-join using derived SQL. Once set with RANK and other set with RANK - 1.
77206 Mar 2016 @ 08:47 PSTDatabaseReplyHierarchial Data SortingWhats the structure of the table? Parent & child are in separate columns or in one? Have you tried ORDER BY Parent, Child?
77106 Mar 2016 @ 08:29 PSTDatabaseReplyVarchar column reduces to 255 chars in result setDoes your query include UNION/UNION ALL? Can you share your query?
77006 Mar 2016 @ 08:24 PSTDatabaseReplyunknown data in tableHave you contacted Teradata CS? If no, you should. If yes, they must have an answer to why it happened.
76906 Mar 2016 @ 08:22 PSTDatabaseReplyAlternative for Multiple Left outer joinIn 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...
76806 Mar 2016 @ 08:17 PSTDatabaseReplyGetting Error Message inside a Stored Proc Exception HandlerLooks good. Are you sure you want to continue after getting an exception?
76706 Mar 2016 @ 08:16 PSTDatabaseReplyBTEQ hangs for large BTEQ fileHow are you processing the BTEQ file? Doesn't seem to be a BTEQ issue rather perhaps the shell issue perhaps.
76606 Mar 2016 @ 08:14 PSTDatabaseReplyLOCKING TABLE table_name FOR ACCESS can be blocked by other locksLOCKING 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.
76506 Mar 2016 @ 08:09 PSTDatabaseReplyMERGE statement problem with IDENTITY field on TARGET TableThe following should help resolving this issue:   https://forums.teradata.com/forum/database/using-merge-into-a-table-with-an-identity-column-result-failure-5758
76406 Mar 2016 @ 07:54 PSTDatabaseReplyneed to test a query using three diff datesSELECT CURRENT_DATE, CURRENT_DATE - 1, CURRENT_DATE - 2
76306 Mar 2016 @ 07:42 PSTDatabaseReplyData type does not match a Defined Type name errorWhen 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.
76206 Mar 2016 @ 07:33 PSTDatabaseReplyTeradata Table Naming Multi/Fast-Load are obsolete now. Can you try with TPT which is a replacement for them?
76106 Mar 2016 @ 07:28 PSTPrivate Forum
76006 Mar 2016 @ 07:22 PSTPrivate Forum
75906 Mar 2016 @ 07:19 PSTPrivate Forum
75806 Mar 2016 @ 07:17 PSTPrivate Forum
75706 Mar 2016 @ 07:12 PSTPrivate Forum
75606 Mar 2016 @ 07:07 PSTPrivate Forum
75526 Jan 2016 @ 06:16 PSTDatabaseReplyDate SettingDo you keep a log table which has the dates for which you have ran your load for?
75426 Jan 2016 @ 06:08 PSTDatabaseReplyView details required for the underlying tablenameAlternatively, you can use 'References' in Teradata Admin.
75326 Jan 2016 @ 06:05 PSTDatabaseReplyImplement logic in a stored procedureOr you can simply search for Transpose logic. Should be able to prepare 1 SELECT in SP and run it to INSERT in a table.
75226 Jan 2016 @ 06:01 PSTDatabaseReplyQuery running for more than 16 hrs for insertion operationWhats 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 ...
75126 Jan 2016 @ 05:54 PSTDatabaseReplyInvalid query while trying to run a fileHelp 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?
75026 Jan 2016 @ 05:50 PSTDatabaseReplyneed teradata logicYou 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...
74926 Jan 2016 @ 04:58 PSTDatabaseReplyTPT load in informatica giving CLI ErrorWhat are the errors you are getting? And are/were you able to run the similar jobs using same TPT connection?