#DateForumTypeThreadPost
1614 Oct 2013 @ 12:06 PDTDatabaseTopicUse of Analytical Functions in Join IndexHi All,   Can someone tell me if we can use OLAP functions during the creation of AJI.For eg:       CREATE JOIN INDEX BASESQL_Z AS SELECT       &...
1520 Sep 2012 @ 02:03 PDTDatabaseReplyRange of values in single row to multiple rowsThanks a lot Dieter.You are awesome :)   Cheers, Ashok.
1420 Sep 2012 @ 01:38 PDTDatabaseTopicRange of values in single row to multiple rowsHi All,   Can someone help me how can we implement below scenario in Teradata?   Input -----   AGE_CLASS_ID AGE_CLASS_DESC ...
1312 Jul 2012 @ 04:14 PDTDatabaseTopicAdvantages of Migration from DB2 Stored Procedures to Teradata Hi All,   Can someone please help me with the Advantages/Disadvantages of migrating to DB2 Stored procedures to Teradata BTeq or Stored Procedures?   Thanks, Ashok....
1203 Jul 2012 @ 04:48 PDTToolsTopicTVAS Implementation We have got a requirement where we need to implement  TVAS(Teradata Virtual Access Service) for reading  data from SAP BW Info cubes. Can someone please provide me some ...
1131 May 2012 @ 10:36 PDTDatabaseReplyPopulating column with constant day-of-week value? You can give a try using: Select day_of_week(date_column1) from Table1;   Thanks,
1031 May 2012 @ 10:36 PDTDatabaseReplyDay Of Week or Week-Ending Function? You can give a try using: Select day_of_week(date_column1) from Table1;   Thanks, Ashok.
902 Dec 2011 @ 10:56 PSTDatabaseTopicEnd Dating Previous Relations Hi All,   I have a requirement to end date all the previous relations.Can someone please help me with this:   For eg: Input: --------- Emp_Id  Dept_No ...
811 Nov 2011 @ 09:02 PSTThird Party SoftwareReplyMissing records within Teradata from Informatica I guess your target table is a set table which does nt allow you to load duplicates.Try to change the target table structure to Multiset and then give a try.   Thanks, Ashok. ...
711 Nov 2011 @ 08:47 PSTDatabaseReplyTruncation of Data while Bteq Export Can someone please help me out how to get the proper data without truncation and junk characters while bteq export???
611 Nov 2011 @ 08:40 PSTGeneralReplyHow to find list of users by table name You can use dbc.acceslog
508 Nov 2011 @ 09:34 PSTDatabaseReplyTruncation of Data while Bteq Export Is there anyone who can help with this please? Thanks.
407 Nov 2011 @ 10:40 PSTDatabaseReplyTruncation of Data while Bteq Export Hi , Can somebody please help me out with this? Thanks.
331 Oct 2011 @ 01:31 PDTDatabaseReplyWarning: EOF On Input Stream Hi All, Can anyone help me with this please?   Thanks, Ashok.
229 Oct 2011 @ 11:25 PDTDatabaseReplyWarning: EOF On Input Stream Hi Carlos, I am not sure what is causing this error.I doubt if the cursor is returning back to main script Cust_BteqScript.txt after the excution of logon file.The below script is not exe...
129 Oct 2011 @ 10:23 PDTDatabaseTopicWarning: EOF On Input Stream Hi All,   I was trying to run bteq with below code.   .RUN FILE='C:\Users\dell\Desktop\Cust_BteqScript.txt';'   Cust_BteqScript.txt contains be...