Toad World® Forums

Unsupported column name

I am having an issue with a cross system query. This is the error I am receiving, can anyone suggest a work-around.

The column MAKT.MAKTX in SAPISSTG (EDGDQ_DSP_STG), EDGDQ_DSP_STG.EDGDQ_DSP_STG.STG_MS4_MARA_MAKT_JOIN is not supported.

Here is the query:

SELECT STG_MS4_MARA_MAKT_JOIN.MATNR
, STG_MS4_MARA_MAKT_JOIN.MAKT.MAKTX
FROM SAPISSTG (EDGDQ_DSP_STG), EDGDQ_DSP_STG.EDGDQ_DSP_STG.STG_MS4_MARA_MAKT_JOIN STG_MS4_MARA_MAKT_JOIN

Hi,
is it Query builder or Editor?
Which database connections are they? Which datatypes are the columns?
Can you avoid using the column completely?

I need the column, it has a mixture of characters and numerics and is connecting to a oracle server

Hi Jason,
MAKT.MAKTX is a column name and it has a dot in the name, correct? If so, it is a known issue (https://jira.labs.quest.com/browse/TIC-12431), and fixed in embedded hub v5.1.4 , which will be shipped with TDP in TDP next release.
Filip will follow up this issue to give you TDP next release number.