I was wondering if there's a way to execute Insert/Select statements like the one below using the LLBL clases.

insert into app.cp_acct
  (cd_acct
  ,ds_acct
  ,cd_period
  ,cd_bussiness )
select cd_acct
  ,ds_acct
  ,'2010/04'
  ,cd_bussiness 
from app.cp_acct a
where a.cd_bussiness = '001'
  and a.cd_period = '2010/04'

T.I.A.

In short, no. In that case is better to use an stored procedure.

Thanks!!!

Regards,