The first set of database user sessions in a BTEQ execution automatically adopts the default format specifications.
If changes are made to the format specifications during the first session, the second set of sessions within the same BTEQ execution inherits the format specifications as they exist at the end of the first set of sessions.
Subsequent sessions do not automatically revert to the default format specifications.