Joined: 24 Apr 2008 Posts: 1 Location: Valley Forge, PA
The major difference is in what you can run, and what you can run against. DSNUPROC is for straight selects, and works on a TABLE or TABLESPACE.
DSNTIAUL will run any SQL statement, including a JOIN, that can be executed by DB2. And, it will run against any VIEW.
We use DSNTIAUL because it can run against a VIEW, which eliminates some security issues. The feature of having it run against a JOIN, and that it can use all of the functions in DB2 is quite nice as well.