I have created a table, using the following script:
CREATE TABLE KRISHNSA.RB_Report_Schedule
(
"ProcessName" VARCHAR(30) NOT NULL,
"Monday" VARCHAR(1) NOT NULL,
"Tuesday" VARCHAR(1) NOT NULL,
"Wednesday" VARCHAR(1) NOT NULL,
"Thursday" VARCHAR(1) NOT NULL,
"Friday" VARCHAR(1) NOT NULL,
"Saturday" VARCHAR(1) NOT NULL,
"Sunday" VARCHAR(1) NOT NULL,
"WeekTime" INTEGER,
"WeekendTime" INTEGER,
"SQL" VARCHAR(2500) NOT NULL,
"LastProcessed" Date
)
The table is created fine, no problems at all.
When I run the following SQL query, it works fine:
Select * from KRISHNSA.RB_Report_Schedule
But when I run the following query:
Select * from KRISHNSA.RB_Report_Schedule WHERE ProcessName = 'ABC'
I get the following error:
[IBM][CLI driver][DB2/NT] SQL0206N 'PROCESSNAME' is not vallid in the context where is is used. SQLSTATE=42703(42S22,-206)
Anyone ever come across this before?