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! Messenger
http://phonecard.yahoo.com/
Received on Wed Aug 08 2001 - 16:36:19 CDT
