DSXchange

That would be part of the 'fine' part.

It's not published but you can do a LIST.DICT on it to see the metadata.

No worries about your English, you wouldn't even want to hear my Italian.

I'm not certain but I think it is now. I'm pretty sure that the last couple of 8.1 installs I was involved with briefly were actually on VMWare. Hopefully, someone knows for certain.

Do you get any indication in the log that the job even tried to start? Or does it look like absolutely nothing happens when the time comes? For the latter, talk to an SysAdmin. Former, support.

Your schema file doesn't match the input file. Specifically, there's more columns in the schema than in the file or you may have a delimiter issue.

I know that's an issue for AIX, are there other UNIX flavors with the same limitation?

It would work just fine.

Just want to make sure you're aware why that worked. It's because what you actually have there is a CR/LF pair. You see the CR in the data and the record break from the LF terminator. It's the LF that the option allowed you to ignore.

You know, the easiest way to answer your question is to just try it. It's not like anything bad would happen.

That would be a documentation bug, it would seem. Basically, the 'open' command is processed when the stage is 'opened' before any rows are processed, while the 'close' command is executed after all rows have been processed and just before the stage itself is closed. Similar to the 'Before SQL' and ...

I have no idea, but if your Support Team knows enough to ask for a 'stack trace file' they should also know enough to tell you where to find it and what it would be called, I would think.

I would put both in the target stage, all though it may not ultimately matter, it just makes more sense for them to be in the stage working the same table.

Are you actually trying to connect to DB2 on Z/OS? It doesn't sound like it from the kind of questions you are asking.

Calculate number of days between two dates? Yes. After eliminating weekends? No. Without a dimension to query, you need an iterative solution - start from the first date, add a day at a time until you hit the end date and skip any weekend days.