DSXchange

Hi, We would like to know if there are any stages considered to be as plug-in stages for parallel jobs. Stages like FTP and CFF are plug-in stages in server jobs. How about for parallel jobs? Are there any stages considered to be as plug-ins that needs to be taken care during the DS server installat...

Ok, thank you Craig.

I did try installing the Multi-Client Manager and faced some issues in that. I have posted it in a separate thread.

Thanks.

Hi, Since we are upgrading from 7.1r1 to 7.5, we are trying to install Multi Client Manager. But we are facing some problems in it. When the Setup exe is clicked for the Multi Client Manager to install, the option to select the language pops up. Then, it says installtion starts and nothing happens a...

Hi,

We are upgrading from the current server version of 7.1r1 to 7.5

Since we have a lot of jobs in 7.1r1, we would like to know the possibility of connecting to 7.1r1 server from 7.5 client.

Please let us know if anyone have tried this before.

Thanks.

Thanks for your post Ray and chulett. We were able to implement it. Craig, we would be using this generated unique key only for insertion into one table. So, we could do it the way, Ray had said. But I would also like to undertand the technique that you have told. How could I generate a sequence num...

The overall application is still in development phase. So things can be very well changed. We would replace the usage of DS "KeyMgtGetNextValue" by using the Oracle's sequence. As mentioned by Ray, if we use the sequencename.NEXTVAL in the user-defined SQL, then what should be specified in...

Hi, We were using a DataStage job to update a certain table. We were using the DS Transform "KeyMgtGetNextValue" to generate a unique Id whenever there were new records to be inserted. Now, a web application has been designed, also through which new records might be inserted. So, we have c...

Thanks for the information Craig...

Ok, thanks.

I would post this in Parallel job forum to get the answer for the parallel job stages.

Hi, We have a question about the Sequential File stage. When we write to a Sequential File stage, by default the File Name in the properties of the stage is the name of the input link. We would have to explicitly change that to a physical file location and a file name on the server. If we do run the...

Thanks for the information Ray!

You say that, in Server Jobs, DataStage does not cache the entire data set in memory. Is it the same way in Parallel Job as well or different?

Hi, We have a basic question on the way a Database stage works. Suppose we have a SQL on a source database stage that returns 2 million rows, how does DataStage handles it? Does DataStage executes the SQL and holds the 2 million rows in its memory and passes a chunk by chunk of rows to the next stag...

Ray,

The client whom you say of processing huge volumes using Server jobs, what is the approximate volume. Are they processing up to 10 or 15 million?

Thanks.

Hi Ray, By "here script", do mean the one below, cmd = "sqlplus -s ":userID:"/":passWD:"@":dbName cmd<-1> = "SELECT COUNT(*) FROM DUAL;" cmd<-1> = "quit;" Call DSExecute("NT",cmd,output,rc) I tried with this and it still didn't wo...

Hi,

We did get this error and it halted our development process for a considerable time. We use a lot of this DSExecute command and our DS server is on Windows.

So, where does this capture file or its equivalent sits in the windows server?

Thanks.