Results 1 to 2 of 2

Thread: Sqlstate=42703

  1. #1
    Join Date
    Sep 2005
    Posts
    4

    Unanswered: Sqlstate=42703

    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?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You've created your table with case-sensitive column names, so you've got to use such column names from now on:
    Code:
    ...where "ProcessName" = 'ABC'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •