As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.
Hi, this my first post in this community, but i've used it frequently. First of all i want to apologize for my bad english and i hope that i'm clear to explain this issue.
I've this problem: In my workspace i use a UNION statement.
I've upload 2 file (excel file) , create 2 synonym and adjust the format if necessary.
I connect to SQL statements and then to the UNION. After UNION i've a JOIN with the other table SQLServer and xfocus format.
When i choose a filed of union select to write in a table target i get this error: (FOC14010) NOT A VALID COLUMN NAME: LIVELLO_ESCALATION.
I'm newbi but seems that if i want federate more data type specially xfocus the dataflow doesn't work if is a presente UNION.
If i remove xfocus and, in Last SQL statement, i put an alias on LIVELLO_ESCALATION filed , than tha dataflow work pretty well.
What's wrong? this is the prepare code:
-TYPE (ICM18429) Issuing PREPARE
SQL PREPARE SQLIN FROM
SELECT
T7.IST ,
T7.NDG ,
T7.E_ACC_CASSA ,
T1.LIVELLO_ESCALATION AS LIVX
FROM
((SELECT
T8.ISTITUTO ,
T8.SAE ,
T8.SETTORE ,
T8.DESCRIZIONE_SAE
FROM
dm_sae T8
) T9
RIGHT OUTER JOIN
((SELECT
T6.IST ,
T6.NDG ,
T6.E_ACC_CASSA
FROM
vr00s001_30092013 T6
) T7
LEFT OUTER JOIN
((SELECT
47 AS ISTITUTO ,
T4.NDG ,
T4.LIVELLO_ESCALATION ,
T4.M_NDG
FROM
bari T4
) --T2
UNION
(SELECT
46 AS ISTITUTO ,
T5.NDG ,
T5.LIVELLO_ESCALATION ,
T5.M_NDG
FROM
cro T5
) --T3
) T1
ON
T7.IST = T1.ISTITUTO AND
T7.NDG = T1.M_NDG )
ON
T9.ISTITUTO = T7.IST )
END
-RUN
I'm doing something wrong? Thanks for the answers This message has been edited. Last edited by: dr.herojos,
WebFOCUS 8.2 Relase 8203 Build Gen 43 DataMigrator 8203M Gen Number 1337 Windows, All Outputs
Posts: 23 | Location: Bari - Italy | Registered: October 20, 2013