DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1244 matches
Author Message
 Topic: DS Project "Protected" status
I_Server_Whale

Replies: 7
Views: 2580

PostForum: General   Posted: Tue Nov 08, 2016 2:24 pm   Subject: DS Project "Protected" status
Thank you. Will get a PMR opened.
 Topic: DS Project "Protected" status
I_Server_Whale

Replies: 7
Views: 2580

PostForum: General   Posted: Tue Nov 08, 2016 10:12 am   Subject: DS Project "Protected" status
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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 G ...
 Topic: Connecting to sql server using Windows Authentication
I_Server_Whale

Replies: 6
Views: 5596

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 24, 2015 2:25 pm   Subject: Connecting to sql server using Windows Authentication
http://www-01.ibm.com/support/docview.wss?uid=swg21687105
 Topic: Concatenating strings for the same nonunique key values
I_Server_Whale

Replies: 2
Views: 1726

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 17, 2012 4:29 pm   Subject: Concatenating strings for the same nonunique key values
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi all,

I have the following input data:

Input

1 Tiger
1 Mohan
1 Chow
2 Christie
2 John
3 Ruth
3 ...
 Topic: List Server, Parallel and Sequence jobs in 7.5.1
I_Server_Whale

Replies: 4
Views: 2082

PostForum: General   Posted: Fri Dec 23, 2011 3:11 pm   Subject: List Server, Parallel and Sequence jobs in 7.5.1
Haa! It returns the folders:

>LOGTO ds_tutorial
>SELECT * FROM DS_JOBS WHERE JOBTYPE='0';


Job name.... \\\
Description.
No..........
Category....

Job name.... \\\\Jobs
Descriptio ...
 Topic: List Server, Parallel and Sequence jobs in 7.5.1
I_Server_Whale

Replies: 4
Views: 2082

PostForum: General   Posted: Fri Dec 23, 2011 2:10 pm   Subject: List Server, Parallel and Sequence jobs in 7.5.1
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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 ...
 Topic: Joining two datasets.
I_Server_Whale

Replies: 3
Views: 1768

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Jun 05, 2011 10:10 am   Subject: Joining two datasets.
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.
 Topic: &PH& clean up in IS 8.1
I_Server_Whale

Replies: 4
Views: 2723

PostForum: General   Posted: Thu Dec 23, 2010 11:45 am   Subject: &PH& clean up in IS 8.1
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: Solaris 10, XMETA on Oracle 10g R2
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.

Appr ...
 Topic: Different behaviour GUI versus command line
I_Server_Whale

Replies: 0
Views: 1033

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Sep 23, 2010 4:45 pm   Subject: Different behaviour GUI versus command line
DataStage® Release: 8x
Job Type: Server
OS: Windows
Additional info: Windows Server 2003, IS 8.1
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 ...
 Topic: Force a calling job to abort based on the child job's status
I_Server_Whale

Replies: 2
Views: 1788

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Jul 07, 2010 9:27 pm   Subject: Force a calling job to abort based on the child job's status
DataStage® Release: 8x
Job Type: Server
OS: Windows
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. Sad

Environment:

IS 8.1, Windows Server 2003

T ...
Resolved
 Topic: 8.1 upgrade - changes in dsjob command
I_Server_Whale

Replies: 13
Views: 12934

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue May 04, 2010 3:41 pm   Subject: 8.1 upgrade - changes in dsjob command
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 r ...
 Topic: Teradata connector and enterprise stage
I_Server_Whale

Replies: 0
Views: 1021

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 22, 2009 4:28 pm   Subject: Teradata connector and enterprise stage
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: 64 bit SUSE Linux
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 ...
Resolved
 Topic: DataStage and DB2 session tables
I_Server_Whale

Replies: 2
Views: 1825

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Feb 24, 2009 5:44 pm   Subject: DataStage and DB2 session tables
You are absolutely right. "They" do not have DS knowledge and there in lies the problem. Smile Thanks for the response. I will be doing the telling from now on.

Slapping on my wrist and talking to m ...
Resolved
 Topic: DataStage and DB2 session tables
I_Server_Whale

Replies: 2
Views: 1825

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Feb 24, 2009 12:50 pm   Subject: DataStage and DB2 session tables
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 ...
 Topic: Setting a return code in a PX job and accessing it in a seq.
I_Server_Whale

Replies: 2
Views: 1513

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 05, 2008 1:07 am   Subject: Setting a return code in a PX job and accessing it in a seq.
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 inpu ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours