#DateForumTypeThreadPost
624 Aug 2012 @ 12:45 PDTToolsReplyExporting data using a BTEQ Thanks Carlos... but is there any way of achieving it. I have a requirement to achieve the same using a BTEQ and not a fast export script.
522 Aug 2012 @ 01:08 PDTDatabaseReplycreating a view on a SQL query starting with "WITH" clause Thanks Ulrich... But as stated in the earlier post, i have given the example just for illustration purpose. I am still looking for the answer of :- In TD14, is it allowed to have derived...
422 Aug 2012 @ 01:01 PDTToolsTopicExporting data using a BTEQ Hi, I am trying ot export data to a flat file using a BTEQ. I am getting an errneous situation in setting the target file format. First I am listing the code:- .EXPORT DATA FILE = $T...
307 Aug 2012 @ 11:03 PDTDatabaseReplycreating a view on a SQL query starting with "WITH" clause Hi, I have one more question regarding the WITH clause. In TD14, is it allowed to have with clause in derived tables. e.g just for illustration purpose:- SELECT cast(f1 as ch...
210 Jul 2012 @ 08:20 PDTDatabaseReplycreating a view on a SQL query starting with "WITH" clause Thank you ulrich and Dieter
110 Jul 2012 @ 03:54 PDTDatabaseTopiccreating a view on a SQL query starting with "WITH" clause Hi, I am trying to create a view on top of a SQL:- CREATE VIEW VIEWS_DB.sample_view AS WITH POC ( AUDT_RULE_ID, EVNT_DTM )AS (SEL AUDT_RULE_ID, EVNT_DTM FR...