Specifying Output File Block Size

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

When defining output files, specify a BLKSIZE that is large enough to accommodate the expected results.

Job Type Block Size
Single interactive mode session 1024K
Single-session batch job 1024K
Large, multi-session job 4096K