#DateForumTypeThreadPost
807 Apr 2016 @ 03:29 PDTTeradata ApplicationsReplyExport multiple SQL's results into single excel sheet by sheetHi, I have a situation here. I have 2 SQLs in a single bteq and I am exporting 2 SQLs into separate excel sheets. .EXPORT REPORT FILE = Filepath\tab1.csv  SEPARATOR ',' ...
701 Apr 2016 @ 02:23 PDTAnalyticsReplyPassing a string into a macro for use in a IN statementBut I am in need to pass some parameter value that has comma in the middle of characters.  I am trying to escape paranthesis but it is not working.  I am trying like this  execute...
629 Mar 2016 @ 06:45 PDTAnalyticsReplyPassing a string into a macro for use in a IN statementThank you so much for the Quick response!! you saved my day!!   Cheers!!
529 Mar 2016 @ 12:23 PDTDatabaseReplyMasking commas within a macro parameter replace MACRO FBA_M.TEST_OCTOPUStest1 (p1 VARCHAR(100) )  AS( WITH RECURSIVE EXPRN (VALU, RMSTRING )AS ( SELECT (TRIM( CASE POSITION(',' IN STRN)  WHEN ...
428 Mar 2016 @ 11:02 PDTAnalyticsReplyPassing a string into a macro for use in a IN statementHi, I have landed in the same situation. replace MACRO TEST (p1 VARCHAR(100) ) AS ( SELECT a, b, c sum(k) FROM viewdb.x WHERE a IN ( SELECT CAST(d.token AS INT) FROM TABLE (STRT...
305 Jan 2016 @ 08:55 PSTToolsReplyLoading a timestamp column with FastloadThanks feinholz. I am able to load the data without having any issues. As you rightly said, it is due to the escape sequence.
230 Dec 2015 @ 12:51 PSTToolsReplyLoading a timestamp column with FastloadHi,  I have very similar issue. I am trying to Load Date column from oracle to Teradata and the source data is "10/9/2014 00:00:00".   When I am trying to do the implicit cas...
116 Dec 2015 @ 03:17 PSTToolsReplyTPT17122: Error: unable to connect to data source(oracle using TPT script)Hi, I am trying to move data from Oracle to Teradata using the TPT Script below but unable to connect to Oracle database as it throws an CLI 224 error like "name not in HOSTS file or names dat...