Search found 1233 matches
- Tue Nov 08, 2016 2:24 pm
- Forum: General
- Topic: DS Project "Protected" status
- Replies: 7
- Views: 4726
- Tue Nov 08, 2016 10:12 am
- Forum: General
- Topic: DS Project "Protected" status
- Replies: 7
- Views: 4726
DS Project "Protected" status
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...
- Mon Aug 24, 2015 2:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Connecting to sql server using Windows Authentication
- Replies: 5
- Views: 8367
- Mon Sep 17, 2012 4:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenating strings for the same nonunique key values
- Replies: 2
- Views: 3022
Concatenating strings for the same nonunique key values
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!...
- Fri Dec 23, 2011 3:11 pm
- Forum: General
- Topic: List Server, Parallel and Sequence jobs in 7.5.1
- Replies: 4
- Views: 3742
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...
- Fri Dec 23, 2011 2:10 pm
- Forum: General
- Topic: List Server, Parallel and Sequence jobs in 7.5.1
- Replies: 4
- Views: 3742
List Server, Parallel and Sequence jobs in 7.5.1
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(*) ...
- Sun Jun 05, 2011 10:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Joining two datasets.
- Replies: 3
- Views: 3173
- Thu Dec 23, 2010 11:45 am
- Forum: General
- Topic: &PH& clean up in IS 8.1
- Replies: 4
- Views: 4672
&PH& clean up in IS 8.1
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.
Appreciate your inputs!
Regards,
I_Server_Whale.
- Thu Sep 23, 2010 4:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Different behaviour GUI versus command line
- Replies: 0
- Views: 1894
Different behaviour GUI versus command line
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...
- Wed Jul 07, 2010 9:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Force a calling job to abort based on the child job's status
- Replies: 2
- Views: 2987
Force a calling job to abort based on the child job's status
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...
- Tue May 04, 2010 3:41 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: 8.1 upgrade - changes in dsjob command
- Replies: 12
- Views: 16494
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...
- Wed Apr 22, 2009 4:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata connector and enterprise stage
- Replies: 0
- Views: 1849
Teradata connector and enterprise stage
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.
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.
- Tue Feb 24, 2009 5:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage and DB2 session tables
- Replies: 2
- Views: 3228
- Tue Feb 24, 2009 12:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage and DB2 session tables
- Replies: 2
- Views: 3228
DataStage and DB2 session tables
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? ...
- Wed Nov 05, 2008 1:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Setting a return code in a PX job and accessing it in a seq.
- Replies: 2
- Views: 2673
Setting a return code in a PX job and accessing it in a seq.
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.
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.