|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/14/2008 8:15:26 AM
Posts: 7,
Visits: 30
|
|
Hi,
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,COUNT
SELECT '"'||campaign_nm||'","'||
campaign_cd||'","'||
flowchart_nm||'","'||
cell_cd||'",'||
COUNT(*)
FROM cop_unica_stage_itms a
WHERE campaign_cd ='&campaign_cd'
AND flowchart_nm ='&flowchart_nm'
GROUP BY '"'||campaign_nm||'","'||
campaign_cd||'","'||
flowchart_nm||'","'||
cell_cd;
THANKS IN ADVANCE
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 9/4/2008 4:08:05 PM
Posts: 91,
Visits: 117
|
|
You 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.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/14/2008 8:15:26 AM
Posts: 7,
Visits: 30
|
|
Hi,
How can i change the following oracle code into Teradata...
PROMPT CAMPAIGN NM,CAMPAIGN CD,FLOWCHART NM,CELL CD,COUNT
SELECT '"'||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?
THANKS IN ADVANCE
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 9/4/2008 4:08:05 PM
Posts: 91,
Visits: 117
|
|
|
How much will you pay me? ;)
|
|
|
|