Search found 15603 matches

by ArndW
Fri Mar 14, 2008 3:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help regarding Datastahe
Replies: 3
Views: 808

Let us close this thread and just use this Parallel thread instead.
by ArndW
Fri Mar 14, 2008 3:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ to MQ - Realtime batch processing
Replies: 9
Views: 3249

Wouldn't this be a case for "wave processing"?
by ArndW
Fri Mar 14, 2008 3:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we write to XL files using a DS job
Replies: 1
Views: 578

If you have DataStage on UNIX, then an ODBC connection product will let you write straight to an Excel file on a Windows box. Otherwise I would just create a .csv file as you have suggested, then open that up in Excel.
by ArndW
Fri Mar 14, 2008 3:05 am
Forum: General
Topic: Which forum should i post?
Replies: 2
Views: 856

I'd put it in the PX forum or here - and since you've opened this thread up already I suggest you just ask away here
by ArndW
Fri Mar 14, 2008 3:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Compile time
Replies: 1
Views: 1494

The inclusion of transform stages can slow down compilation, particularly if the c++ compiler user license limit is low (i.e. 1). You can check that by compiling a large job with no transform stages - if it is fast then you have located the bottleneck.
by ArndW
Fri Mar 14, 2008 2:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating a proect from Commandline
Replies: 5
Views: 1095

Version 8 allows project creation from the command line, prior versions do not.
by ArndW
Thu Mar 13, 2008 11:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Notification activity - blank file as attachment
Replies: 6
Views: 1584

I saw one post recommending changing the Outlook default Internet message to "both" (that would be RTF and HTML) and that solved the problem. I think that is what I did as well.
by ArndW
Thu Mar 13, 2008 11:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Notification activity - blank file as attachment
Replies: 6
Views: 1584

dspxlearn - my Google here always goes to German (not English) pages so I can't help you much. You can try to search for "outlook att attachment" and you'll get a lot of hits - hopefully one of the first ones will contain the answer. If you do get a definitive answer please do post it.
by ArndW
Thu Mar 13, 2008 10:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set a warning limits to a subsequence in a master sequence
Replies: 4
Views: 1459

The Job Activity stage does not cater for changing the warning levels. The two options that come to mind are (a) Write your own user activity BASIC routine that uses the standard API calls and explicitly change the warnings allowed {hint - put a job activity stage in a sequence canvas, then look at ...
by ArndW
Thu Mar 13, 2008 10:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running jobs on different config files
Replies: 6
Views: 1187

Ok, define 3 parameters to your sequence, "APT1", "APT2" and "APT3", then use those values in your job activity stages.

the $APT_CONFIG_FILE is a reserved parameter and cannot be changed in the way that you are suggesting.
by ArndW
Thu Mar 13, 2008 10:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running jobs on different config files
Replies: 6
Views: 1187

No, that isn't what I meant. Ignore the $APT_CONFIG_FILE for the job sequence, just pass explicit strings for the $APT_CONFIG_FILE values in the Job Activity stages themselves.
by ArndW
Thu Mar 13, 2008 10:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IN / NOT IN functions
Replies: 5
Views: 1375

You can use the INDEX() function, i.e.

Code: Select all

INDEX('TER,RET,RWP,TWB,TWP,',r_tes.action:',',1)
will return a 0 if it isn't "in" the set or a positive integer if it is.
by ArndW
Thu Mar 13, 2008 10:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Notification activity - blank file as attachment
Replies: 6
Views: 1584

This is something that Microsoft Outlook does; I remember finding a MS page on how to change that behaviour a while back.
by ArndW
Thu Mar 13, 2008 10:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running jobs on different config files
Replies: 6
Views: 1187

Use the path to each of your 3 different config files as the $APT_CONFIG_FILE parameter for the Job Activity stages.
by ArndW
Thu Mar 13, 2008 8:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How Datastage EE 8.0.1 treats multiple core CPU's with nodes
Replies: 6
Views: 2478

The number of physical (or virtual) CPUs in a system and the number of nodes declared in a config file have nothing directly to do with each other. You can declare a 64-way config file on a 1-CPU system or a single node configuration on a 64 processor system and pretty much any value in between. The...