TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
0
)
Employee Spend overtime increse salary double then norma sa
How to get 7 days before today date in mysql?