Sorry should have been more specifc. I want to bring in a csv file as a source table in datastage but do not want to have to FTP it to unix first. Can datastage (unix setup) read csv or txt files off of a local drive.
When I used Informatica I could point to a table locally and bring it in as a source (say for an initial population or test load). I could also access the unix side if I wanted to store an output file. Just making datastage did or did not have the same functionality before I went down the FTP path.
Your UNIX-based DataStage server needs to be able to 'see' your local drive in order to access files on it. You'd need to arrange an NFS mount or use something like Samba to enable that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
So the functionality is there it just needs to be setup. Is that something each user would have to establish or will the DBA's need to set it up on the box? If I sent your previous post to the DBA's would it give them enough info to figure it out.
Craig covered the possibilities; either use an FTP stage or use a facility like Samba that makes your Windows folders visible to your UNIX machine (as if they were mounted there) or vice versa.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.