cannot specify a column name
this is no bug as you simply need to go to the
edit-->option
there you will find an option saying ,
terminators must be on a new line.
you simple put a check on it and see that your problem gets resolved.
>A table has a column name of 'CATEGORY', if I include that category specifically
on
>a select, the SQL fails. For example:
>
>"select * from psfdvlp.ps_depr_rpt;" returns all rows of the table.
>
>"select category from psfdvlp.ps_depr_rpt;" give the following errors:
>Error: SQL0199N The use of the reserved word "FETCH" following "" is not valid.
>Expected tokens may include: ", FROM INTO ". SQLSTATE=42601
> (State:42601, Native Code: FFFFFF39)
>Error: SQL0104N An unexpected token "PSFDVLP" was found following "". Expected
tokens
>may include: "IS ". SQLSTATE=42601
> (State:42601, Native Code: FFFFFF98)
>
>I can run this same SQL successfully via DB2/connect
