DSXchange

I had maxed my browser window so there was no wrapping, so I guess it's more of a proportional font issue.

There's that. There was also a ClickPack available that would allow you to access emails and weblogs from what I recall, but I say "was" because AFAIK support for it has been dropped and it's not a part of the 8.x release. It was kind of interesting as it brought Perl support into DataStage. I don't...

This doesn't look fixed-width, even after taking the header and trailer out of the picture. Each record needs to be the exact same number of bytes to be successfully read as a fixed-width file. And that includes the header and trailer records. If you are sure about the fixed-width-ness of it, try re...

Turns out you can view reference data for simple queries. Once you added a second reference to the :1 bind variable in your subquery, that's what 'broke' the viewer and generates the "not all variables bound" error.

I don't believe you can do a 'View Data' from a reference link with user-defined sql, if at all. I'll see if I can check later...

So... a select with bind variables, this is for a direct database lookup yes?

version-control is additional feature available in DS Server Edition (7.5.2).

It's an optional client side tool that you'd need to install on your PC from the client CDROM. Once you do, you'll have both online help and a pdf document that lays everything out.

Your expectation is faulty.

Technically, 'after job' the job is still running. You have to check the JOBINTERIMSTATUS to find out what status it will end up with (assuming your after job routine doesn't blow up, of course) and create your file based on that.

Hmmm... thought that just created intermediate directories in the path but you're correct - it also suppresses errors if the directories already exist. Learned something new today!

You've not only posted in the 'wrong' forum but you've marked your job as a Server job when it obviously isn't. Please try to set those correctly in the future.

Right, aren't you going to need a script for this? Unless the directories never exist, you'll need to check first and only create if they don't, otherwise you'll generate errors.

Aggregator or a stage variable, I would think.

Short answer? No. You might want to expand on what 'extract data' means, however. Any specifics you'd care to share?

Note the version being discussed. 8. Version Control was removed from the 8.x release and will (eventually) be replaced with support for standard SCCS type tools in a future release... 8.2? I don't recall.