DSXchange

How did you install it? Optional server plug-ins should be installed by rerunning the server installation. It will go into 'maintenance' mode and allow you to just install any uninstalled plugins. This will not only get it into (if desired) all current projects, but also into the 'Template' project ...

I just went back and checked, and all the parameters to the contained sequence have default values. Moreover, if I go into the stage properties in the outer sequence, I cannot set a value for the Password parameter. Hmmm... you got me on that one. The circumstances I described popped up the same er...

No problem. Just wanted to point out that there is a specific product built to handle 'real time' processing. It was introduced as the RTI or Real Time Integration Services but has since been renamed to be the SOA or Service Oriented Architecture Edition. You'll find a different forum dedicated to i...

Good luck.

You can't. You could only append to a single file if the jobs are run in a serial fashion. Or you could get more sophisticated and separate the jobs from the metrics gathering steps. Gather all of the statistics at once once all the jobs complete. Or fall back on the 'concatenate multiple files into...

Yep its static, if you read back my previous post, i hav mentioned sequential file. Mentioned, yes - as in "(could be Database or file)". However, your original post and question was about ODBC and ROWNUM, which is why you got the answers and caveats that you did. When loading from a sequential fil...

In case you haven't figured this out yet... I played around and was able to duplicate the error message, one I'd never seen before. It seems to be related to a Sequence job running another Sequencer via a Job Activity stage (as you noted) and the parameters the 'sub' Sequencers have defined. Normall...

Exactly. And is the data source static? How do you know, when it comes time to restart, that the order and quantity of rows pulled from the source table will exactly match the failure run?

Land the data.

You buy the 'real time' product, now know as the SOA Edition.

No, the ODBC stage will happily use the branded ODBC drivers that come with DataStage. And is supposed to support Stored Procedures. You'd only need to buy new drivers if you wanted to do this in a routine or via hand coded job control.

Never said the OC stage would work to call a stored procedure. Doesn't mean it won't. I just mentioned it as another way to get data from Sybase. The Sybase OC stage is a native stage, so like the other native stages it requires that the software it uses be installed on the DataStage server. For the...

Google is your friend.

And some of us actually try to read everything, all the way to the bottom. There's plenty I don't respond to, especially when someone else has the problem well in hand. But I do try to read everything and find a wet grey corner to file it all away in.

Of course. Just trying to put some alternatives on the table...

You don't necessarily need to have 100 files - assuming the metadata is identical between them. Depending on your situation, you can write to a single file, appending as you go. That or do what we typically do in this situation - a 'pre-job' step that cats all the files together into a single file. ...

Madhav_M wrote:Is there is any simple way to write this information into a table.

Sure! Write a DataStage job to source the flat file(s) and load them into your table. Anything else wouldn't really fall into the 'simple' category.