Hi,
because of a problem we found in our software, we were expecting to the fp8.15
after installing that version, we found a problem in WSAD.
When trying to make a connection to the DB via WSAD, it has errors.
It tries to make this select (for building the DB in WSAD):

SELECT PROCSCHEMA, PROCNAME,
SPECIFICNAME, DEFINER, PARM_COUNT, DETERMINISTIC,
FENCED, LANGUAGE, IMPLEMENTATION,
CLASS, JAR_SCHEMA, JAR_ID,
PARM_STYLE, CONTAINS_SQL, PROGRAM_TYPE,
RESULT_SETS, REMARKS, COLLID, WLM_ENVIRONMENT, BUILDSCHEMA, BUILDNAME
BUILDOWNER, PRECOMPILE_OPTS, COMPILE_OPTS, JCOMPILE_OPTS, PRELINK_OPT
LINK_OPTS, BIND_OPTS, JBUILDSCHEMA, JBUILDNAME,
JBUILDOWNER, JBIND_OPTS
FROM (SELECT PP.SCHEMA AS PROCSCHEMA,
PP.NAME AS PROCNAME, SPECIFICNAME, PP.CREATEDBY AS DEFINER,PARM_COUN
+ RESULT_COLS AS PARM_COUNT, DETERMINISTIC, FENCED, LANGUAGE,
EXTERNAL_NAME AS IMPLEMENTATION, CLASS, PP.JARSCHEMA AS JAR_SCHEMA,
PP.JAR_ID, PARAMETER_STYLE AS PARM_STYLE, SQL_DATA_ACCESS AS
CONTAINS_SQL, PROGRAM_TYPE, RESULT_SETS, REMARKS, PP.COLLID AS COLLID
WLM_ENVIRONMENT, OPTS.BUILDSCHEMA, OPTS.BUILDNAME, OPTS.BUILDOWNER,
PRECOMPILE_OPTS, COMPILE_OPTS,
HPJCOMPILE_OPTS AS JCOMPILE_OPTS, PRELINK_OPTS, LINK_OPTS,
OPTS.BIND_OPTS, JJ.BUILDSCHEMA AS JBUILDSCHEMA, JJ.BUILDNAME AS
JBUILDNAME, JJ.BUILDOWNER AS JBUILDOWNER, JJ.BIND_OPTS AS JBIND_OPTS
FROM SYSIBM.SYSROUTINES
PP LEFT OUTER JOIN SYSIBM.SYSROUTINES_OPTS OPTS ON
(PP.SCHEMA = OPTS.SCHEMA AND PP.NAME = ROUTINENAME) LEFT OUTER JOIN
SYSIBM.SYSJAVAOPTS JJ ON
(PP.JARSCHEMA = JJ.JARSCHEMA AND PP.JAR_ID = JJ.JAR_ID)
WHERE ROUTINETYPE = 'P') AS TEMP WHERE ( PROCSCHEMA IN ())
ORDER BY
PROCSCHEMA, PROCNAME FOR FETCH ONLY

This statement fails on -104 because of that: ( PROCSCHEMA IN ())
the paranthesis for the IN are emty.
This failure causes the WSAD not to build the objects in the DB. The DB stays empty.
With DB2 Client v7.10 there is no problem.

The issue is that this statement comes from the WSAD, and i don't understand why the changing of db2 client version affects it.

I would really be happy to hear some ideas.

Thanks,
Ma'ayan.