Search found 42189 matches

by chulett
Fri Jun 10, 2011 1:19 pm
Forum: General
Topic: Data and Time for the sequential file.
Replies: 10
Views: 2383

As noted, remove them if you don't want them in the final output:

Code: Select all

Convert("-:","",OCONV(DATE(), "D4-YMD[4,2,2]"): '_':OCONV(TIME(), "MTS"))
by chulett
Fri Jun 10, 2011 1:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple columns update
Replies: 13
Views: 3906

prasad v wrote:Hi Chulett,

Unfortunately i have created this thread in General forum. Can you please move this thread to Parallel extender forum.
:wink:

Done.
by chulett
Fri Jun 10, 2011 6:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reindexing V8 ?
Replies: 7
Views: 3010

I'm not really sure, hence my lack of specifics in the hope someone else would respond. We know sometimes there's a concurrent license issue if we are talking jobs with transformer stages - i.e. only one C++ compile at a time is allowed so it's not that it takes longer to do the actual compile but r...
by chulett
Thu Jun 09, 2011 11:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reindexing V8 ?
Replies: 7
Views: 3010

There are several posts here on the subject of "RTLogging", for example one here. That won't help speed up compiles, however. Nor would reindexing.
by chulett
Thu Jun 09, 2011 8:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem when calling SP stage
Replies: 12
Views: 6368

Always good to make sure you are up-to-date on fixpacks. :wink:
by chulett
Thu Jun 09, 2011 4:40 pm
Forum: General
Topic: Can't open active stages
Replies: 3
Views: 1088

That's a very old piece of information related to the fact that installing Service Pack 2 for Windows XP broke certain things in DataStage. Seeing as how SP2 was released seven years ago, I doubt it caused your issue. I'm sure there would have been a less drastic solution but restoring your last O/S...
by chulett
Thu Jun 09, 2011 8:21 am
Forum: General
Topic: Hiding password when executing istool command
Replies: 2
Views: 1570

Those would be a "file descriptor" much like a handle. I don't have time to do this reply the proper justice it needs but a google on the subject of reading files in shell using file descriptors should help. Andy did say "something like this" when he posted it from what I recall,...
by chulett
Thu Jun 09, 2011 7:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reindexing V8 ?
Replies: 7
Views: 3010

What is going on? What is making you feel that you need to 'reindex' anything?
by chulett
Wed Jun 08, 2011 7:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to convert special character in Datastage Transformer
Replies: 8
Views: 11076

D'oh! For some reason when I transcribed a post I found on the subject, I ended up typing 'installed' when it said 'activated'. :(
by chulett
Wed Jun 08, 2011 7:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job aborted
Replies: 1
Views: 1001

You can help you. An exact search for "because of a prior component with the same name" will find how other people have solved that problem. The last error should be self-explanatory, but you could also search for it here and google will turn it up as well.
by chulett
Wed Jun 08, 2011 8:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Table Lookup Problem in Server Job
Replies: 7
Views: 2208

To me, that would imply that you've never had a lookup fail before, something hard to believe. That or your looked up fields weren't targeting required fields in a database.
by chulett
Wed Jun 08, 2011 7:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Table Lookup Problem in Server Job
Replies: 7
Views: 2208

Seyed wrote:Assuming that attempts are made to first insert the rejected data into the Oracle table and then to the rejected file
ps. Not an assumption... How It Works. :wink:
by chulett
Wed Jun 08, 2011 7:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Table Lookup Problem in Server Job
Replies: 7
Views: 2208

Be proactive rather than reactive - make sure your required fields are non-null before sending the row off to the database.
by chulett
Wed Jun 08, 2011 7:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Table Lookup Problem in Server Job
Replies: 7
Views: 2208

Without posting your actual full error messages, I'm assuming what you are seeing are the records first being written to the database where they are rejected for the reason you noted and which are then written to the reject link.
by chulett
Wed Jun 08, 2011 6:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: non-zero status 1 from APT_PMpollUntilZero
Replies: 3
Views: 5770

Let's get you into your own post rather than riding on the coattails of a three year old one. FYI, it had a subject of "About Section Leaders" hence Ray's reply.