Requirements for Specifying Output File Block Size | Basic Teradata Query - 17.00 - Specifying Output File Block Size - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

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