MVSFORUMS.com

swaasum · Beginner Joined: 14 Jun 2004 Posts: 2 Topics: 2

Hi,
We have a requirement, where a fixed list of fileds should be selected through Sql and get the output in different ORDER BY clause every time.(Dynamically building the ORDER BY clause based on some user input through an array).
How to write dynamic sql to have a variable ORDER BY clause driven through an array? Any suggestions are welcome on to achieve this?

Thanks
_________________
Raj

kolusu · Posted: Mon Jun 14, 2004 12:00 pm Post subject:

Swaasum,

Please search before posting. Check this links

http://www.mvsforums.com/helpboards/viewtopic.php?t=2002

Coding dynamic SQL in application programs

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu