Access remote file from Sequential Stage

s_avneet · Post by **s_avneet** » Thu Nov 24, 2016 10:24 am

Hi ALL.

I am trying to access a file from remote server using seq file stage.
The remote location is a shared folder and dsadm user has been granted access to the drive.

i can access the shared drive through putty using dsadm creds, but not able to access it from my job,

i tried to hard code //ip/path/filename but getting No such file or directory error.

Any pointers?

JRodriguez · Post by **JRodriguez** » Thu Nov 24, 2016 3:58 pm

The DataStage job will have visibility to local directories only...I'm afraid that you would need to mount the directory to the DS server and open up the permission to the user executing the DS jobs. If by shared you meant mounted directory then check the permissions on the "shared" directory and the user running the DS job...

s_avneet · Post by **s_avneet** » Fri Nov 25, 2016 4:04 am

Any pointers how do i mount?

chandu123 · Post by **chandu123** » Fri Nov 25, 2016 7:17 pm

Are you using Specific file or File pattern option in Seq stage?

atul9806 · Post by **atul9806** » Fri Nov 25, 2016 7:55 pm

You can not mount, Only root user can. Ask your Linux Admin team to mount remote drive to datastage server

FranklinE · Post by **FranklinE** » Mon Nov 28, 2016 9:37 am

I'm wondering if Sequential File is the best stage for this. Have you tried File Connector?