Kbase P68689: (7520)This operation may have failed due to column alias on
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/03/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D service pack 7
SYMPTOM(s):
(7520)This operation may have failed due to column alias on the select statement.]
Query using SQL Column alias option.
CAUSE:
Query is using an alias which is used in a function.
FIX:
Either remove the alias column or not using the function.
this is the Query:
CREATE view VDOC_VIEW_MFGPRO_CDE_ENT
as
SELECT D_so_nbr, D_cm_addr, D_so_bill, D_so_ship, D_cde_resp, D_drepris_ged, D_hrepris_ged , D_so_ord_date, D_so_site, D_so_po,
D_statut, 1 as D_synchroCdePlan
FROM openquery(MFG_TEST, 'select D_so_nbr, D_cm_addr, D_so_bill, D_so_ship, D_cde_resp, D_drepris_ged, D_hrepris_ged, D_so_ord_date,
D_so_site, D_so_po, D_statut, 1 from PUB.D_CDE_ENT').
this is the Query which works.
CREATE view VDOC_VIEW_MFGPRO_CDE_ENT2
as
SELECT * FROM openquery(MFG_TEST, 'select * from PUB.D_CDE_ENT')