DSXchange

There's no default value for invocation ids. Create a Sequence job or some other form of job control to run the job 4 times with your invocation id values.

Does the job work with the password parameter if you don't call it from a Sequence but just run it from the Director?

Tony, you're probably gonna get whacked for posting in the wrong forum, but be that as it may... I'm assuming the 8.1 client installed to a separate, completely different location than the 7 client - yes? As in nothing of the original installation was overwritten by the new one? Almost forgot, does ...

You have this problem / error with viewing all sequential files or just this one particular file?

Again, since your alleged 'only change' was the T30 one, as a test change it back. Only way to get that off the table as a suspect.

That makes sense. Your original syntax made everything in the quotes a literal so it was looking for the literal string "'ORCHESTRATE.FIRSTNAME%" (including the percent sign) and not resolving the field reference or seeing the wildcard.

Well... the biggest difference between the two is that you are comparing a chunk of procedural language code with what is in essence a single DML statement. The code is doing more work, at its core - get the current value, increment it, write the updated record back. The DML just updates a single re...

D'oh. I own a registered copy of UltraEdit and didn't know you could use it for that. Learn something new every day.

There's no way to do that in DOS ("on local") that I am aware of without loading third-party tools or writing C programs and the like. With PX you should have the MKS Toolkit installed on your 'server' and thus have 'UNIX' capabilities there. Try "sort -u" to get unique records. ...

chulett wrote:is it "job" or "jobs" that you have this problem with?

Since you used both words in your post. This is a problem with a single job, all jobs, only certain jobs?

:idea: OK, by now you've discovered 'bteq' and jumped into a couple of other people's posts. Let's come back here. Do you not have access to Teradata people where you work that could help you with the syntax you need to accomplish this? It really has nothing to do with DataStage - first get your 'sc...

By going back to your own post on the topic and not jumping into anything you can find where Teradata is mentioned. Post there what you are trying and what isn't working about it.

Sure, shell script is one way. Use the Execute Command stage to run it and then as many triggers to Job Activity stages as you have values, each constrained to a particular value.

Free for the installing from the client cdrom.

Stored in the repository. What 'performance statistics' are you after? Basically, you'd use the API to retrieve them - either using dsjob from the command line or the various DSGet* routines.