DSNTIAUL vs DSNUPROC(unload)

dannis · New User Joined: 14 Apr 2008 Posts: 4 Location: New York

As we know, the DSNTIAUL and the DSNUPROC can both unload data from DB2 table, so what's the difference between them?

Thanks & Regards
Dannis

Ken Rigby · Posted: Fri Apr 25, 2008 7:23 pm

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.