SQL Editor issue - NFD/NFC

Hello, Struggling with this once since a couple of days. tried removing the spaces / adding spaces but nothing seems to work - considering the query works fine in Teradata... please help!

SEL GL_ACCOUNT_CODE, COMPANY_CODE, PROFIT_CENTER_CODE, MRC_CODE, FISCAL_YEAR, FISCAL_YEAR_PERIOD_NUMBER, SRC_SYS_ID, SUM (MRC_MTD_AMOUNT), SUM (MRC_YTD_AMOUNT), SUM (MRC_YTD_AMOUNT), SUM (LOCAL_MTD_AMOUNT), SUM (LOCAL_YTD_AMOUNT)
FROM FPR_V.PRJ_FACT_SALES_COGS_BAL_PLAN
WHERE SRC_SYS_ID = 'ABCD'
AND FISCAL_YEAR = 2020
GROUP BY 1,2,3,4,5,6,7
ORDER BY 1,2,3,4,5,6;

Input

Accepted answers

MarqueeCrew

@SDeora ,

@joshuaburkhow 's link should be: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/In-Database-Error-The-object-name-is-too-long-in-NFD-NFC-when/td-p/51214

As for the select statement, what type of time savings does Teradata achieve by shortening SELECT to SEL? I'd change that if for no other reason that it is too terse for me.

Cheers,

Mark

All comments

joshuaburkhow

Hi @SDeora

There are a few things to check. Most of them are here https://community.alteryx.com/t5/Alteryx-Designer-Discussions/In-Database-Error-The-object-name-is-too-long-in-NFD-NFC-when/td-p/51214

Might be the spaces....

SDeora

Thanks but I'm unable to open the link... 😞 it says invalid parameters.

MarqueeCrew

@SDeora ,

@joshuaburkhow 's link should be: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/In-Database-Error-The-object-name-is-too-long-in-NFD-NFC-when/td-p/51214

As for the select statement, what type of time savings does Teradata achieve by shortening SELECT to SEL? I'd change that if for no other reason that it is too terse for me.

Cheers,

Mark

SDeora

SEL to Select seems to have worked for me ! Thanks!!!

csh8428

@MarqueeCrew 's advise to change "sel" to "select" also worked for me.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703