DSXchange

To convert them all to internal format, since they are all in year month day order, all you need is Iconv(InLink.DateColumn, "DYMD").
Apply an appropriate Oconv() function to that result to yield the format you require - but did not state.

Yes, I meant to say a full-time webmaster.

I have finally gotten around to documenting the standards that I follow should I be working at a site that does not have their own. They may be found on my web site and may be used and adapted freely. I would prefer that some attribution be made if they are.

As the site has grown to over 12,000 participants and over 100,000 posts it became necessary to find some way to fund the bandwidth. For the first four years of its operation that funding came out of the Editor's pocket. But the sheer size of the site exceeded anyone's expectations - it now employs ...

Can you even have one database node with a partitioned table? Surely it's more efficient to have N database nodes, where the table is partitioned N ways?

For less than $1 per week you can see the whole message.

Define "job failed". The solution is probably going to need you to stage the data - possibly in text files - until you are certain that they are all good.

If you are running a version earlier than 7.5 (in which the "add report" option became available) you can have an Otherwise trigger from each Job activity leading to a Routine activity that invokes the UtilityWarningToLog routine. Use an appropriate message text in each case.

The delimiter characters ("/") are making this date 10 characters long, so it won't fit in a Char(8) field. Change the second argument of Oconv() to

Changing groups should be OK. However, most of the executables in the DataStage bin directory must be owned by root and have the setuid bit set (mainly because they need to access shared memory segments owned by other processes). So steer well clear of any chmod or chown command that might affect th...

Probably simpler would be to impose a penalty (50% of contract fee?) for failure to comply with documented standards. Contract signs agreement that standards document version x.y as at <date> has been received and will be complied with. Standards might require the use of templates, but these are not...

If there's an identifier of the run (such as a date/time updated or a run ID) in each row, you can unwind changes even after they have been committed.

You seem to be building but not unwinding a call stack with your GoSub statements - as highlighted by the Return statements commented out at the bottom of Option 2 for example. One way to unwind the call stack is the following technique at your final return point. Main.Exit: Return to MainExit Ideal...

For a not too large number of not-too-large files, the Folder stage does support wildcards.

The restriction on not-too-large files is that the Folder stage reads each entire file contents into a single field - it's intended to be used with XML documents rather than data files.

Not true. There is also a *.* pattern in the filter, and the Format tab provides for all delimiter and quote characters in the Sequential File import procedure.