DSXchange

You are very welcome.

Perhaps it's an O/S thing? Mine is H-PUX 11.11 a.k.a 11i...

:D That's excellent news. Can you now do two things for us to help others who come searching?

Mark the topic as 'Resolved' and actually post a brief description of what the resolution was? Thanks!

Welcome! :D

Typically, concatenation then process the concatenated file. Or a looping Sequence to read the filenames and repeat a processing job once per filename.

No, as I wouldn't do that and so haven't ever built one. And as I noted, I've no clue how one would do that on a Windows server, so I'll leave that exercise to others, if any are willing...

In your shoes I would contact Information Builders, ask them what is going on.

In the job that generates the warnings? Sure, don't see why not as long as it doesn't abort. An after-job routine that checks the interim status and sends the mail directly. No clue how one does that on Windows, on UNIX it could a direct call to 'sendmail' or 'mailx' or whatever.

Umm... why not just use a Routine Activity (or Execute Command) stage at the end of the Sequence of jobs? Inside the current job (after or inside, doesn't matter) you cannot get the 'job status' of the current job as it hasn't ended yet. If what you want is the status of the current job itself, what...

Ah... I was assuming that was the extension, especially since it was written in lower case. Guess that may not be the case. Still, go back to whomever gave you the requirement for guidance. Or at least for guidance as to who in your organization can give you some guidance.

Define 'handle'... and please delete your duplicate posts before someone replies to them.

Whomever told you that you needed to do this should be the one to ask about what it is and guide you on how to do it. Sounds like some kind of Borland/dBase file: m I'm guessing what you'll actually end up doing is generating a delimited flat file (csv?) that is imported by some kind of utility on '...

I've told you how to stop them, there's no magic switch to turn the warnings off that I've ever heard of. And something is not getting updated or it wouldn't tell you '0 rows affected'. Seems like you'll need to do something like select a count for your where condition first, then only update if the...

You start by posting in the correct forum. This ain't it for Parallel jobs.

There's no such thing as 'Excel for UNIX' so not sure why there should be an ODBC driver on UNIX for Excel. Besides, they've got to be one of the worst data sources you can use. Did you check Data Direct or whatever their name is now for one? Or perhaps Information Builder's iWay software for one of...

There's no 'Array List' in the Oracle stage.

Another generic interview-like question.