Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: FTP - GET command help
ftp bad, scp good
On Wed, Aug 08, 2001 at 01:22:29PM -0800, Ron Thomas wrote:
>
> get ${ORACLE_SID}_FTP_AR_DSN ....
>
> Ron Thomas
> Hypercom, Inc
> rthomas_at_hypercom.com
> "Either lead by example, or become a terrible warning"
>
>
>
>
> lannyue_at_yahoo
>
> .com To: ORACLE-L_at_fatcity.com
>
> Sent by: cc:
>
> root_at_fatcity. Subject: FTP - GET command help
>
> com
>
>
>
>
>
> 08/08/01
>
> 01:50 PM
>
> Please
>
> respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
> Hello, All:
> I can't find any reference about FTP syntax in UNIX shell script. Here is my problem
>and ask for
> help:
>
>
> On one server, we have couple of SID (this client setup can't be changed). Then in
>the ( Bourne
> Shell ) profile, we have for each SID:
>
>
> TBAE_FTP_AR_DSN='DS1B.XXXXX1.TIDE.XXXXX'
> export TBAE_FTP_AR_DSN
> -- where TBAE is ORACLE_SID name
>
>
> PBAE_FTP_AR_DSN='DS1B.XXXXX2.TIDE.XXXXX'
> export PBAE_FTP_AR_DSN
> -- where PBAE is ORACLE_SID name
>
>
> Then in the standard (one apply all) SHELL SCRIPT, we want to FTP to get the file
>with dynamicly
> changed (SID) file name in the script. I used:
> ftp -n $FTP_SITE_ADR2 << ENDFTP
> user $FTP_USER2 $FTP_USER_PASS2
> get ${ORACLE_SID}'_FTP_AR_DSN' $FTP_DIRECTORY/...
> ENDFTP
> I had try << get $ORACLE_SID'_FTP_AR_DSN' >> or << get '$ORACLE_SID'_FTP_AR_DSN'' >>
> But all get error message like:
> "Invalid data set name "TBAE'_FTP_AR_DSN'". Use MVS Dsname conventions."
>
>
> I know << get '$TBAE_FTP_AR_DSN' >> will work, but in this case SID has to be hard
>coded in each
> database, and this is not the way we want to go.
> Is there a way I can get SID variable in the FTP part? (the file name need to be
>exactly within ( '
> ) to work properly.
>
>
> Thanks for your help. Any one can tell me where I can find any the reference will
>also very helpful.
>
>
> Helen
>
>
>
>
>
>
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ron Thomas
> INET: rthomas_at_hypercom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- =============================================================== Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: stellr_at_stell.cns.vt.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Aug 08 2001 - 15:59:56 CDT