Using FME2018.1 and SQLcreator reading attributes from an Oracle database, the attribute names always are in uppercase (although written lowercased in the SQL-select statement). Is there a way to avoid forcing the names to uppercase (I know the use of attributemanager or bulkattributerenamer, but am looking for a way to just leave it as specified by my SQLselect-statement)? Is there e.g. some ..\\FME\\2018\\metafile-file where one can parameterise the behaviour?
Question
SQLCreator forces uppercase attribute names
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 8394 replies
Oracle defaults to upper case column names unless you use double quotes to force the case, so this is not specific to FME. Since attributes in FME are case sensitive, they are created exactly as returned by Oracle.
Example using a column alias to force lower case in query result:
select my_column_1 as "my_column_1"
from my_tableWill be interpreted by Oracle as:
SELECT MY_COLUMN_1 AS "my_column_1"
FROM MY_TABLEYou can then expose my_column_1 in FME.