<< Click to Display Table of Contents >> Current:  Create Data Set > SQL Data Set > Data Set for Stored Procedure  DB2 Database

1) Click the quick start shortcut of Yonghong Z-Suite.

 

2) Open the browser and enter http://hostname:8080/bi/Viewer in the address bar to log in to the client. The hostname here refers to your machine name. For local visit, you can use localhost. 8080 is the default port number. If the default port number is changed during installation, type in the correct port number.

 

3) Enter username and password and then log in the homepage.

 

4) Click "Create Data Set" to enter the page for creating a data set.

 

5) If the syntax created at background is as follows:

create procedure pro_char1

(

in in_char char(10), 

out out_char char(10),

in in_varchar varchar(10), 

out out_varchar varchar(10)

)

dynamic result sets 1 

language SQL

 

P1: begin

set out_char = in_char;

set out_varchar = in_varchar; 

end P1

 

6) The table options in query will display all stored procedures. Fill out the following statements in SQL statement:

Call PRO_CHAR1(?{IN_CHAR},?{OUT_CHAR},?{IN_VARCHAR},?{OUT_VARCHAR})

 

7) Click "Parameter" to set data types and directions for each parameter. The direction of each parameter should be consistent with the direction of the database parameter.

 

8) Refresh the parameters and then preview the data.