Rockwell Automation RSBizWare Administration Guide User Manual

Page 299

Application notes for FactoryTalk Transaction Manager Appendix D

SELECT @loop = @loop + 2

END --GREAT BIG WHILE LOOP

END-- proc

FactoryTalk Transaction Manager can write to a controller a data

block consisting of integers selected from multiple rows of a table.
The stored procedure reads four integers (ints) from a database table
and concatenates them in a binary (varbinary) stream, which is then
bound to a data block in FactoryTalk Transaction Manager.

NOTE

The stored procedures only accept positive integers from 0 to 32,767.

Following is a sample creation table from which data can be
retrieved:

CREATE TABLE my_next_int_table (int1 INT,int2 INT,int3 INT,int4
INT,record_row INT)

INSERT INTO my_next_int_table values (1,2,3,4,1)

INSERT INTO my_next_int_table values (21,22,23,24,2)

INSERT INTO my_next_int_table values (31,32,33,34,3)

INSERT INTO my_next_int_table values (41,42,43,44,3)

INSERT INTO my_next_int_table values (5001,5002,5003,5004,3)

INSERT INTO my_next_int_table values (6001,6002,6003,6004,4)

INSERT INTO my_next_int_table values (7001,7002,7003,7004,4)

INSERT INTO my_next_int_table values (8001,8002,8003,8004,4)

INSERT INTO my_next_int_table values (9001,8002,8003,8004,4)

INSERT INTO my_next_int_table values (8001,8002,8003,8004,4)

INSERT INTO my_next_int_table values (6001,8002,8003,8004,4)

Sending data blocks from
multiple rows in a table using
Integer data

Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014

299