#DateForumTypeThreadPost
808 Mar 2016 @ 12:53 PSTDatabaseReplyHow to update the current row value based on the previous row value of the same columnThank you very much,  Can you please elaborate more about the solution? Even with self join, how can I use the column that has not been created yet in the self-join, that is the RANK column i...
707 Mar 2016 @ 05:43 PSTDatabaseTopicHow to update the current row value based on the previous row value of the same column   Dear all,  I have the following data: DATE CODE RANK ? ABS 0 12/04/2014 RET 0 20/04/2014 STT 0 01/05/2014 RETk 0 ...
610 Feb 2016 @ 11:19 PSTToolsTopicVery large table loading fails with Fastload, what are other possible solutions? Dear Experts,  I have a lrage table (about 200 Go) that I want to load in Teradata. Unfortunately, I am running on a Windows 32 bits machine and hence I get the following error while trying t...
501 Feb 2016 @ 07:22 PSTDatabaseReplyAutomate my Teradata queriesDear all,  I have the same enquiry: I want to schedule my Teradata query to run every day at a given time but I am not sure I have understood the approach with BTEQ... Could you please elabor...
412 Jan 2016 @ 01:46 PSTConnectivityReplyQuerying an Oracle database from a Teradata queryUnfortunately, I have no admin rights on the Teradata data base so I cannot add the USL. Is there any other solution that doesn't involve installing additional tools? Something equivalent to th...
311 Jan 2016 @ 06:55 PSTConnectivityTopicQuerying an Oracle database from a Teradata queryDear all,  I would like ti create a DB Link from a Teradata database (v. 14.10.05.09) to an Oracle database (10g) but the Create DBLink query doesn't work. I have looked on the Inter...
213 Dec 2015 @ 03:22 PSTDatabaseReply"WITH RECURSIVE" CONCATENATION RESULT TRUNCATEDIt works with Cast in the seed query. Thank you for your time.
111 Dec 2015 @ 12:08 PSTDatabaseTopic"WITH RECURSIVE" CONCATENATION RESULT TRUNCATEDDear all,  I am trying to concatenate multiple rows with a commun entry in one new column using the "WITH RECURSIVE" syntax. But I have noticed that the result, when  exceeding...