Search found 42189 matches

by chulett
Fri Feb 19, 2016 8:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Convert Normal Date Into Julian Date
Replies: 12
Views: 9466

And crap, just like that not the answer you are looking for. Didn't notice you posted Server code in the PX forum, let's get you over into the right one and see how we can approach this with our old friends the 'Conv Brothers'. :wink:
by chulett
Fri Feb 19, 2016 8:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Convert Normal Date Into Julian Date
Replies: 12
Views: 9466

Warning (pet peeve alert) but that is not a Julian date, which may explain your difficulty in finding the proper solution. From the docs: A Julian day specifies the date as the number of days from 4713 BCE January 1, 12:00 hours (noon) GMT What you are looking is called an ordinal date - the two dig...
by chulett
Thu Feb 18, 2016 7:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 11.5 Backward compatibility not working
Replies: 6
Views: 12011

Ah... I see our old friend Vincent is still hard at work over there. :wink:
by chulett
Thu Feb 18, 2016 7:25 pm
Forum: General
Topic: Trigger DataStage Sequence from Email
Replies: 5
Views: 2444

Interesting, we're currently implementing Control-M at our site, I'll dig around and see if they can support that kind of triggering mechanism...
by chulett
Thu Feb 18, 2016 4:52 pm
Forum: General
Topic: Output of shell command in email notification
Replies: 4
Views: 1944

True that.
by chulett
Thu Feb 18, 2016 2:18 pm
Forum: General
Topic: Output of shell command in email notification
Replies: 4
Views: 1944

Silly it may be but I don't recall them ever adding the ability to parameterize the body of the email, unfortunately. Unless they've added that in more recent versions, the solution has been to take the DSSendMail routine and create a tweaked version of it to include that functionality.
by chulett
Thu Feb 18, 2016 10:13 am
Forum: General
Topic: Trigger DataStage Sequence from Email
Replies: 5
Views: 2444

Have the email sent to you and when you get it, press the button?

Somewhat facetious answer but may be the only one. :?
by chulett
Thu Feb 18, 2016 7:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fetch XML CLOB data through Oracle Connector faster
Replies: 9
Views: 4507

Can you post the parameter names involved, please, the ones controlling your two options? Just so we make sure we're all on the same page, terminology-wise. :wink:
by chulett
Thu Feb 18, 2016 7:48 am
Forum: General
Topic: Writing Job log into UNIX file
Replies: 6
Views: 2773

It would help if you answered my question, provided us with details of exactly how your script works. Otherwise we may just have to stick with "Huh, that's odd".
by chulett
Thu Feb 18, 2016 7:46 am
Forum: IBM QualityStage
Topic: Investigate Reports
Replies: 12
Views: 10995

Let's start by getting you in the actual QualityStage forum, hold on a sec... there you go.
by chulett
Wed Feb 17, 2016 4:53 pm
Forum: General
Topic: Writing Job log into UNIX file
Replies: 6
Views: 2773

How exactly is your script capturing the log details - using the various dsjob options? And specifically are you saying that all of the log messages for a particular job run were successfully extracted by your script except for those three? Records before and after were captured? If so, not sure how...
by chulett
Wed Feb 17, 2016 10:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logic required for If / then / else in tranformer
Replies: 8
Views: 4068

Seems to be a bit of a serial repeater. :wink:
by chulett
Tue Feb 16, 2016 12:54 pm
Forum: General
Topic: Can we create separate log for Multiple instance jobs?
Replies: 7
Views: 2446

Was going to mention that - the Director essentially uses a 'view' into the log table driven by each Invocation ID which makes it look like they are separate when in fact they are not. From what I recall, you can see them all mixed together if you look at the logs for the 'base' job in the Director....
by chulett
Tue Feb 16, 2016 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: remove leading zeros in decimal field in sequential file
Replies: 26
Views: 67194

True... and mentioned as the solution in the very first reply as well. :wink:
by chulett
Mon Feb 15, 2016 5:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup with LIKE and not with EQUAL
Replies: 9
Views: 4199

Ray, the SQL was just there as an example of how they would do it if a database was involved. One isn't. These are two files they need to work with.