DSXchange

Thanks Kamikola. Appreciate for the reply. The syntax you have given works perfect for me.

Thanks for the reply

I checked my username and password and it is correct as I could able to logon to designer client using the same credentials.

Please advice if I can check the user credentials associated to the Datastage project

Hello, I am using Information server 8.7 version and trying to execute dsjob command from windows command prompt , but getting the following error "ERROR: Failed to open project Status code = 80011" Below is the dsjob command dsjob -domain abcd:9080 -user savvy -password savvy -server abcd...

Thanks for the reply Ray. I am not a PL/SQL expert, need to figure it out how I can achieve it. If you have any information on where I can search please suggest me.

Hello,

I have following requirement

1. To read the SQL's from one of the columns in the Oracle table

2. Loop though all the SQL's

3. Execute those SQLs and

4. Store the output of the SQL's in another table

Can anyone please suggest me the best approach for my requirement.


Thanks,

Hello, For performance tuning I would like to change the configuration file from one node to two node configuration file on SMP (Symmetric Multi Processing) architecture. Can anyone tell me what all precautions I needs to take in a parallel job when changing the configuration file? Thanks in advance

Thanks Craig. I tried following solutions a)Right-clicked and clicked Show Performance Statistics. b)Confirmed that ports 13400 and 13401 were being used by the job monitor by doing "sh ps -ef | grep 13400" and they are. c)Checked DSParams and confirmed that the APT_NO_JOBMON parameter is ...

i have created a ds job . the job is running fine but i am not able to see the performance statistics. the performance statistics are showing 0'S
It is not displaying the no of rows.

Hello Jwiles,

Thanks for your reply, can you expain me briefly how to do the logic in the transformer.

Hi, I have a requirement to create sequence numbers for each group I have the following columns in the input Col1-Col2-Col3-Col4 1111-2222-3333-444 1111-2222-3333-444 1111-2222-3333-444 1111-2222-3333-555 1111-2222-3333-555 So, I have two groups now One is 1111-2222-3333-444 The next is 1111-2222-33...

Hello,

I am getting the below error when running the routine

"ERROR calling Sub Routine: DSR_EDIT (Action:2)"

can any one please explain what does this error mean?

Thanks in advance

Hello, Can anybody please tell me how to add header and Footer to the Sequential File in Datastage. The requirement is like below Header should have file name and Current Time and Date Footer should have count of records. I searched through the Dsxchange but dinot get any answerr to add. Please help...

Hello,

Can anyone tell me is there a way to save the Daatastage director logs to the local system.

Thanks in advance

Hello,

Can anybody please tell me the code to call one server routine into another server routine.

Thanks in Advance

Hello ray,

Thanks for the reply, I have added the parameter in the job and i am calling the parallel routine in the transformer.
But how to pass this parameter in the routine. I caanot able to add environment variable parameter in the parallel routine Library File Path

Thanks in Advance