Select

Teradata Developer Guides

ft:locale
en-US
ft:lastEdition
2026-08-18

<db:select>

This operation queries data from a database. To prevent loading all the results at once, which can lead to performance and memory issues, results are automatically streamed. This means that pages of fetchSize rows are loaded when needed. If this operation is performed inside a transaction (that is, within a Try scope component) and that transaction is closed before consuming the data, accessing the results that haven't been loaded will fail.