Search found 198 matches

by tbtcust
Thu Oct 30, 2008 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is it possible to compare multiple job pairs in version 8?
Replies: 5
Views: 2190

Is it possible to compare multiple job pairs in version 8?

Hi All. Is it possible to compare multiple job pairs at once in version 8? I have a set of jobs in development and that same set of jobs are in production. I want to identify all jobs in production that have been changed in development and what those changes are. I'm want to avoid comparing one pair...
by tbtcust
Sat Oct 25, 2008 9:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Append system date and time to a file name in Seq File Stag
Replies: 10
Views: 14083

Thanks GSIDSXGrp. Your solution works great.
by tbtcust
Tue Oct 21, 2008 4:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do I overriding sequence and parallel job parameters?
Replies: 8
Views: 5360

Thanks Mike.

in Value Expression my only option in the drop down is "[As pre-defined]". Your thoughts. Thanks.
by tbtcust
Tue Oct 21, 2008 1:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do I overriding sequence and parallel job parameters?
Replies: 8
Views: 5360

How do I overriding sequence and parallel job parameters?

Hi everyone. I have a few parallel job jobs that have parameters. Depending on the environment I am running in, i.e., development, QA, or Production, I'll need to change the job parameters. These jobs are spread across three child sequence. I execute the three child sequence via a parent sequence. I...
by tbtcust
Tue Oct 21, 2008 12:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence If then else logic
Replies: 4
Views: 2643

Thanks chulett. That worked fine.
by tbtcust
Tue Oct 21, 2008 12:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence If then else logic
Replies: 4
Views: 2643

Thanks chulett. That worked fine.
by tbtcust
Tue Oct 21, 2008 10:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence If then else logic
Replies: 4
Views: 2643

Sequence If then else logic

Hi all

I want to create Parent Sequence (ParentSeq) and three child Sequence (ChildSeq1, ChildSeq2, and ChildSeq3)

I want to pass ParentSeq a parameter and based on that parameter I execute either ChildSeq1, ChildSeq2, or ChildSeq3. Is this possible?

Thanks in advance for any help.
by tbtcust
Mon Sep 29, 2008 10:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do Transform Stage constraints work?
Replies: 2
Views: 1363

Thanks for replying chulett. This is helpful
by tbtcust
Mon Sep 29, 2008 9:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do Transform Stage constraints work?
Replies: 2
Views: 1363

How do Transform Stage constraints work?

Hi all. I have a single sequential file linked to a transform stage. That transform stage is linked to three sequential output files. From the transform stage records will be sent to their respective output files via the constraints. Some records meet the criteria of more than one the constraint. Do...
by tbtcust
Fri Sep 26, 2008 10:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Testing for a numbers stored Char(18) field
Replies: 6
Views: 2177

I got the same results with Compare ray.wurlod.

NUM(Trim(in.field)) = 1 And Len(Trim(in.field)) < 7 seems to work. Not so pleased with this workaround but hey it does seem to give me what I need.
by tbtcust
Fri Sep 26, 2008 3:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Testing for a numbers stored Char(18) field
Replies: 6
Views: 2177

Sorry about the confusion chulett

ray.wurlod , the field is padded with spaces. The number sometimes has a leading zero or two.
by tbtcust
Thu Sep 25, 2008 10:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Testing for a numbers stored Char 18 field
Replies: 1
Views: 1152

Testing for a numbers stored Char 18 field

Hi all. How can I test for a number stored Char field? I need to locate records which have numeric values stored in a field where the value is less than 1000000. That field also contains alpha-numeric values as well. The field's data type is Char(1Cool and I'm sending the output to a Seq file. I hav...
by tbtcust
Thu Sep 25, 2008 10:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Testing for a numbers stored Char(18) field
Replies: 6
Views: 2177

Apologies chulett. This should have been posted to the Parallel job forum. I'll repost there. Thanks.
by tbtcust
Fri Sep 19, 2008 7:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can I set a default vale when a lookup fails?
Replies: 2
Views: 1894

Thanks shaonli that works. I was tiring to solve in the wrong place.