DSXchange

You really should start your own topic in situations like this. Make sure we have all of your particulars including your actual error message. Please.

Thomas.B wrote:Job parameters can't be null, your job will abort if they are.

From what I recall that's mostly true, it depends on the data type. Some are required while others (like String) are not. Unless this is something they've changed in recent versions.

Hmmm... true about initializations but execution of loop variables was mentioned.

Also, you can see from the posted code that when a constraint evaluates to FALSE, the derivations in the link are not... derived.

Wanted to add that I'm not sure I'd want to see anything about the order it evaluates things be made 'dynamic'. For whatever that is worth.

FranklinE wrote:We use a ssi file to keep all environment variables.

Forgot that this was something I wanted to ask about - "ssi file"? All my searches turn up is a flood of Social Security Income references. Guessing that's not what you meant.

Well... it blocked it as SPAM which it noted in the reject message. However, I don't believe there is currently an official webmaster and AFAIK the only working email is editor@dsxchange.net as mentioned elsewhere in this forum.

There's an echo in this thread, need to get that looked into.

More time than what?

20 million is not that large. Let's start with this. How are you determining which records have been updated? Do you also need to insert new records or are we literally just talking just inserts? Are the columns in your update's where clause indexed?

Reebs - rather than run around and find 'similar situations' to repeat your questions in old posts, come back here and continue your discussion. Post some answers. Works way more better than way.

We can disagree about what he does or does not point out but if you really want to know, go back to the horse's mouth... ask your official support provider for clarification on your specific situation.

Could be a bug in the client or database itself in that version, ran into odd behavior like that with Oracle every now and then over the years. Have you involved your official support provider yet?

Interesting, thanks for posting your resolution.

gayathrisivakumar wrote:But I guess DSxchange users are not only from US

Of course not and not my point, just my situation. I was up working on a production problem (my job job) when I decided to check the site (my volunteer 'job') and would have been happy to help except for the lack of patience.

Almost midnight here on a Friday night and you waiting all of an hour before ringing the doorbell again. It would be great if someone had a little patience.

Is there any way this can be done from DataStage designer without using Java integration? If there was I'm sure Ernie would have mentioned it in the linked post. Also, we need to parameterize the read to pull only delta/incremental data using data parameters. Did you mean date parameters? Does the ...