Search found 5168 matches

by kumar_s
Thu Sep 07, 2006 1:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running Wrong Profile from Script
Replies: 3
Views: 970

Or create a Environmental varialbe which will be configured for each project, to the home directory of that corresponding user. And pass this variable as parameter to the shell and source the .profile for each time, so that you can ensure that the user specific variable is used.
by kumar_s
Thu Sep 07, 2006 1:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Commands for DS
Replies: 4
Views: 1598

Check the pdf given and avialable in your client.
All Program-->Ascential-->Online documents.
Else search this forum. :wink:
by kumar_s
Thu Sep 07, 2006 1:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot open 'Job Activity's propertise from job sequence
Replies: 5
Views: 1499

If severvice pack is already been installed, then "dsclient_xpsp2" will be the one required for you.
by kumar_s
Thu Sep 07, 2006 1:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Designer frozen due to Stage Properties
Replies: 8
Views: 2034

Is "dsclient_xpsp2" the path you are mentioning about?
by kumar_s
Wed Sep 06, 2006 7:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup Question
Replies: 15
Views: 3163

As said earliar, "date2" cannot be key.
Avoid Hashed file.
Lookup on "Key".
You will get multiple match, have a constraint as "date2<=date1".
Map the id in derivation.
by kumar_s
Wed Sep 06, 2006 7:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compilation error
Replies: 2
Views: 1638

Check if the wrapper stage that is used in the job, is open for editing simulteneously, while you are trying to compile the job.
by kumar_s
Wed Sep 06, 2006 7:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup Question
Replies: 15
Views: 3163

"date2" is not required to be a key other than "=" operation(Exact Match) .
by kumar_s
Wed Sep 06, 2006 7:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: datastage
Replies: 3
Views: 1012

Hi karthegx,
When you create a post, Pls have more relevent topic like "Job Log/Report in Sequential File" given to that. That will help person who answers the post, as well as those who search forum later.
by kumar_s
Wed Sep 06, 2006 7:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup Question
Replies: 15
Views: 3163

Do lookup on the "key" and in constraint part, have your required condition "date2<= date1 ". And in derivation Map the "id" field.
You can avoid hashed file. If you want you, you need to mark both "date2" as well as "key" fields as key. Where in you are actually looking at only "key".
by kumar_s
Wed Sep 06, 2006 7:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Delete Rows from target table
Replies: 6
Views: 2393

To find the records which are not in Source, you need to do a look, it can be either through Lookup Stage or Join stage as Arnd saind or recreate a table thorough a query INSERT INTO ....(SELECT ... FROM <target> IN(SELECT ... FROM <source>)) as suggested by Siva.
by kumar_s
Wed Sep 06, 2006 7:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: User defined Insert query
Replies: 6
Views: 1390

Try to check, with having two stages, One with select query, and other with to Insert the selected Data.
by kumar_s
Wed Sep 06, 2006 7:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer logic
Replies: 1
Views: 693

1. Map the target to the decimal(10) datatype.
2. Derivation - Input.Column[1,4]
Still there are several ways. One of the simple way is this.
by kumar_s
Tue Sep 05, 2006 4:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Lookups
Replies: 11
Views: 4456

Assign APT_STRING_PADCHAR to a space ' '. As suggested by Ray.
by kumar_s
Tue Sep 05, 2006 7:39 am
Forum: Data Integration
Topic: Information on Demand 2006 conference sessions and speakers
Replies: 4
Views: 10093

Actually, Daily many challenges. :wink:
by kumar_s
Tue Sep 05, 2006 7:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: kicking off sequences one after the other and knowing errors
Replies: 9
Views: 2050

What is spoiling you motive of parallelism.
If SeqA and SeqB are connected to the Sequencer, they both will be called parallely.
And followed by the SeqAB.