DSXchange

You need the fully pathed filename in the filename box and "tail -1" in the Filter, without any quotes. And explain what "not working" means - what do you get? An error?

Well, there's really no need for the "else" in the expresion and "matches" with no wildcards is the same as an equality check, so...

Thought you only wanted to 'process' the file if the counts matched? Would two jobs work, one to validate counts only and one to process it if the counts are ok?

Welcome. That's a pretty standard task for stage variables in a transformer, have you had any experience with that?

ps. All caps is considered SHOUTING. Please don't shout.

Probably a UNIX script before you ever get into a job. Tail off the control record, cut out the number and compare it to a count of lines (minus 1 or 2) from the file itself. (minus 2 if there's a header record with column names)

Something like this should do what you need: P1 -> -> C1 P2 -> -> C2 P3 -> Seq (all) -> C3 P4 -> -> C4 P5 -> -> C5 Etc. Each job activity linked to a single Sequencer set to all, triggers from there to the next set of jobs. Lather, rinse, repeat.

Ah... using environment variables, perhaps?

Why not create the job as a "WISD" or real time job, expose it as a service? Then it truly can "execute continuously" and process messages in real time. Depends on what exactly these "messages" are and how they are (or could be) delivered.

So... the job runs fine but 'view data' does not work? Does the DB2 stage optionally use ODBC or something? Unsure why you'd post that data source otherwise.

Actually, every routine shipped with the product can serve as an example. Double-click on any of them in the Manager to see their source code.

That's true, assuming you can get it over to a Windows box. I tend to forget about that option for some reason, thinking I need to use XMLSpy or some such to explicitly pretty print it.

Unfortunately, it's that or nothing. If you really need formatted output, leave it unformatted in the job and then use a 3rd party "pretty printing" tool afterwards.

That's how it "formats" XML, I haven't found anyone yet that likes it. Curious, why do you think it needs to be formatted? That's really just for peoples, no application should care.

Or at least not set to "False".

Ah... thanks for the clarification.