Search found 42189 matches

by chulett
Sat Dec 01, 2007 6:43 pm
Forum: General
Topic: Error log Routines
Replies: 2
Views: 1189

I'm sure many do. However, you will need to explain in detail what exactly you mean by 'error log routines' - particularly your definition of 'error log' in this context. The routine part we got. Post your question once in one forum. I suggest you delete the other two posts before we end up with thr...
by chulett
Sat Dec 01, 2007 8:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KeyMgtGetNextValue
Replies: 7
Views: 2695

That would be because you only moved the jobs to the new server and not the hashed file these values live in, namely SDKSequences, which lives in each account a.k.a Project. So it created it new and started everything back at 1. You could move it now if it's not 'too late'. That or search the forum ...
by chulett
Sat Dec 01, 2007 8:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Look up Query with OR condition getting error ORA 1008
Replies: 7
Views: 1895

so

Mark fields as Key fields to allow their use in the where clause. And while you can certainly use an 'OR' in the Key Expression, it needs to be an assignment statement not just an expression. So...

Not good: "A or B"
Good: If X = "A" or X = "B" Then "Y" else "Z"
by chulett
Fri Nov 30, 2007 9:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: copy command
Replies: 2
Views: 996

No clue what you mean by the 'DESCRIPTOR FILE', sequence files shouldn't have any such thing. While I suppose you may be able to use orchadmin to copy text files, I don't see why you would need to. Just use your normal O/S level commands for text files.
by chulett
Fri Nov 30, 2007 9:49 pm
Forum: General
Topic: missing image in report
Replies: 4
Views: 1281

I would have mentioned that, but it doesn't block the canvas image, or at least not in my experience. You have to allow the ActiveX component to get silly things like the derivations to appear, but you shouldn't really have to do anything special to get the image of your canvas displayed. AFAIK :?
by chulett
Fri Nov 30, 2007 9:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Look up Query with OR condition getting error ORA 1008
Replies: 7
Views: 1895

Re: Look up Query with OR condition getting error ORA 1008

Then in transformer we are adding expression from input link which is mapped to curr2 field. link1.curr or link1.quote_curr While not the cause of your error, but an error none-the-less: do not put expressions in your Key unless all you truly want to populate it with is TRUE or FALSE, i.e. 1 or 0.
by chulett
Fri Nov 30, 2007 5:13 pm
Forum: General
Topic: missing image in report
Replies: 4
Views: 1281

However, the answer to your question as asked is "no".
by chulett
Fri Nov 30, 2007 5:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Load Audit tables in Shared Container
Replies: 3
Views: 1337

Click on the "Visit poster's website" link in Kim's post and go to his "Tips and Tricks" page. It will be availble there.
by chulett
Fri Nov 30, 2007 10:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: position and count
Replies: 6
Views: 1527

Ah, that's different. Examples help. Count() counts the number of occurances of a specific substring in a string. Count the spaces and add 1 to get the number of 'words' or 'fields' in the string. Squish it first if there can be more than a single space delimiting them.
by chulett
Fri Nov 30, 2007 10:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: position and count
Replies: 6
Views: 1527

Sorry, no. Read the help for the Count() function. Or better yet, build a test harness routine in the Manager and try it out for yourself.
by chulett
Fri Nov 30, 2007 9:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: position and count
Replies: 6
Views: 1527

How to count number of substrings in a string? Count()
How to find the starting position of the string? Index()
by chulett
Fri Nov 30, 2007 8:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Query regarding merge stage
Replies: 1
Views: 1063

Welcome.

Seems to me that it would depend on the Unmatched Masters Mode setting. The default of 'Keep' could be thought of as a left outer join, while 'Drop' would equate to an inner join.

That from the Parallel Job Developer's Guide pdf Merge Stage chapter.
by chulett
Fri Nov 30, 2007 8:12 am
Forum: General
Topic: Regarding director
Replies: 2
Views: 917

'Special characters'? Can you be more specific, so that future searchers have some idea what exactly caused this error? That and actually mark the topic as Resolved, please.
by chulett
Fri Nov 30, 2007 8:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with update existing rows and insert new rows in SQL
Replies: 2
Views: 1101

Welcome. :D First bit of advice would be to avoid the 'combo' Update actions. Best Practice is to evaluate inserts versus updates and use separate links for each action. Secondly, it's not about the first action 'failing' per se. With an update, it should only execute the insert if the update does n...
by chulett
Fri Nov 30, 2007 7:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: To spilt the year to Months
Replies: 4
Views: 1250

Of course you can 'generate rows', all that needs is multiple output links from a transformer. That or you simply source from a transformer with the appropriate constraint. Your requirement isn't exactly clearly stated. However, it seems like Kirtikumar might have it right. If I was doing this, I'd ...