ibm mq - How can I create procedure in ESQL for select data from database -

i want able enter bankid xml file , if record exist have integer result,if doesn't should display result

my code written in ibm web sphere message broker toolkit

please me simple problem!!!!

try this:

set environment.variables.bankid =the( select bankid,                                                           database.yourschema.yourtable somecondition=true);       if exists(environment.variables.bankid[])     set outputroot.xmlnsc.bankid=  environment.variables.bankid[1] ; else     set outputroot.xmlnsc.bankid='something else';  end if;