Search found 42189 matches

by chulett
Thu Oct 22, 2015 3:14 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Description of format results from Column Analysis
Replies: 9
Views: 6887

Just a guess here but perhaps... "North America".
by chulett
Thu Oct 22, 2015 9:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date conversion from String
Replies: 4
Views: 2575

Yes but don't use that one. Use IsValid() with the 'Date' option. Oddly enough, they are not equivalent although it seems like they should be. There have been discussions here (that I don't recall the gory details of) about why you would want to check that a date field is actually valid when if it w...
by chulett
Thu Oct 22, 2015 9:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: || Symbol - Append Dynamically
Replies: 11
Views: 3812

I'm assuming he meant something like this, off the top of my head: (If Header_Valid_Flag = 'Y' then '' else Header_Reject_Reason : '||') : (If Footer_Valid_Flag = 'Y' then '' else Footer_Reject_Reason : '||') etc. etc. And then wrap it in something to remove the extra pipes at the end, assuming at l...
by chulett
Thu Oct 22, 2015 8:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date conversion from String
Replies: 4
Views: 2575

You've got the order backwards. First check to see if it is a valid date and then only if it is valid, convert it.
by chulett
Thu Oct 22, 2015 8:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage Variable - Order of execution
Replies: 8
Views: 3346

So... as noted, top to bottom. Did you have a related question on this topic or are we resolved now?
by chulett
Wed Oct 21, 2015 2:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage Variable - Order of execution
Replies: 8
Views: 3346

This has been answered many times over. Have you tried searching on it?



:wink:
by chulett
Wed Oct 21, 2015 7:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: || Symbol - Append Dynamically
Replies: 11
Views: 3812

So... membership expired? Ray spelled out what you needed to do. Have you tried what he posted and have specific questions?
by chulett
Wed Oct 21, 2015 6:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage Variable - Order of execution
Replies: 8
Views: 3346

After 6 years and 700 posts on the site, these are the kind of questions that make me think that DSXchange userids are handed down from generation to generation like a Hummel from grandma. :wink:
by chulett
Tue Oct 20, 2015 3:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: current date time showing differetn then AIX system time
Replies: 3
Views: 2079

If the only difference is the timezone, I would go out on a limb and guess that the answer is 'yes'. If you change it back, does it fix it?
by chulett
Tue Oct 20, 2015 7:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Leading Question Mark Appears on First row of data
Replies: 6
Views: 3870

We copied the file to the FTP Server without any suspicious characters I'm guessing it's actually there, you're just not able to see it. Have you dumped the hex values in the file? On a UNIX system you could do an "od" or Octal Dump on it, for Windows there are any number of free Hex Edit...
by chulett
Tue Oct 20, 2015 7:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: HOW TO INVOKE THE DsSetUserStatus routine?
Replies: 4
Views: 5296

The Job Control window contains code that runs before anything on the canvas does and thus has no ability to leverage values generated during the job run. For this task you'd really need to do it inside the job via the interlude process that Ray mentioned. You could possibly do this as a custom rout...
by chulett
Mon Oct 19, 2015 10:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle 12c compatibility with DS 9.1 and DSODB database
Replies: 2
Views: 2191

They've always been "forward compatible" like that.
by chulett
Mon Oct 19, 2015 9:41 am
Forum: General
Topic: Error while exporting the entire projects
Replies: 21
Views: 7352

Creating directories on a UNIX system with spaces in their name is generally considered... silly. I assume you're going to either need to quote the pathname (same as you would when working with it from the command line) or use a wildcard in place of the space. Perhaps GL?Premises would work. [shrug]...
by chulett
Mon Oct 19, 2015 9:33 am
Forum: General
Topic: How to search Job in DataStage 7.5
Replies: 2
Views: 987

Define for us what "search job" means to you. Please.