Re: my problem

[Mike Morgan <MMorgan@MELLON-INVESTOR.COM>]

         I was wondering if it was possible to open an FTP session and PUT a
file onto an FTP server
> through SQR?  Has anyone done this/seen this done?  Have the code
> required?  Thanks.
>
>       -----Original Message-----
>       From:   Paul Hoyte [SMTP:phoyte@SHARIDIONNE.COM]
>       Sent:   Wednesday, January 03, 2001 9:38 AM
>       To:     SQR-USERS@list.iex.net
>       Subject:        Re: my problem
>
>       Try this solution that was provided by "FRANCK MASSON" another user
> on the list.....
>
>       try something like this
>
>       Begin-Procedure Main
>
>       Begin-Select -DB'DSN=Sales;UID=scott;PWD=tiger'
>
>       Ename, Job, Hiredate, Sal, Commission
>
>       Do Insert
>
>       >From Emp
>
>       End-Select
>
>       End-procedure ! Main
>
>       Begin-procedure Insert
>
>       Begin-SQL -DB'DSN=Archive'
>
>       insert into EmpArch (ename, job, hiredate, sal,
>
>       commission) values (&Ename, &Job, &Hiredate, &Sal,
>
>       &Commission)
>
>       End-SQL
>
>       End-Procedure ! Insert
>
>
>
>       Paul Hoyte
>       Sharidionne, Inc.
>       (248) 559-6868
>       www.sharidionne.com
>       phoyte@sharidionne.com
>
>               -----Original Message-----
>               From: Discussion of SQR, Brio Technology's database
> reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of
> Chandrashekhar.A.M
>               Sent: Thursday, January 04, 2001 5:42 AM
>               To: SQR-USERS@list.iex.net
>               Subject: my probelm
>
>
>               hi all
>                   I am working on SQR ver 5.0 with back end oracle 7.3 on
> windows.
>               Now what is my problem is that I have two or three different
> ODBC Data Source Names. and i want to use these DSN's in a single program.
> but while running SQR program it will ask one DSN after that how can i
> change to another schema or DSN.
>
>               thanks in advance
>               chandru
>
>
>
**************************************************************
NOTICE: The information contained in this e-mail is confidential and may be
privileged or otherwise protected from disclosure.  This e-mail is intended
solely for the use of the named addressee.  Please be aware that any other
use, printing, copying, disclosure or dissemination may be subject to legal
restriction.  If you are not the intended recipient, please notify us
immediately by return e-mail to the sender.