Search found 42189 matches

by chulett
Thu Oct 09, 2008 1:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Promoting jobs across partitions
Replies: 6
Views: 1924

Since it's client based, it doesn't matter where any given project is located. Connect to the Version Control repository on your original server like normal, then when you promote change the 'Host system' value in the 'Attach to project' dialogue box. The first time you'll need to actually type the ...
by chulett
Thu Oct 09, 2008 1:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date type conversion
Replies: 5
Views: 1150

What "date format" do you need? There's always an IConv/OConv pair but if your incoming format is consistent then substring should be fine. For example: YourField[1,4]:"-":YourField[5,2]:"-":YourField[7,2] To change YYYYMMDD to YYYY-MM-DD.
by chulett
Thu Oct 09, 2008 1:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: replace ??? values with space
Replies: 5
Views: 1741

Trim, EReplace and Convert will all work fine. For example:

Code: Select all

Convert("?"," ",YourField)
by chulett
Thu Oct 09, 2008 12:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi Instance Jobs
Replies: 6
Views: 1725

Is your 8.x release all patched up? Installed the 'fixpack' that is available?
by chulett
Thu Oct 09, 2008 12:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Character field
Replies: 5
Views: 2605

:? A CHAR field automatically pads with spaces to the full length, that's the nature of the beast. Either match the field size in your test, use a 'like' wildcard comparison or trim it in the expression.
by chulett
Thu Oct 09, 2008 11:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Promoting jobs across partitions
Replies: 6
Views: 1924

:? This change shouldn't change your process at all, other than the fact that when you promote to Production, you'll point to the new 'partition'.
by chulett
Thu Oct 09, 2008 11:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issuing dsjob -logdetail
Replies: 5
Views: 8567

Hmmm... you get the event id by using -logsum first, not by looking it up in the Director.
by chulett
Thu Oct 09, 2008 10:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to move multiple jobs from one folder to other
Replies: 3
Views: 1064

True, forgot how restrictive the Designer Repository browser is. It is geared for working with one job at a time while the Manager is for managing... well, everything. :wink:

Please mark your post as Resolved!
by chulett
Thu Oct 09, 2008 9:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to move multiple jobs from one folder to other
Replies: 3
Views: 1064

Through the Manager or Designer GUI. What issue are you having? It supports all the normal Windows conventions, so ctrl-click and shift-click are your friends here.
by chulett
Thu Oct 09, 2008 9:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issuing dsjob -logdetail
Replies: 5
Views: 8567

Your syntax is invalid, which the error pointed out. The -logdetail function requires at least a 'first event id' and optionally a 'last event id'.
by chulett
Thu Oct 09, 2008 7:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with date...
Replies: 3
Views: 1525

:? What 'characters' are you getting? How about posting some examples?
by chulett
Thu Oct 09, 2008 7:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Execute command stage error
Replies: 7
Views: 1654

Great, please mark your post as Resolved then, using the button at the top of the screen.
by chulett
Wed Oct 08, 2008 8:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can User Variable Activity be Checkpointed?
Replies: 2
Views: 1195

You mean there's no option to "do not checkpoint"... and you'd have to ask IBM why that is the case.
by chulett
Wed Oct 08, 2008 8:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Use of 'Not' Condition
Replies: 10
Views: 2073

The reason I asked hashed v. database is the use of the NOTFOUND link variable only works reliably for a hashed file. Something to keep in mind.
by chulett
Wed Oct 08, 2008 7:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restore purge settings
Replies: 10
Views: 2582

Interesting... that makes sense but I don't recall anyone explaining it like that. I've always assumed I had to put them back (which is no big deal) or they would be gone forever. 8)