Im after some advice about my program startup. I have tables stored in 3 different locations in which users will access in my application. I have use the SET PATH command to state the locations to where these tables are. But when I try to open the table it looks at the default location and say it cant find it. Can anybody please advise me on how I should use SET DEFAULT and SET PATH in my application.

When the user logs in I create a user home directory store in a profile directory. Should I be setting the SET DEFAULT to this for each user?

Many thanks