Am getting Progress openedge wire protocal driver[openedge] syntax error in sql statement at or about Select "accounts_"."Account". The full sql statment is
{select "Time_Dimension"."DB-NAME" "DB_NAME" , "Time_Dimension"."Year_" "Year_" , "Time_Dimension"."Monthkey" "Monthkey" , min("Time_Dimension"."Month_") "Month_"
from "DWH"."PUB"."Time_Dimension" "Time_Dimension"
group by "Time_Dimension"."DB-NAME", "Time_Dimension"."Year_", "Time_Dimension"."Monthkey"
select "Accounts_"."Account_", "Accounts_"."Account_Description_", "Entities_"."Entity_", "Entities_"."Entity_Name_", "Budget_Details"."Amount_SRC_", "Budget_Details"."VS_Planned_Bookings", "Budget_Details"."VS_Cost_Amt_", "Budget_Details"."DB-NAME", "Sub_Accounts_"."Sub_Account_", "Sub_Accounts_"."Sub_Account_Description_", "Budget_Details"."Fiscal_Year_", "Budget_Details"."Fiscal_Period_"
from "DWH"."PUB"."Accounts_" "Accounts_", "DWH"."PUB"."Entities_" "Entities_", "DWH"."PUB"."Budget_Details_" "Budget_Details", "DWH"."PUB"."Sub_Accounts_" "Sub_Accounts_"
where "Accounts_"."DB-NAME" = "Budget_Details"."DB-NAME" and "Accounts_"."Account_" = "Budget_Details"."Account_" and "Sub_Accounts_"."DB-NAME" = "Budget_Details"."DB-NAME" and "Sub_Accounts_"."Sub_Account_" = "Budget_Details"."Sub_Account_" and "Entities_"."DB-NAME" = "Budget_Details"."DB-NAME" and "Entities_"."Entity_" = "Budget_Details"."Entity_"}
Using progress openedge 10.1b. Any help would be greatly appreciated.
Thanks!!!
{select "Time_Dimension"."DB-NAME" "DB_NAME" , "Time_Dimension"."Year_" "Year_" , "Time_Dimension"."Monthkey" "Monthkey" , min("Time_Dimension"."Month_") "Month_"
from "DWH"."PUB"."Time_Dimension" "Time_Dimension"
group by "Time_Dimension"."DB-NAME", "Time_Dimension"."Year_", "Time_Dimension"."Monthkey"
select "Accounts_"."Account_", "Accounts_"."Account_Description_", "Entities_"."Entity_", "Entities_"."Entity_Name_", "Budget_Details"."Amount_SRC_", "Budget_Details"."VS_Planned_Bookings", "Budget_Details"."VS_Cost_Amt_", "Budget_Details"."DB-NAME", "Sub_Accounts_"."Sub_Account_", "Sub_Accounts_"."Sub_Account_Description_", "Budget_Details"."Fiscal_Year_", "Budget_Details"."Fiscal_Period_"
from "DWH"."PUB"."Accounts_" "Accounts_", "DWH"."PUB"."Entities_" "Entities_", "DWH"."PUB"."Budget_Details_" "Budget_Details", "DWH"."PUB"."Sub_Accounts_" "Sub_Accounts_"
where "Accounts_"."DB-NAME" = "Budget_Details"."DB-NAME" and "Accounts_"."Account_" = "Budget_Details"."Account_" and "Sub_Accounts_"."DB-NAME" = "Budget_Details"."DB-NAME" and "Sub_Accounts_"."Sub_Account_" = "Budget_Details"."Sub_Account_" and "Entities_"."DB-NAME" = "Budget_Details"."DB-NAME" and "Entities_"."Entity_" = "Budget_Details"."Entity_"}
Using progress openedge 10.1b. Any help would be greatly appreciated.
Thanks!!!