Whenever i create a table by using "Create suitable Table", i get the table created with the column names in double quotes.
CREATE TABLE "TEST"."IC_RFR_TEST_PHASE41" (
"REVENUE" DECIMAL(31 , 3))
So when i try to select columns using select query,
SELECT PRJ_ID FROM TEST.IC_RFR_TEST_PHASE41
It doesnt work. i have to give like
SELECT "PRJ_ID" FROM TEST.IC_RFR_TEST_PHASE41.
Is there any way to avoid this????
While the columns are renamed, i dont get this problem.
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
SystemAdmin 110000D4XK203 Posts
Re: Column Name with "2012-10-09T07:47:56ZThis is the accepted answer. This is the accepted answer.Hi,
I guess it's because the output column names were somehow surrounded by "". Then when you perform <create suitable table>, the "" will be kept and thought as part of the column name.
If you want to avoid this situation, please check the output column names of the operator where you performed <create suitable table> action.