DSXchange

The easiest way is to use the ping command on the server.

Or a Modify stage using handle_null() !

But there's no Modify stage equivalent of the IsValid() function.

You could use the parallel Ereplace() function published on DSXchange, but what happens if other placemarkers (for example ' or €) occur? Maybe a better approach would be to pre-parse the HTML with a parser specifically for that task (or a routine that you write, but why re-invent ...

All before/after subroutines are server routines, whether they're called from server jobs or parallel jobs. They can not be called directly from sequences but a simple interlude could be constructed. FUNCTION ExecSHSilentInterlude(Arg1) ErrorCode = 0 Call ExecSHSilent(Arg1, ErrorCode) Ans = ErrorCod...

It's padded with something - probably 0x00 characters. What is the value of APT_STRING_PADCHAR environment variable?

Yes you can. But the code will be completely different - you will need to read the flat file into memory and search it there, probably (if it's a BASIC routine) using the FindStr() function. An example of using this function was posted not long back - certainly this year.

Is the host name DDC2-97752ZE resolvable to an IP address from your DataStage server?

Have you read the manual on DB2 connectivity for DataStage? It's quite comprehensive.

Does the SELECT statement include any blocking operation, such as GROUP BY, DISTINCT or ORDER BY?

What database?

For example, if it's DB2, you can call the stored procedure through DB2 Connect.

The schedule is not stored in the repository at all. You can execute an AT command (in a DOS shell) to see the schedule.

Or, of course, from Director client schedule view. From there you can print or print to file.

You could always create your own before/after subroutine, which does not put the entry into the log. Adapt the code of whatever routine you're currently using.

I assume, because the thread is marked as Resolved, that you found it (a drop-down list on the Constraints page).

With what character is the Char(15) field padded? Is it possible that Trim() is having no effect?

What are you proposing to do with them after you've read them? DataStage is an ETL tool - what transformation is possible with a TIFF file?

Resist stupid requirements!!!