Are there any differences b/w the multiple sessions that are invoked through BTEQ and loader utilities. If so, what are they.
.set sessions 3.repeat 3database 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.