| Rob Waywell 2005-08-24, 1:23 pm |
| Take a look at the SET REMOTE OPTION statement:
(from the 9.0.2 docs)
ASA SQL Reference
SQL Statements
SET REMOTE OPTION statement [SQL Remote]
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
"TPS" <ts@scientexlc.com> wrote in message news:430b8009$1@foru
ms-2-dub...
> Can the table SYS.SYSREMOTEOPTION be modified by the dba or any user?
> I would like my extraction utility to set these values instead of the end
> user. Also,
> if the IP address of the FTP server would change how would you change this
> information?
>
> Table SYS.SYSREMOTEOPTION looks like:
>
> option_id user_id setting
> 1 110 (IP address)
> 2 110 (ftp user name)
> 3 110 (ftp directory)
> 4 110 (ftp user password)
>
>
> Thanks
> TPS
>
|