DSXchange

ecclesr wrote:When I first attemped to schedule the job - I did get permission issues - they have been resolved

I've been wondering what this means, what 'issues' you had and exactly how they were resolved. May help narrow this down...

We have Toad for Oracle and they're displayed under the "Database / Administer / NLS Parameters" menu option.

Sounds like you need to brush up on how the sequencer works. Set it to "All".

You don't, it knows what to do based on the checkpoints in the sequences. You do have checkpoints enabled in all of them, yes?

Of course, thanks. Got a little distracted editing the code.

As noted, it will if you let it - hence the suggestion to use 'unconditional' triggers to the sequencer.

Of course but the other syntax is usually easier for beginners to understand. Besides, who said anything about a output link constraint expression? :wink: Tweak like so to treat the result as a Boolean: If Index(lnk_Cast.BASEBALL," ",1) then <space found logic> else <space not found logic>

So... if the first character is alphanumeric then do something else do something else? And not at all clear on what you mean by "a different field". What about your expression "is not working"? To me it looks like you want to set the result to NULL if the first character is alpha...

Why don't we start by you spelling out in words what it is you are trying to accomplish, your requirements here.

No problem.

Of course, a Server job would be great for that step or you could even use SQL from the command line if you wanted to go a little crazy.

It's just a plain old flat file, so a job that selects it from the table and writes it out in the proper format to the file would do the trick.

Welcome! Sure, several... and the choice can depend on your familiarity with the tool. Off the top of my head: 1. For parameter sets using value files, write directly to the value file 2. Job writes it to a regular flat file and Sequence job reads and passes it 3. Server job writes it to USERSTATUS ...

Time to involve support, it would seem.

For a grid environment, sure. Otherwise...