DSXchange

Ray, I checked the unconfig in our LINUX server and it has ALLOWNFS 1 Is it safe to presume that it is an Admin level task to mount a network drive? I am not an admin on the LINUX box. Any special settings to keep in mind when I request our Linux Admins to create this mount for our project? - Automo...

Another angle to look is... Do you have the DS Client installed? Your posting shows you have 8.X on Linux and you certainly have DS Client 8.X on your local system, correct? The PDF docs are part of the client install and that is one place to start. Start/All Programs/IBM Information Server/Document...

Ray, Thanks for the followup. The mapped drive letter does not show up in the "View Data Dialog" or when i use a paramater for this file name as type "pathname". To add, I also created a SUBST H: G:\Sample on the DS Server for testing and it created a substituted drive for a fold...

I have a requirement to download files from an FTP site using the following rules. 1. This will be a daily job run via scheduler or cron or batch 2. Connect to a known FTP site and check if a file with the pattern "FILE_PREFIX_YYYYMMDDHHMMSS.ready" exists. 2.a The HHMMSS is not constant an...

ArndW, I first created this using Windows Explorer's "Tools/Map Network Drive" menu and assigned a network shared folder to G: drive e.g \\machine_name\share_name As I had issues when accessing this from datastage, I then deleted this map and created this G: using command line NET USE G: \...

In our Windows DS Server i have a Network shared folder mapped to a drive (G: ) If i have to read a sequential file from this folder, is there anything special that needs to be setup? When I do a "Browse" on the Seq file stage, it does not show the mapped drive in the file selection dropdo...

Thanks Kumar. I will make a note of that.

I am marking this as resolved for this current request.

Thanks Craig.

Marked as Resolved...

Ray, Thanks for the input. I should have searched a bit more.... apologies. I found a lot of links here on this topic. The following link helped a lot. http://www.dsxchange.com/viewtopic.php?t=99399&highlight=user+variables I went with the Server Job approach as it is just a single record that i...

I have a scenario where Job-A has the logic to load data from a source file into a target data table. This is an RCP PX job that takes several job parameters (Input source file name, RCP Schema file name, DB Connection details et al). One piece of information that gets fed into this job is the type ...

Hi Group, Thanks a lot for your invaluable time and input. Appreciate it much. I have been trying too many things and most of what have been suggested here and could not post intermediate results. My apologies. Long story short - with so many gurus jumping in to help me, it could never go wrong. The...

ArndW, Apologies for the confusion caused. The ROW Generator has a bug (confirmed by IBM as Case # 96505) when it is used to generate custom dates ref. http://www.dsxchange.com/viewtopic.php?t=117212 I am trying to handle this via a server job for now. I have requested our DS Admin to provide a sing...

Hi Kumar, My apologies; I am not sure I follow your note. In another thread http://www.dsxchange.com/viewtopic.php?t=117276 where I posted the results of testing the Transformer ==> PEEK in a PX job, it turned out to be a case of this approach being invalid and should be handled in a Server job. I t...

Hi Kumar, ArndW & Ray, Thanks for taking the time to review and help. Appreciate it. That was a good lesson I learned from your feedback. ArndW, I tried the RowGenerator approach and got hit by a bug in the Row Generator stage when dealing with Dates http://www.dsxchange.com/viewtopic.php?t=1172...

I am trying to do a simple "One-Record-Generator" using a transformer that sends the output to a peek stage. I did a few searches and found Craig's suggestion of Dummy transformer to an output stage Background:- The original requirement is to have one record sent to a stored procedure. As ...