where param_name is the name of the parameter. From this query we will get the assp_id corresponding to the parameter. With this id we look up into app_subsys_parmval table to get the value of the parameter.

Now instead of separately launching the two sql statements , I want to combime both of them as one is there any sub query or join mechanism that can combine both of them in one statement , please advise

You're using a string with 'true' in it? If you're on a version that doesn't support a logical type (LUW, say), I think I'd rather go with a 1/0 combination (or character '1'/'0'). Or, probably better yet, make a user-defined type.
–
Clockwork-MuseJul 11 '12 at 22:41

@Sebas Because the original answer was a useless placeholder that only said Use a subselect in your update statement. It was only edited to include content after the downvotes.
–
Michael BerkowskiJul 11 '12 at 18:06

1

Downvote = "This answer is not useful." "Use a subselect in your update statement" is barely useful, at best. It's also not a good approach to the problem, but that's a technical issue.
–
FlimzyJul 11 '12 at 18:10