Example query IBM Spufi

results set

typical result type of query.

-----------+-----------+-----------+-----------+
first_name last_name date_joined
-----------+-----------+-----------+-----------+
joe briggs 2001-10-01
bob brown 2002-05-06
fred brown 2000-01-03
-----------+-----------+-----------+-----------+
number of rows affected 3
statement execution successful, sqlcode 0
-----------+-----------+-----------+-----------+

the output dataset contains resultant rows(in case of select) along additional details number of rows affected sql query, sqlcode returned on execution of sql query. in case of sql errors details error given.