Allow for scripts to select data and return resultset to console output for logging purposes

[shantstepanian]

Example: to keep track of purging rows from a table that might take a while. We should think about whether to enable this by default for all cases

Consider doing this alongside #59

/* CREATE TABLE */
CREATE TABLE album(
  Id int identity,
  title VARCHAR(100),
  artist VARCHAR(100)
)

/* POPULATE TABLE in 1 minute with 100k rows */
declare @mycount int
select @mycount=1
while  (@mycount < 100000)
begin
insert into album values ('title_'+ str (@mycount) ,'artist_'+ str(@mycount))
select @mycount=@mycount+1
end

/* PURGE TABLE WHERE id < 50000 in 10 batches of 5000*/
declare @rows int
declare @RetCode int
select @rows=1, @RetCode=0
SET ROWCOUNT 5000
WHILE (@rows !=0 and @RetCode=0)
BEGIN
        delete album where Id <= 50000
        select @rows=@@rowcount, @RetCode=@@error
        select “Album Purge”, getdate(), @rows, @RetCode
END

(5000 rows affected)
(1 row affected)                                                                     
 ----------- ------------------------------- ----------- ----------- 
 Album Purge             Jul 20 2017  4:20PM        5000           0 

(1 row affected)
(5000 rows affected)
(1 row affected)                                                                    
 ----------- ------------------------------- ----------- ----------- 
 Album Purge             Jul 20 2017  4:20PM        5000           0 

(1 row affected)
(5000 rows affected)
(1 row affected)                                                                  
 ----------- ------------------------------- ----------- ----------- 
 Album Purge             Jul 20 2017  4:20PM        5000           0 

(1 row affected)
(5000 rows affected)
(1 row affected)                                    
 ----------- ------------------------------- ----------- ----------- 
 Album Purge             Jul 20 2017  4:20PM        5000           0 

(1 row affected)
(5000 rows affected)
(1 row affected)
----------- ------------------------------- ----------- ----------- 
 Album Purge             Jul 20 2017  4:20PM        5000           0

[shantstepanian]

Example to verify this on in DB2: CALL SYSPROC.ADMIN_MOVE_TABLE