Search found 42189 matches

by chulett
Wed Feb 20, 2013 2:48 pm
Forum: General
Topic: how to encrypt a note by notification activity
Replies: 6
Views: 1406

Ah, ok... Lotus Notes. Been quite some time since I've used that. :wink: Going to ask again and if you're not sure of the answer you'll need to find someone on your Notes team to answer this - what kind of encryption do you need to use? There are many different methodologies, that's why you can't ju...
by chulett
Wed Feb 20, 2013 9:14 am
Forum: Data Integration
Topic: Processing Oracle CDC change tables
Replies: 3
Views: 10095

It's been years since I dealt with that so the details are a little fuzzy. However, we did have the archive logs shipped off to a standby server where we were subscribed to the change tables. I believe there was a Control-M process that "extended the window" to the latest set of changes an...
by chulett
Wed Feb 20, 2013 8:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Trying to Connect to Universe database - FAILED
Replies: 11
Views: 4406

So... how in the heck did you end up with DOS delimiters in your file? Are you transferring them to a PC for editing and then transferring them back rather than editing them directly on the UNIX server? If so, you needs to learn yourself some vi. :wink:
by chulett
Wed Feb 20, 2013 8:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Primary Key Query
Replies: 5
Views: 1225

The column you choose for a 'key column' i.e. the column(s) that should be part of the where clause, have nothing whatsoever to do with the PK (or lack thereof) on the table. So what are you doing besides updates? How have you configured the target stage? What stage are you using? Just as an FYI, th...
by chulett
Wed Feb 20, 2013 8:09 am
Forum: General
Topic: Sequence Restartability in case of Routines
Replies: 6
Views: 2203

Sorry but that's not the way it works around here. You can see enough right now to solve your problem... and you could always try looking through the documentation. As noted this is all explained there with specific examples.
by chulett
Tue Feb 19, 2013 9:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Trying to Connect to Universe database - FAILED
Replies: 11
Views: 4406

The UV stage wouldn't return that error as far as I know. What happens if you use the UV stage as a source and select "localuv" as the data source? I don't recall if you can select that from a list or if you have to type it in but it should work just fine.
by chulett
Tue Feb 19, 2013 9:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Trying to Connect to Universe database - FAILED
Replies: 11
Views: 4406

Well... then we're not only in the wrong forum but your job type in your initial post is wrong. Let me fix both of those.
by chulett
Tue Feb 19, 2013 5:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Trying to Connect to Universe database - FAILED
Replies: 11
Views: 4406

Have you considered using a Server job with the UV stage?
by chulett
Tue Feb 19, 2013 2:49 pm
Forum: General
Topic: how to encrypt a note by notification activity
Replies: 6
Views: 1406

I'm guessing by "note" you mean an email, yes? What kind of encryption are we talking about here?
by chulett
Tue Feb 19, 2013 10:11 am
Forum: General
Topic: Sequence Restartability in case of Routines
Replies: 6
Views: 2203

It only automatically handles the routine if it thinks you did not, this is explained in the documentation. Run two links from the Routine, one "OK" and one "Otherwise" to a Sequencer set to "any" and it won't consider the failure unhandled.
by chulett
Tue Feb 19, 2013 7:48 am
Forum: General
Topic: removed
Replies: 10
Views: 4847

There's nothing "supported" about it.
by chulett
Mon Feb 18, 2013 6:26 pm
Forum: General
Topic: Multi Instance Job - DsJobInvocationId
Replies: 4
Views: 1719

"Does not work" meaning what? It should work just fine as far as I know but you might want to try this instead of what you posted:

Code: Select all

Update TableName Set ColName1 = sysdate where Colname2 = '#DsJobInvocationId#'
But then again it depends on what "does not work" means.
by chulett
Mon Feb 18, 2013 6:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Changing from Single node to Multi node Configuration
Replies: 15
Views: 11532

... and yet we all know that doesn't always work out so well. If you've only ever run everything on a single node and never tested anything on more than that, then I would think you may have some surprises in store.
by chulett
Mon Feb 18, 2013 2:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Changing from Single node to Multi node Configuration
Replies: 15
Views: 11532

One small point - I would not recommend changing your default config. Create a specific X node config (or configs) and leverage those when appropriate.