IBM Data Studio (Admin client) version 3.1.1

2019-09-04 11:05发布

Simple question that I can't find an answer to.

I am validating Data Studio (admin version) for use at our site. Most of it looks OK apart from trying to use the wizard to build row value SQL expressions such as

Update cmf a set (cftlvl,cfplvl) =
 (select cftlvl,cfplvl from fixes b where a.cffac=b.cffac and a.cfcset=b.cfcset and a.cfcbkt=b.cfcbkt and a.cfprod=b.cfprod)
where (a.cffac,a.cfcset,a.cfcbkt,a.cfprod) in (select cffac,cfcset,cfcbkt,cfprod from fixes)

The code runs fine but the wizard will not build the 'IN' clause properly. It will not accept a list of values in the predicate.

I can't find any documentation, anyone know if this is possible.

0条回答
登录 后发表回答