Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: FTP - GET command help
Thanks, But the thing is that the file name for GET need to be in ( ' ), otherwise, (the way that env setup), it will add current path to the file name.
when I try << get ${ORACLE_SID}_FTP_AR_DSN ....>>, it returns error as:
"Invalid data set name "/export/home/vwif/TBAE/FTP_DIRECTORY/IMP_AR_W.DAT". Use MVS Dsname conventions." (it gets my local file name instead of remote file name)
BTW, I'm trying to get a file from mainframe. Any other thought?
Thanks again
Helen
Ron Thomas <rthomas_at_hypercom.com> wrote:
get ${ORACLE_SID}_FTP_AR_DSN ....Ron ThomasHypercom, Incrthomas_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 forhelp:On one server, we have couple of SID (this client setup can't be changed). Then in the ( BourneShell ) profile, we have for each SID:TBAE_FTP_AR_DSN='DS1B.XXXXX1.TIDE.XXXXX'export TBAE_FTP_AR_DSN-- where TBAE is ORACLE_SID namePBAE_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 dynamiclychanged (SID) file name in the script. I used:ftp -n $FTP_SITE_ADR2 << ENDFTPuser $FTP_USER2 $FTP_USER_PASS2get ${ORACLE_SID}'_FTP_AR_DSN' $FTP_DIRECTORY/...ENDFTPI 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 eachdatabase, 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.HelenDo You Yahoo!?Make inter!
!
national calls for as low as $.04/minute with Yahoo! Messengerhttp://phonecard.yahoo.com/-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ron ThomasINET: rthomas@hypercom.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?Make international calls for as low as $.04/minute with Yahoo! Messengerhttp://phonecard.yahoo.com/ Received on Wed Aug 08 2001 - 16:36:19 CDT