DSXchange

Or just:

Index.

Is Field() available in PX? If so:

Isn't one of the 'tricks' a recompile of the base job? I don't have this issue but I seem to remember that being one of the ways to clear all those invocations from the Director.

Nothing 'weird' about this. Are you not aware of the need for a C++ compiler when using the Transformer stage? You need to ensure you have a supported compiler installed and configured correctly.

It is 'working fine' when the RDBMS stage is set to what - Oracle? ODBC?

Suggest you contact your Support provider. That is a vendor supplied utility and they really are the only ones that can help when it has problems. Hmmm... You aren't trying to run this anywhere except your 'dev' project, are you? Meaning, you aren't running this on protected / read-only jobs in othe...

Exactly, it uses 'standard' Windows selection techniques - shift-click, control-click, etc. Even easier if you need to delete an entire category.

How are you 'scheduling' - via Director so cron? Is the scheduling being done under the same user as the manual run?

Define what you mean by 'connect an ORACLE stage in DataStage'. Be specific.

I'm going to go out on a limb and disagree with Ray. The loop has no idea that you think you are working with 'time' values - they are just numbers. In fact, those IConv statements translate to this: From: 42120 Steps: 1 To: 42300 So you've got the same thing as if you had interated from 1 to 180. I...

Suggest you contact your support provider. Googling for your message seems to indicate this may be a bug. Hard to say, though.

For a decidedly bare-bones design, there's nothing wrong with it. It runs the job in a loop until the end condition for the loop is met. Now, unless that's a new feature of 8.x I don't see how the loop stages understand your 'Time' based user variables. Are they in internal format? Are they actually...

Why post this twice? Delete the other post before people reply to it, please.

The Field function will do the job for you, check the online help.

Why worry about how difficult to transition from Informatica to DataStage. Because not all people will be able to make the transition. Sure, it really shouldn't matter but you'll find people still wanting to shove their square peg in your lovely round hole, complaining all the time that it ain't th...