1. First we need to create script for single use test

2. Datapools are created

3. Script are edited whih will work for large number of data

Firstly You have to set a user/system DSN in your system which is invoked in rational by using SQAbasic commands.

SQLOpen() function establishes the connection

SQLExecQuery() function will execute the query using connection established.SQLRetrieve( ) function is used to retrieve the result of the query & store it in array form.

First You have to make SYSTEM DSN .For that follow this

Start -> settings -> control panel -> Administrator Tools -> Data Sources(ODBC) : then click on SYSTEM DSN and create your DSN.(For this U have to create your database in MS-access or SQL server 2000 as per ur choice.)

then use this code

' Dim connection As Long
' Dim destination(1 To 50 1 To 125) As Variant
' Dim retcode As long
' Dim query as String
' Dim outputStr as String

' connection SQLOpen( DSN master1 outputStr prompt: 1)
' query select * from data1 'Execute the query
' retcode SQLExecQuery(connection query)
' msgbox retcode

This last stmt shows you the retcode id connection successfully establised the a positive code will retured else negative code will be there.