DSXchange

Still, you should be able to use the Transformer name and the Link name going to the Sequential File stage from there to get how many rows went down it. Same for any Database stage.

Yes, my current project is kicking my butt 24x7 lately, weekends and holidays. I do manage to get online and read everything, but most of the time either can't take the time to reply or just don't have it in me to do it justice. There's always plenty of other folks here that can answer, so not worri...

And maybe it should even specifically exclude a certain number of people from the top of the Top 10 list. And no, don't mean just Ray.

Gee Kim... thanks, I guess.

Don't need no fuss.

No, you would just use operating system commands, batch files or UNIX scripts, for tasks like that.

From the Transformer in front of it. And if you ain't got one - add one.

Ok...

Hello? [tap tap] Is this thing on?

Ok... great. There must be more to the message than that. Please post the entire message, there should be something to say why it failed or what error code it produced.

Ok... who is telling you that data has been truncated? Does DataStage tell you before it sends it to the ODBC stage or does the database stage report the error? If the former, then your actual data is longer than the defined metadata in the job. DataStage will tell you it has been truncated and show...

You are trying to use it where? The fact that it shows in red implies you are in the wrong place or at least on the wrong path. Why don't you let us know what you are trying to accomplish, what your goal in all of this is?

Welcome aboard, maliaydin. One thing to know here is this forum is for Server jobs and the first post in each thread should be marked the same. This means you'd need to stick to Server answers here. Answers relevant to PX jobs would belong over in the EE forum unless someone has specifically marked ...

If you mean the field that triggered the warning, you are pretty much out of luck there. There's no output variable that returns that. You may be able to tell at a high level with some errors, like a Primary Key violation would involve the primary key fields, but most errors are fairly generic. Most...

We ended up doing it Pack-free from PeopleSoft HR and Finance systems. Wasn't too bad as they're 'just' Oracle tables. You would need plenty of support from the Other Side because, as Vince noted, there are alot of tables in a PeopleSoft instance. ALOT. Blew my mind when I first TOAD'd in and had to...

We'll be here!

Uncheck the 'Generate Formatted Output' option.