DSXchange

Thank you. Will get a PMR opened.

Hello, Is there a way to find out whether a particular DS project is protected or unprotected via command line either from the client or the DS engine, without having to log into any GUI clients? I tried searching the forum but couldn't find any answers. Appreciate your inputs very much. Regards, Wh...

Hi all, I have the following input data: Input 1 Tiger 1 Mohan 1 Chow 2 Christie 2 John 3 Ruth 3 Babe and I'm looking to get this data in the following output format: Output 1 Tiger Mohan Chow 2 Christie John 3 Ruth Babe What is the best way to code this via a PX job? Greatly appreciate your inputs!...

Haa! It returns the folders: >LOGTO ds_tutorial >SELECT * FROM DS_JOBS WHERE JOBTYPE='0'; Job name.... \\\ Description. No.......... Category.... Job name.... \\\\Jobs Description. No.......... Category.... \Jobs Job name.... \\\\Jobs\Work_In_Pro gress Description. No.......... Category.... \Jobs\Wo...

Hi all, Trying to get the list of server jobs in a project from uvsh but having a tough time understanding the results. Although the project has 0 server jobs, the below query returns 13 as the output. Am I going wrong with the UV query? >PTERM CASE NOINVERT >LOGTO taxprd >SELECT 'Server:',COUNT(*) ...

Please post/provide a sample of your desired output and the current undesired output with the inputs for the same. May that will help us understanding your problem better.

Regards,
Whale.

Does cleaning up of &PH& folder in the project still help in version 8.1? How exactly does cleaning up of &PH& help? I'm sorry if this is a repeat question. Search didn't help.

Appreciate your inputs!

Regards,
I_Server_Whale.

Hi all, I need to execute this command through the "Execute_Command" activity stage in a job sequence. This command is generated on the fly in the job sequence and needs to be executed at very end of it . Here is the command: H:\IBM\InformationServer\Server\DSEngine\bin\dsjob -domain ukatr...

Hello all, Not sure if this has been already asked. But I couldn't find anything useful in my search. And my BASIC skills have become rusty. :( Environment: IS 8.1, Windows Server 2003 There are 3 Server jobs, Job A, Job B and Job C. And there are two user-defined server routines, R1 and R2 which ar...

just noticed.. between my eg 1 and eg 2 - i put in different port numbers in my previous post. dont worry.. when trying this, i was putting in the correct and SAME port numbers. I know that I'm replying to a relatively old post. But can you try the below: dsjob -domain bv03uap010ufmy3 -server tduct...

Hi all,

Trying to configure the Teradata connector and the Teradata enterprise stage in a Linux environment with Information Server 8.1. Has anyone done this? What would be my first steps? Is there any documentation for the setup?

All help is greatly appreciated.

Regards,
Whale.

You are absolutely right. "They" do not have DS knowledge and there in lies the problem. Thanks for the response. I will be doing the telling from now on.

Slapping on my wrist and talking to myself "Wake up you sleepy head".

Thanks Ray!

Regards,
Whale.

Hi all, I'm being told to use DB2 session tables in DataStage jobs. Has anyone used DB2 session tables in DataStage? I believe that the session table will hold or be active only during that particular job run that the session table is used in and not across multiple jobs. Is that a safe assumption? ...

Hi Folks,

Is there a way to set a return code in a PX job based on a condition and then access this return code in the job sequence to branch control of the sequence?

Your inputs are greatly appreciated!!!

Whale.