InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:46:57 GMT20http://www.teradata.com/teradataforum/Topic10657-5-1.aspxHow much will you pay me? ;)Fri, 22 Feb 2008 12:15:09 GMTjeff_ohttp://www.teradata.com/teradataforum/Topic10657-5-1.aspxHi, How can i change the following oracle code into Teradata...PROMPT CAMPAIGN NM,CAMPAIGN CD,FLOWCHART NM,CELL CD,COUNTSELECT '"'||campaign_nm||'","'|| campaign_cd||'","'|| flowchart_nm||'","'|| cell_cd||'",'|| COUNT(*)FROM cop_unica_stage_itms WHERE campaign_cd ='&campaign_cd'AND flowchart_nm ='&flowchart_nm'Please send me the exact code if possible...What is the substitute of PROMPT in teradata?Fri, 22 Feb 2008 04:21:02 GMTraj1983http://www.teradata.com/teradataforum/Topic10657-5-1.aspxYou need to use FastExport for large extracts. If your extract is small you can use BTEQ or SQL Assistant.Since you are using parameters you would have to place them in a file that could be read by the import command.Refer to teradata documentation for details on these utilities.Thu, 21 Feb 2008 14:11:27 GMTjeff_ohttp://www.teradata.com/teradataforum/Topic10657-5-1.aspxHi, Please convert the following oracle code into Teradata...Thanks in advance.SET HEAD OFF;SET FEEDBACK ON;SET LINESIZE 32767;SET PAGESIZE 50000;PROMPT CAMPAIGN NM,CAMPAIGN CD,FLOWCHART NM,CELL CD,COUNTSELECT '"'||campaign_nm||'","'||       campaign_cd||'","'||       flowchart_nm||'","'||       cell_cd||'",'||       COUNT(*)FROM cop_unica_stage_itms aWHERE campaign_cd  ='&campaign_cd'AND   flowchart_nm ='&flowchart_nm'GROUP BY '"'||campaign_nm||'","'||         campaign_cd||'","'||         flowchart_nm||'","'||         cell_cd; Thu, 21 Feb 2008 05:27:18 GMTraj1983