Search found 42189 matches

by chulett
Thu Sep 25, 2008 12:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use UtilityRunJob as an after job subroutine
Replies: 2
Views: 1074

Re: Use UtilityRunJob as an after job subroutine

I don't really see the point of doing things this way, but sure - create a 'Before/After' routine to leverage UtilityRunJob and then run it After Job. Could even be generic where you pass in the job name to run, etc...
by chulett
Thu Sep 25, 2008 11:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Testing for a numbers stored Char 18 field
Replies: 1
Views: 891

The field's data type is Char(1Cool? Disable 'Smilies' in your post.

Both Num() and IsValid() can be used to check for a number, depending on your need. And you need a numeric comparison, doing it string-wise a value of '1000000' is less than '90' for example.
by chulett
Thu Sep 25, 2008 10:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Testing for a numbers stored Char(18) field
Replies: 6
Views: 1604

This *is* the Parallel job forum. :?

Just edit the original post and change the job type.
by chulett
Thu Sep 25, 2008 10:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Testing for a numbers stored Char(18) field
Replies: 6
Views: 1604

Perhaps...

Code: Select all

DIGITS(in.FldName) = in.FldName And in.FldName < 1000000
by chulett
Thu Sep 25, 2008 9:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Failing to connect to UniData 6 database from Designer
Replies: 9
Views: 2267

Excellent. Time to mark the topic as Resolved then?
by chulett
Thu Sep 25, 2008 9:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Exception Handling
Replies: 3
Views: 1516

Setup a 'reject link'. Open the online Help and on the Index tab type 'reject rows' for a lengthy discussion on the topic.
by chulett
Thu Sep 25, 2008 7:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regd An Error Calling a Routine
Replies: 7
Views: 1692

Welcome.

Please search the forums for "Controller problem: Unhandled failure", this question has been asked and answered quite a number of times.
by chulett
Thu Sep 25, 2008 7:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: inserting the diff files data in to target table
Replies: 8
Views: 2653

You've said that already. Let's try this again.

How can you recognize the records inserted by the first job? :?
by chulett
Thu Sep 25, 2008 6:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: inserting the diff files data in to target table
Replies: 8
Views: 2653

amreesh_singh wrote:But I need to update only records which i have inserted in to the table using 1st job.

First mention of more than one job or of this particular requirement.

How can you recognize the records inserted by the first job? :?
by chulett
Thu Sep 25, 2008 6:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to convert sting to date(DD-MMM-YY)
Replies: 2
Views: 3288

ray.wurlod wrote:Perhaps you should ask Gordon Sumner.

Oy, that took a moment or two to puzzle out.
by chulett
Thu Sep 25, 2008 6:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Varchar to Date format
Replies: 42
Views: 10909

Exactly. Eight posts so far and all a mess. This is not a social networking site nor your dang cell phone, it is a professional site where professionals support each other... well, professionally. Do you write your emails at work as poorly? Your documentation? :roll:
by chulett
Thu Sep 25, 2008 6:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to check if Folder exists
Replies: 3
Views: 1989

That would have been a good thing to mention in the first post. What does your official support provider have to say on the subject?
by chulett
Thu Sep 25, 2008 6:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage 7.x Server Edition - Designer Crashes
Replies: 2
Views: 1350

Is 'Windows 2003' a supported platform? Suggest you open a case with your official support provider and see if indeed it is supported and works (or can be made to work) for the client software.
by chulett
Wed Sep 24, 2008 9:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How can I extract just the values from xml file???
Replies: 11
Views: 4209

The XML Reader stage is old and has been deprecated. Use the XML Input stage now instead. For documentation there is an XML PACK pdf file in your 'Docs' directory. And an XML Best Practices writeup on Kim Duke's website. ps. The XPath Expression is stored in the 'Description' field in the XML stages.
by chulett
Wed Sep 24, 2008 3:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to solve a small scenario which i couldn't get
Replies: 12
Views: 3678

D'oh! Fixed my typo.