Creating a BBj Record Set


To create a BBj Record Set, follow the instructions below:

  1. Add a record set to the resource by through one of the following methods:

  • On the Main toolbar, click the Record Set button

  • On the Edit menu, select Add Record Set (BBj only)

  • On the tree view, click the BBj Record Set icon, right-click to display the context-sensitive menu, then click Add

  1. A window containing a blank record set appears and a corresponding record set icon displays in the tree view.

  2. To define the record set, display its properties page and enter the following information:

  • Enter a text string into the Name box to define the record set name that will appear in the tree view. An unique record set name is set by default.

  • Enter a number into the Record Set ID box to define the record set id that will appear in the tree view. An unique record set id is set by default.

  • Select the type of record set, either SQL or File, in the Record Set type selection box. This can also be set by selecting the appropriate radio button in the BBj Record Set window under the Record Set Type tab.

  • Enter any mode information into the Mode box. This can also be set by entering the mode information into the mode edit box in the BBj Record Set window under the Mode tab.

  • If this is an SQL record set, enter the SQL connect string, which will be invoked to connect to desired database in the SQL Connection String. This can also be set by entering the SQL connect string into the SQL Connect String edit box or building this string by selecting the Build button in the BBj Record Set window under the Record Set Type tab.

If the Build button is selected, then the SQL Setup dialog will display. In this dialog, select one of the following radio buttons that corresponds to the appropriate database type:

  • BBj Database

  • ODBC Data Source

  • JDBC connection

If the BBj Database radio button is selected, enter the database name into the Database Name edit box or press the Query Button to query the database that a local or remote BBjServices has access to. If the selecting the Querybutton, enter the Host, Admin Port, User, and Password to connect to the BBj Service. Press the Query Databases button, the returned Databases will be listed in the Databases list box. Select the desired database and then press the OK button.

If the BBj Database was selected via the Query button, then all required information is automatically filled into the appropriate edit box for the BBj Database. If not, enter the database name into the Database Name edit box, enter the host into the Host edit box, enter the sql server port into the SQL Server port edit box, enter a valid user into the User edit box, and enter a valid password into the Password edit box.

If the ODBC Data Source radio button is selected, enter the name of the ODBC data source into the Data Source edit box or press the Browse button and select the appropriate data source from the list box under the User DSN, System DSN, or File DSN tab.

If the JDBC Connection radio button is selected, enter the JDBC driver class into the Driver Class edit box, and enter the JDBC connection string into the Connection String edit box.

  • If this is an SQL record set then enter the select string , which will be invoked to retrieve the desired records in the SQL Command box. This can also be set by entering the SQL connect string into the SQL Command Text edit box in the BBj Record Set window under the SQL Command tab.

  • If this is a File record set, enter the file name into the File Name box. This can also be set by entering the file name into the File edit box or by selecting the Browse button and selecting the appropriate file in the BBj Record Set window under the Record Set Type tab.

  • If this is a File record set, enter the file template, which describes the fields of the file into the File Template box. This can also be set by entering the file template into the Template edit box or by pressing the Select button in the BBj Record Set window under the File Template tab. If the Select button is pressed, the Template Selection dialog will appear, enter the Host, Admin Port, User, and Password to connect to the BBj Service which has access to the file. Press the Get Template button, the returned template for the specified file will be returned in the Template edit box. Press the OK button to select the template.