conversion of oracle code into Teradata

Analytics
Enthusiast

conversion of oracle code into Teradata

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;
3 REPLIES
Teradata Employee

Re: conversion of oracle code into Teradata

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.
Enthusiast

Re: conversion of oracle code into Teradata

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?

Teradata Employee

Re: conversion of oracle code into Teradata

How much will you pay me? ;)