-2

I want to be able to enter a BankID into XML file and if record is exist then have integer result,if doesn't should display another result

My code is written in IBM web sphere message broker toolkit

Please help me about this simple problem!!!!

Jonathan Leffler
  • 730,956
  • 141
  • 904
  • 1,278
Sina Zeinali
  • 15
  • 2
  • 11

1 Answers1

1

Try this:

SET Environment.Variables.BankId =THE( SELECT BankId,                                          FROM 
                Database.YourSchema.YourTable where somecondition=true); 

    IF EXISTS(Environment.Variables.BankId[]) THEN
    SET OutputRoot.XMLNSC.BankId=  Environment.Variables.BankId[1] ;
ELSE

   SET OutputRoot.XMLNSC.BankId='SOMETHING ELSE';

END IF;
nitgeek
  • 1,250
  • 12
  • 20
  • THANKS FOR YOUR ANSWER CAN you please say to me how can I use two option for search it on db not only use BankID , for example use bankid include bankName – Sina Zeinali May 06 '13 at 15:04