Re: ODBC in SQRs

["Schelske, Steve K." <SKSchelske@AAAMICHIGAN.COM>]

I agree with Elvis.  I don't think you should need to specify the -DB.

In terms of your problem, I believe each column name must be on a separate
line in starting in column 1 in a BEGIN-SELECT.

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Elvis Pressly
Sent: Friday, October 05, 2001 1:26 PM
To: SQR-USERS@list.iex.net
Subject: Re: ODBC in SQRs


I assumed that your database reside in AS400 then you really do not
need to use -DB connectivity unless you want to get a table from
different database. Your DSN should already been configured thru
ODBC admin using client access ODBC driver (for AS400) or any ODBC
driver suited for a particular platform like ORACLE.

One thing I notice in your select statement is the

        FROM DBATEST.FIT_HR_PROF_CHGS   <<<

Can please explain to me what DBATEST is?


>From: Les Brugere <Les_Brugere@AISMAIL.WUSTL.EDU>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Re: ODBC in SQRs
>Date: Fri, 5 Oct 2001 11:26:13 -0500
>
>Elvis,
>
>Thank you for the tip.
>
>I did try the ticks but I am still getting the same error.
>
>Do you know if there are environment variables that must be setup within
>the SQR
>for MVS/DB2/AS400  or within a delivered SQC?
>
>Thanks again,
>Les
>
>
>
>
>Elvis Pressly <elvisdman@HOTMAIL.COM> on 10/05/2001 11:15:33 AM
>
>Please respond to sqr-users@list.iex.net
>
>To:   SQR-USERS@list.iex.net
>cc:    (bcc: Les Brugere/Systems/ais)
>
>Subject:  Re: ODBC in SQRs
>
>
>
>It has to be something like this:
>
>BEGIN-SELECT -DB'DSN=FIDTFSRL;UID=WPUSTST;PWD=PSHR'
>
>You can also read the SQR manual for more information.
>
>
> >From: Les Brugere <Les_Brugere@AISMAIL.WUSTL.EDU>
> >Reply-To: sqr-users@list.iex.net
> >To: SQR-USERS@list.iex.net
> >Subject: ODBC in SQRs
> >Date: Fri, 5 Oct 2001 09:48:10 -0500
> >
> >Hello,
> >
> >I'm attempting to access a DB2 database using the ODBC command as
>follows:
> >
> >BEGIN-SELECT -DBDSN=FIDTFSRL;UID=WPUSTST;PWD=PSHR
> >Z.ROW_IDENT &Z.ROW_IDENT
> >FROM DBATEST.FIT_HR_PROF_CHGS Z
> >END-SELECT
> >
> >The IBM DB2 ODBC DRIVER is installed and the DSN is called FIDTFSRL.
>The
> >platform is NT/SQL Server.
> >
> >I continue to recieve this error:
> >
> >(SQR 1303) Error in SQL (perhaps missing &name after expression):
> >SELECT ROW_IDENT  FROM DBATEST.FIT_HR_PROF_CHGS
> >(SQR 1304) Check SELECT columns, expressions and 'where' clause for
>syntax.
> >
> >SQR: Program Aborting.
> >
> >I also used the following 2 variations of the code resulting in the same
> >error
> >as above:
> >
>
>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> >BEGIN-SELECT -DBDSN=FIDTFSRL;UID=WPUSTST;PWD=PSHR
> >ROW_IDENT &Z.ROW_IDENT
> >FROM DBATEST.FIT_HR_PROF_CHGS
> >END-SELECT
> >
>
>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> >BEGIN-SELECT -DBDSN=FIDTFSRL;UID=WPUSTST;PWD=PSHR
> >ROW_IDENT
> >FROM DBATEST.FIT_HR_PROF_CHGS
> >END-SELECT
> >
> >Any thoughts are greatly appreciated!
> >
> >Thanks,
> >Les
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp