DSXchange

A null pointer exception is (generally speaking) a code issue, I for one would make sure you have the latest and greatest version of istool.

Sure, that will happen automatically based on the "grain" of the key values sent. It will update however many records have that key value, be that one or more than one, no different than any other SQL tool.

The "normal" ones are there - Array Size, Autocommit Mode / Record count, etc. What settings are you using? I'd also be curious what "Write Mode" you are using.

They're called Reject links in server job Transformer stages, and you can have more than one and, conditionally or unconditionally, they handle any row that has not been processed by a prior output. Right and I've had plenty of experience over the years to play all kinds of reject row games. I was ...

Sounds like a bug, something you should report to your official support provider and see if it is a known issue with a patch or other resolution available.

Ray has Server versions of those kind of functions available on his site, which he has posted before. I don't have a direct link right now. Otherwise, you'll have to do what he did - roll your own. Split the timestamp into date and time portions and treat each difference separately using IConv. Comb...

Create a job that reads the table and writes the values out to the appropriate value set file(s) in the appropriate format.

Can anyone else confirm or deny if it is possible to specify multiple Otherwise links and have them 'stick'? The wording in the documentation seems to imply that you can have more than one, or at least doesn't rule out multiples. This from the 7.5 docs: Clicking on the Otherwise/Log field so a tick ...

Show them (your Admin) the command that was logged and what might be wrong with it.

Moved this over to the SOA Forum...

This "new environment"... what else is different about it other than the version of DataStage? If this is a completely different server then you don't really have an "apples to apples" comparison of just 7.5 versus 8.5.

I've scheduled many many jobs on this server ! Understood. However, the question is - have you used the every option for "many many jobs" and it has suddenly stopped working or is this the first time you've tried to use it? Do you have someone who administers that server that you can shar...

Why not take your questions to your official support provider and then let us know what you find out "from the horse's mouth" as they say. We're just like you - on the outside looking inside - why not ask those who know what's going on on the inside?

Welcome. What exactly is in the ssequential file? Name/value pairs, I assume? Regardless, what you'll basically need is something to read the file and then assign those values to the parameters either before you run the job or as you launch it. The former approach would all be handled via the API in...

selina_king wrote:both of peddakkagari and jwiles are right. but I have another idea to resolve the problem.

you can user transformer stage and use "null handing" function, you can set any value when is null

Note, however, that nowhere in their problem statement is the word "null" mentioned.