User guide

DescriptionDefault
Value
Matching
Postgr-
eSQL op-
tion ex-
ists?
ODBC Option
When this option is enabled (1), the driver returns TEXT
columns as LONG VARCHAR data.
When this option is disabled (0), the driver returns TEXT
columns as TEXT data.
0YesTex-
tAsLongVarchar
The user name to use to connect to the Amazon Red-
shift server.
YesUID
When this option is enabled (1), the driver returns a
specific number of rows at a time. To set the number
of rows, use the Fetch option.
When this option is disabled (0) and SingleRowMode
is enabled (1), the driver returns query results one row
at a time. If SingleRowMode is also disabled (0), then
the driver retrieves the entire query result into memory.
Note
If UseDeclareFetch is enabled, then Use-
DeclareFetch takes precedence over Sin-
gleRowMode and UseMultipleStatements.
0YesUseDeclareFetch
When this option is enabled (1), the driver can run
queries that are split into separate statements.
When this option is disabled (0), the driver runs queries
as single statements.
Note
If UseDeclareFetch is enabled (1), then Use-
DeclareFetch takes precedence over
UseMultipleStatements. If UseDeclareFetch
is disabled (0) but SingleRowMode is enabled
(1), then SingleRowMode takes precedence
over UseMultipleStatements.
0NoUseMultipleState-
ments
The same information as UID (the user name to use to
connect to the Amazon Redshift server). If UID is
defined, then UID takes precedence over Username.
YesUsername
API Version 2012-12-01
157
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift