diff b/w multiple sessions invoked through BTEQ and loader utilities

General
Enthusiast

diff b/w multiple sessions invoked through BTEQ and loader utilities

Hi Experts,

Are there any differences b/w the multiple sessions that are invoked through BTEQ and loader utilities.  If so, what are they.

eg:

.set sessions 3

.repeat 3

database teraprod;

which assigns the default database as teraprod for all 3 sessions.  Are there any differences in parsing bteq sessions and loader utility sessions?

How the sorting is performed globally (data from all/more AMP's)

and how multiple sessions communicate with each other start from sending a query and sending the resultant to user.  Can you please name the reference material that encompasses these information.