DSXchange

The internal SQL privileges in a datastage project are assigned per the normal user access mechanism of DataStage (i.e. the .developer.adm file). If you run the job as a DataStage user it will go through, but I am assuming your userid with which you are running is not enabled for DataStage use.

I've use the multiple compile a lot and haven't seen that error before. Does it always happen (and if so, at the same place)? It does seem that this is a good candidate for calling your product support people.

Benny,

have you thought about using DataStage version control to help synchronize your work? It would simplify development and make sure that only one version of a job is considered "live".

Reddy, do you really need a script or a rcp or ftp command?

Naren, this can be done with either a recursive lookup or a loop within a routine. You could chain lookups in a job, but you could only link back one level per lookup - if you know your maximum depth of recursion you could do it in a job directly. You could solve it with a relatively short DS routin...

Maurik - this site is very powerful because of the search facility. This works, in part, with the thread topics. "Thread hijacking" is when a completely unrelated question is posted to a thread, such as in this case. The thread title "Job Locked with associated PID=0" and your question regarding "AC...

The advantage of datasets (or, as you would say, bundled sequential files) is that they are created in such as way that each individual file within the dataset represent a processing node or process in PX, so reading a dataset is done in parallel. Reading to or writing to a sequential file can only ...

maurik, this is a thread hijack - it has nothing to do with the original query. Please post it on a new thread (unless you feel like using the SEARCH facility first to see the numerous answers already given) :D

arbert - even though the hardware layer has become more complex, in terms of the original question the answer remains the same regardless. The relationship between a physical processor and any virtual layers (be it a VMWARE or even PX node list, or a hyperthreaded machine or even a multicore single ...

In your transform derivation do a EREPLACE(In.DSXLine,'Value "MY_DB_NAME"','Value "#DBPARM#"') You will also need to make sure that your job has this DBPARM declared as a parameter, if not then this also needs to get added to the DSX output file, otherwise the new jobs wi...

The PX install will be an add-on if it is at the same version, so you won't need to do anything with PX jobs. If you spent $1000 on designing a job that works acceptably, it will take a powerful business case to justify another $1000 in making it into a PX job which does nothing else except to run i...

Looks like sequential files bundled together

They are. Then again, since UNIX only knows about sequential files, so are databases.

Madhavi, it sounds like we've reached the limits of what can be done here in the forum - it really might be a bug in the product. The next step is to go through your support provider and giving them a reproduceable test case. But it would be nice if you could leave feedback on this thread when you g...

Yes, it exists in all environments. There is a file called dsdlockd.config in your project directory, change the "start=0" line to read "start=1" and restart datastage (that's the simplest way to do this). I don't have a windows site available to me to see how to get this service started without bou...

I have done this type of thing before. Export as a .DSX and then write a DS job to read it in, parse & replace the text and write it back out to a sequential file as a .DSX