Rumba AS400 - Field Descriptions & Members
I downloaded the evaluation version of WinSQL.
WinSQL Version: 5.5.x.x
Company Name: Ring 9
I would like to know why I do not get the field descriptions from the DB2 in the catalog.
I also need to know how to override the member name and select specific member when
openeing a db2 file.
I am also having trouble making the syntax transition from ms-sql to win-sql-92 with
regard to string handling (substring(), CAST, Convert) and numeric calculations.
If there a tutorial for this?
I get a syntax error trying use a calculated result field in a WHERE or GROUP BY clause.
Example:
select
bfnpa,bfnxx,bfline, count(bbatch) as calls
from error
where bflags like 'I %' and Berror <> 3 and calls > 25
group by bfnpa,bfnxx,bfline
order by calls desc
Error: Syntax error or access violation. SQLSTATE = 42703 : The column is not
in the specified table(s). SQLCODE = -206 : Column CALLS not in specified tables.
(State:42000, Native Code: FFFFFF32)
