How can I pass a file name in a variable to an SQL statement?

I have tried:

TEST=HOTEL"

EXEC SQL SELECT * FROM :TEST;

I need to be able to do this as a client selects a file from a list, to work with, and the file name is passed in a variable to all routines.

Any assistance will be greatly appreciated.

Thanks, Mark

View this thread on the forum...