DSXchange

You shouldn't have to find anything, just ask your admin to ensure your scheduling user is setup correctly.

irshanuddin wrote:Or should I go looking for the cron.allow and at.allow as suggested in other posts?

Yes.

Sure you do. You seem to be missing my questions and advice around the key in the hashed file. Do you have a hard-coded value like 'x' in the key and the MSGID value as a data element? Based on your description of what's happening, I'd say you're ignoring that little nugget and simply checking the c...

Elisabete, you posted this question in multiple forums, a practice frowned upon here. I've deleted the duplicate posts, we'll use this one going forward.

There is a Job Report button in the Designer, have you tried that?

All my 'hints' still apply. However, you really need to post specifics of what you are doing. How exactly did you design and populate the hashed file? Does it have only a single record in it? Did you hard-code the key and put your BigInt as a data field? What is your constraint on the output link? D...

Seyed wrote:Are there any features in DataStage Designer in a server environment that one could use to add partitions to Oracle tables?

No.

You've misread the requirement I'm afraid.

First off, how are you populating the hashed file? For a single row that you need to look up on every row, make sure you have a hard-coded value as the Key (I've seen "1" or "X" used but "Rumpelstiltskin" would work, too :wink: ) and the timestamp is the data field bein...

So, what was the actual resolution? Posting that information helps future searchers...

Contact your official support provider. That and probably undo whatever change you just made.

pandeesh wrote:Where is that picture?
it's missing now.

Still there for me. If you ever wonder where a posted image comes from (on any web board) 'reply with quote' and then you can pull the URL from the quoted text.

Ah yes, did this actually get documented anywhere? It goes at the beginning of the Parameter property according to the 3 posts here that mention that little secret.

However, I've been places that add partitions 'on-the-fly' as needed. And yes, it generally turns into a proc that either gets called 'when needed' or one that is smart enough to know if it needs to add new partitions or not. You can use a dedicated Stored Procedure stage or the Before SQL area of y...