Archives of the TeradataForum

Message Posted: Tue, 08 Apr 2003 @ 16:07:27 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello,

I am running the following code:

create table work.tamkts as select * from tamkts.taods;

create table work.testty as select * from connection to odbc
(
select Sum_Net_Agncy_Bkd_Psgr_Cnt as pax,
Bkd_NonDirnl_Orig_Arpt_Cd as Org,
Bkd_NonDirnl_Dest_Arpt_Cd as Dst,
Arln_Cd as cx,
bkd_itin_dprt_yr_mo_nbr as dptdtety,
bkd_cls_of_svc_cd as cls

FROM STDMV.DAILY_BKNG_DPRT_MNTH_SMRY

WHERE(Bkng_Dt = 1030331)
AND (bkd_itin_dprt_yr_mo_nbr='200305')
AND arln_cd IN ('DL')
AND (Bkd_NonDirnl_Orig_Arpt_Cd, Bkd_NonDirnl_Dest_Arpt_Cd) IN (select *
=
from WORK.TAMKTS)
);

And getting the following error message:

ERROR: CLI prepare error: [NCR][ODBC Teradata][Teradata RDBMS] Syntax =
error, expected something like a name between the 'from'
       keyword and the 'WORK' keyword.
SQL statement: select Sum_Net_Agncy_Bkd_Psgr_Cnt as pax, =
Bkd_NonDirnl_Orig_Arpt_Cd as Org, Bkd_NonDirnl_Dest_Arpt_Cd as Dst,
       Arln_Cd as cx, bkd_itin_dprt_yr_mo_nbr as dptdtety, =
bkd_cls_of_svc_cd as cls FROM STDMV.DAILY_BKNG_DPRT_MNTH_SMRY
       WHERE(Bkng_Dt = 1030331) AND =
(bkd_itin_dprt_yr_mo_nbr='200305') AND arln_cd IN ('DL') AND =
(Bkd_NonDirnl_Orig_Arpt_Cd,
       Bkd_NonDirnl_Dest_Arpt_Cd) IN (select * from WORK.TAMKTS).

What am I doing wrong?

Jim Hayes,
Delta Airlines, Network Analysis

	<Prev	Next>		<<First	<Prev	Next>	Last>>