DSXchange

Under the previous (Ascential) regime you organized trial versions through your vendor. It was the vendor's call whether or not to do this, and that depended primarily on the perceived likelihood of a sale. I have no reason to believe that this strategy has changed.

As wrong.

(There was no backed up version). We have been running for the last two days without issue. There is also a patch coming for this version. Cheers And the moral of THIS story is... ? (I very much doubt that there will be a patch coming to cover the situation that you have no backup. Though the good ...

A simple Search would have revealed that the function already exists on DSXchange.

A project contains all your jobs. You do not - indeed can not - "run" the project. You can run all the jobs in the project, at least in theory, but in what order should they be run, and do you want to include dependencies (even as simple as JobA must succeed and only then can JobB start). This level...

Yes. A routine that steps through all the jobs, purging the job logs and reinstating/reconstructing the control records. But do you want to archive them first?

Looks like the date ranges between these intervals is what's required. Is this so?

Call the function supplying values for the arguments (the job handle needs to have been assigned by an earlier invocation of DSAttachJob() of course). This particular function returns an integer, which is the event number that you can supply to DSGetLogEntry().

The buffer in question is not the DataStage buffer size - it's the query result buffer size in Teradata. The error message was generated by Teradata. Check with the DBA.

If it's only startup that's slow, it might be that there are thousands of old entries in the &PH& subdirectory. You can lose all of them.

DS_LICENSE is a hashed file. You may have had a temporary aberration with the T30FILE table being full.

Otherwise, as noted, ensure that all users have write permission to DS_LICENSE and its two subfiles DATA.30 and OVER.30.

Read each warning carefully - the name of the stage and explanatory text is given, often with other diagnostic information. Why not post one of the warnings, together with your understanding of what it is telling you? If you have version 8.0 there is also an error codes reference manual, though this...

As noted in my reply to your private email, this would entail a substantial investment of time, and therefore would need to be billable time. As far as I am aware there is little documentation about the architectures in the public domain - you get some on training classes but not that much - and non...

The only tool that can capture logic errors into a text file is a text editor. Logic errors can only be solved by brainpower, perhaps using tools such as the Debugger or active stage tracing.

NULL and 1 can only return NULL - such is the nature of NULL Try putting the IsNull() test first. Trim(" ") can never be "". If there are spaces, one space is always left. Prefer the Len() function. Is this an expression, or code in a routine? If it's an expression it must be all on one line. If IsN...