Search found 42189 matches

by chulett
Sun Oct 02, 2005 7:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: updating hash file
Replies: 4
Views: 897

Well... of course! :lol:
by chulett
Sun Oct 02, 2005 1:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: checking 'running' status
Replies: 9
Views: 2590

I'm not sure that this is something that someone 'new to DS and Basic' should be attempting, snippet or no snippet. Is there anyway to build what you need through the GUI - i.e. as a Sequencer job? It may not need to behave exactly as you've outlined in your post, and will be easier to maintain and ...
by chulett
Sun Oct 02, 2005 1:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Multi Instance Job
Replies: 13
Views: 2935

This isn't all that complicated, guys. You do not need a Job Parameter and you can use the macro directly in the 'File name' field of the Sequential File stage. The only odd thing is you must wrap it in pound/hash signs as if it were a Job Parameter. So, try... E:\OutputFiles\MergeFile#DSJobInvocati...
by chulett
Sun Oct 02, 2005 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fata Error:Non-virtual data set
Replies: 2
Views: 2343

Search is your friend! :wink:

See if this helps.
by chulett
Sun Oct 02, 2005 7:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: updating hash file
Replies: 4
Views: 897

In other words - just write to it. Hashed files are "destructive overwrite", meaning that when multiple records are written with the same key into the hashed file, each completely replaces the previous version. Therefore, last one in wins. That should also lead you to understand that there is no way...
by chulett
Sat Oct 01, 2005 8:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to create a user in DataStage.
Replies: 9
Views: 11567

User identities are not created in DataStage at all. I was wondering when that little tidbit was going to get mentioned. There really isn't any such thing as a 'DataStage user'. There is, nonetheless, lots of sage advice in the previous posts. Agreed - and scripts to boot! Best sage advice of all -...
by chulett
Sat Oct 01, 2005 8:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Renaming a Project
Replies: 25
Views: 6869

I really don't understand why people feel the need to come and post the exact same answer that's already been posted. Sometimes multiple times. And in case it was too subtle or something, my one word answer was (and still is, even in the quote) a URL link to a post asking the same question with an e...
by chulett
Sat Oct 01, 2005 8:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: User-Defined SQL behaves differently in 7.5.1A
Replies: 16
Views: 3702

newtier wrote:We had a couple surprising experiences while testing the upgrade to 7.5.1a (from version 6.x...).

Which specific stage(s) are you referring to?
by chulett
Fri Sep 30, 2005 11:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Renaming a Project
Replies: 25
Views: 6869

via wrote:Is there some thing i am missing to do for importing the Environment variables while doing whole project import?

Yes
by chulett
Fri Sep 30, 2005 7:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can we use any other stage other than MSOLEDB
Replies: 6
Views: 1463

Hey - it's not always Ray that answers. :lol:
by chulett
Fri Sep 30, 2005 6:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to delete job categories
Replies: 3
Views: 1038

Use the tool, Luke

Which is why - IMHO - that one should do things using the 'proper' tool. In spite of the fact that you can do these things from inside Designer nowadays, I espouse use of the Manager for the operations noted above and the Director for the actual running of jobs. Of course, that could just be the 'ol...
by chulett
Thu Sep 29, 2005 9:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compiling jobs in datastage 6x
Replies: 16
Views: 4355

You're right, this was a CompileAll and a CompileAllPlus from what I recall. Should still be out around there somewhere...
by chulett
Thu Sep 29, 2005 9:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compiling jobs in datastage 6x
Replies: 16
Views: 4355

Yes! :lol:
by chulett
Thu Sep 29, 2005 5:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compiling jobs in datastage 6x
Replies: 16
Views: 4355

ketfos wrote:Is multi compile option available in version 7.0 and below.

Available in 7.0? Yes. Below? No.
by chulett
Thu Sep 29, 2005 1:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Execute command activity
Replies: 1
Views: 977

Doesn't really matter - put the whole command in the Command box or split it between them as you think is appropriate. As far as I know, it just sticks the two halves together and then runs the result.

And no - no 'prefix' needed.