Re: ODBC Connection

[Steve Hall <srh@CONVOY.COM>]

 

You can put -DB in your BEGIN-SELECT statement. Look up BEGIN-SELECT in yr sqr help file.

 

 

-DBconnection string - (ODBC) Specifies the ODBC connection string for this SELECT paragraph only.  A conection string has the following syntax:

 

DSN=data_source_name[ ;keyword=value[ ;keyword=value ;...]]]

 

For example, a connection string for an Oracle data source named "ora7" might look like the following:

 

'DSN=ora7;UID=scott;PWD=tiger'

 

 

 

 

Function

 

Begins a SELECT paragraph.  A SELECT paragraph is the principal means of retrieving data from the database and printing it in a report.  A SELECT paragraph must be inside a PROCEDURE or PROGRAM section

 

Syntax

 

BEGIN-SELECT  [ DISTINCT ]  [ -Cnn ]  [ -Bnn ]  [ -XP ] [ -NR ]  [ -SORTnn ] 
[ -LOCK { RR | CS | RO | RL | XX } ] [ -DBdatabase ]  [ -DBconnection_string ] [LOOPS=nn ] 
[ ON-ERROR=procedure [ ( arg1 [, argi ] ... ) ] ]

 

END-SELECT

 

Note: When arguments span multiple lines, terminate the first line with the continuation character (-) or indent the argument on the following line.  Otherwise, the argument on the following line will be misconstrued as a SELECT column.

 

 

-----Original Message-----
From: Discussion of SQR, SQRIBE Technologies's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Robert Stojkovic
Sent: Friday, September 17, 1999 9:25 AM
To: Multiple recipients of list SQR-USERS
Subject: ODBC Connection

Hello.

 

What would be the proper syntax to open and ODBC connection to another database within and SQR.

 

Robert