DSXchange

Please post in the correct forum, this is not certainly not a FAQ. Guys - either ask someone to post in the correct forum and then move on or just provide the answers. Doing both doesn't incent any kind of corrective behaviour. I'd suggest you inform them they are in the wrong forum and let them kn...

ArijitS wrote:I want to design a job with infinite loop.

No, you don't. Why don't we start by you explaining the problem you are trying to solve instead?

First thought - the concept of anything running 'continuously' was dropped in the last handful of posts made in 2006 so there really isn't any problem here to solve. I understand we're off to 'What If' land, however. Secondly, there's no 'exclusive lock' that I recall. You can open up and purge the ...

Sorry, I was thinking of another stage. If you click on the Help button and then on the DSN on the help page, it will tell you where those values must be defined:

This lists all the ODBC data sources defined in the Windows registry for Windows servers or the uvodbc.config file for UNIX servers.

More of a 'reset' than a 'set', per se, but perhaps it will help:


YourSequenceName is the 'key' to reset.

? is the value to reset it to.

Hmm... ok, didn't realize that. Will Parameter Navigator do what the OP asks?

eostic wrote:This software is capable of polls, I believe.

Yes, definitely. And I tease Roy about this at times, because he is our resident Poll King.

Get them into ISO format - depending on if they have a time component or not, either:

YYYY-MM-DD
YYYY-MM-DD HH24:MI:SS

One or the other, not a combination. Then they can be compared directly using your normal operators.

I want the fields to be stored in the database as right justified... Um... why? One generally doesn't worry about 'justification' inside a database. Perhaps if we were talking about a flat file with specific requirements on string fields, but since we're not... You need to do this or just want to d...

Parameter Manager.

The KBA Job Control Utilities.

Seems to me there's a difference between 'exposing jobs' to a Web service versus as a Web service, yet you've seemed to use both interchangeably. Which of the two are you actually asking about? Or is it both?

That can work as well. I tend to forget out the 'Link' stages, the Collector will allow the creation of your single writer process. I find the extra overhead of needing to use the 'Sort/Merge' option if you care about the output order to not be worth it, however. But that's a personal preference. Us...

Well... there you go.

That's what I was afraid of. You need to understand that sequential files need to be accessed sequentially, it's the nature of the beast. This means while a sequential file can support multiple reader processes, it can only support a single writer process. This is not a 'DataStage restriction', it i...

Not nearly enough information.

How did you setup the stage to 'read 4 files'?