DSXchange

No, there really isn't to the degree you are looking for. You can set the basename to whatever you like and it will automatically add a numeric suffix to any new files it creates as you've discovered. What we do for our extracts where we create gobs of XML files that need specific filenames and date...

From what I recall, datasets are akin to fixed-width files so each field takes up the maximum amount of space that can be allocated regardless of the actual data.

A search of the forums for "month end date" should turn up a number of discussions, I would think.

It wouldn't be valid for version 8.

[sigh]

This is the "FAQ Discussion" forum, please repost your question in the PX forum. And disable smilies when you do so there's less coolness.

There's no "then" in a constraint expression as expressions just evaluate to true or false. A "then" only has a place in an assignment, something you would use in a derivation. Also note that boolean functions, ones that return a true or false, should simply be checked as a boolean, not for a speci...

You'd need to open a ticket to find out the "official" answer to that question. I don't think it should but then I don't use the ODBC stage.

True, there's a FAQ posting on this subject that discusses that... and we would have gotten there.

Run them both, let us know. Not really sure what other answer you could expect here, there are too many variables and specifics of your site/servers/data for anyone but you to know.

You've posted in the wrong forum and thus we have no idea what job type this is. So... Parallel or Server job?

Welcome aboard. I found 38 topics when I searched for "Heap allocation failed", did none of them help you?

Yes. Depends on exactly what you need, but I'd start with the Num() function.

Been discussed here ad nauseam. Where do you want to do this? UNIX or DataStage? Both answers are basically the same, either "dsjob" with the various "-log" functions for the former or the equivalent "DSGetLog*" functions for the latter. Read the Server Job Developer's Guide pdf chapter on the Comma...

I'd still look at the UtilityRunJob mechanism, but make it a mult-instance job run X ways with each instance handling 1 of each X records in the driving source file via the mod() function. Is this your "workaround"? The Sequence "difficulty" is the fact that each iteration of the loop would require...