MVSFORUMS.com

[sraj]

Select col1, col2, col3
from table 1
order by col1 <ASC/DESC>, col2 <ASC/DESC>, col3 <ASC/DESC>

The sort order for col1, col2, col3 are parameters to the program. Can anyone explain how to parametrize the sort order without using a dynamic sql.

[dbzTHEdinosauer]

i can't.
_________________
Dick Brenholtz
American living in Varel, Germany

[jsharon1248]

Why would you want to complicate the SQL and/or the program to avoid dynamic SQL? Try it. You'll like it. 8)

[sraj]

[videlord]

I'm not sure i'm understand your question
but can you try
select col1, col2, ....
order by 1, 2, ...