Ashok

Ashok

  • NA
  • 507
  • 80.2k

db2

Feb 18 2016 11:42 AM
hi 
i need script in db2 
i declared a variable IN pcontact varchar(50)
my requirement is if i enter partial value[ex:npn11] i need to get records based on partial value else if i entered full values with comma
seperated[more than one value ex:npn1101,npn1102]
i need to get records how to achieve this
ex:
---
IF pcontact <> '' THEN
SET pcontact = UPPER ( pcontact ) ;
SET where column IN (' || TRIM ( pcontact ) || ')' ;
END IF ; this is what we r using in current system so i need to implement both partil as well as comma seperated
 
Thanks