Versions Compared

Old Version 2

changes.mady.by.user Fabiola Arias Navia

Saved on

compared with

New Version Current

changes.mady.by.user user-ff8ce

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For more information about the SQL database activities, refer to the description of the SQL_CONNECT activity.  For a list of supplied working (*) examples using the SQL database activities, refer to:

Example Processing Sequences using the SQL database activities

INPUT Parameters:

SQLHANDLE: Required

This parameter must specify the connection handle value that identifies the SQL connection upon which this activity should operate.  The connection handle value is returned by the SQL_CONNECT activity.

SQLQUERY: Required

This parameter must specify the SQL SELECT statement that will execute on the target database for the query.  The following are examples of SQL SELECT statements that might be specified in this parameter:

...

Sometimes a single value may not be sufficiently large to hold your query, or it may be more convenient to construct your query part-by-part.  For these reasons, this parameter is defined as a variable list.  This means that you can split your long SQL statement into more than one part and provide the parts in this parameter using a variable list.  If you do this, then the SQL_QUERY activity will re-assemble them into a single statement before execution.

SQLMAXROWS: Optional

This parameter specifies a maximum number of rows to be returned.  This guards against the possibility of SELECT statements that select much more data than was intended.

If not specified, a default value of 100 (one hundred) is used.  Remember that the SQL database activities are not intended and not usually suitable for high-throughput, high-volume database operations.  If you expect that your query will return a large number of records, then you should possibly consider an alternate implementation, such as using a Transformation Map.

OUTPUT Parameters:

SQLROWS:

Upon successful completion, this parameter will contain the actual number of rows returned by the query.

SQLCOLUMN1
SQLCOLUMN2
…
SQLCOLUMN25

These output lists will contain a list of the values for the corresponding column for each row selected by the query.

...