Hi Bill,

It's hard to say without seeing the SQL you used to create the tables 
and the SQL of the query which is failing. You may have another 
capitalization problem here: column names obey the same casing rules as 
table names.

Hope this helps,
-Rick

Wildman wrote:
> After having fixed the table name capitalization problem, when I attempt to
> execute the CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE call, I get this error:
>
> java.sql.SQLException: The exception 'java.sql.SQLException: Column
> 'COLUMN2' is either not in any table in the FROM list or appears within a
> join specification and is outside the scope of the join specification or
> appears in a HAVING clause and is not in the GROUP BY list. If this is a
> CREATE or ALTER TABLE  statement then 'COLUMN2' is not a column in the
> target table.' was thrown while evaluating an expression.
>         at
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
> Source)
>
> This is quite a helpful error message, yes? Can anyone help in interpreting
> it?
>
> Thanks!
> -Bill
>
>