DSXchange

Hi All, I am using a command SELECT NAME, CATERGORY FROM DS_JOBS WHERE NAME = '<JOBNAME>' for searching the loacation of a job in a catagory. I heard like we can also use desearch command for implementing the same. I have searched in online manuals and also in forum, but i didn't find the syntax, ho...

DSguru2B wrote:What did you find out when you did a search? vmcburney (from the top ten posters) has a topic about this in his blog. Click on his name, check out his blogs.

Thanks a ton.!! I got the same.!!
Madhu

Hi All, I am very much interested in giving certification on Datastage EE. I am sicerely preparing for the same. But, I am not sure like what all are the topics i have to prepare. Could any one tell me, on what topics i have to get prepare well. In certification, will they ask questions on installat...

Hi,

I have a sequential file which contains all the parameters..!! Now i want to pass the parameters from the sequential file to a oracle enterprise stage in one parallel job.!!

Is there any specific function to do this..!!

Thanks in advance
Madhu

Hi All,

I have a set of datastage server jobs and i have to run the same in datastage PX environment. I knew that we can use shared container for running the server job in px.

Can any one tell me the other ways for doing this which gives better performace

Thanks in advance

I have one basi question.

When we run a job from client componenet, internally either it runs on server or on Datastage ENgine.
What is the role f DSEngine exactly

Thanks

Hi,

I am good at C++ and i am interested in writing parallel routines. I really don't know how to start up.

Can some one send me the syntax or one simple routine so that i can understans it clearly.

Thanks in advance.

Or you can do it in the OPEN command of a database stage. And how exactly are you going to do it in a routine? Are you planning do use a Basic Transformer? Hi Guru... could you explain me in detail. I haven't used this OPEN command in database stage. Can you tell me the syntax of this open command ...

Hi

I have to delete the indexes of a table using routines. Can anyone help me... please

Hi All, I have configuration file with 4 nodes. I have a job where i need to do the hash partitioning on One column (assume column name as A) and i have million records coming from the source and all values are same for the column A. When i perform hash partioning will it partition into 4 nodes or ...

Hi All,

I have a scenario like to get the last 10 runs timestamp of a perticular job.

Is there any datastage repository table which will give this information.

thanks in advance

Hi, I have a job like Dataset ---> Copy Stage --> Db2Enterprise stage and my Write Method is : Upsert. Upsert mode is : Userdefined Update. Configuration File: 4 Nodes. Now, I am getting 1 million records from input and its taking 3 hours to update the records. Is there any way to make better perfor...

Hi All,

I have a question, what is the difference between the Aborted, Stopped and Crashed. The status codes of these are 3,97 and 96 respectively.


Kindly help me.

Hi All, I want to stop the current runninhg job through after job routine by using DSStopJob function. Shall we use DSStopJob function to stop the current function. I have written a code for this, but the job is not stopping. The status of the job is Finished with warnings. Kindly look at my code. $...

kduke wrote:I like both Abort and DSLogFatal(). The sequence should catch either if the right box is checked. It is a personal preference. Ray and Arnd are usually correct in the sense things work better if you a ...

Thanks a lot Kduke,

Could you please explain me in detail