DSXchange

Open Director in Status view and unselect Show Categories in the View menu. Next time the Director refreshes it will show all jobs, sorted by name, in the one window. The category is in an adjacent column in the grid. Note that if you sort by Status (click in the grid header to sort) you have a quic...

Is is just me/my network connection, or is DSXchange becoming slow to refresh, particularly on the two large forums? Other web sites fly along, but DSXchange can take whole seconds (sometimes even tens of seconds) to get to the next screen, particularly on functions such as Reply. This behaviour is ...

So that 1052003 is the 105th day of the year 2003. The correct date format string would be "%ddd%yyyy".

Ah, no-one mentioned ls arguments. For each of the three (user, group, other) pieces, the mode (permissions) map to an octal numeric value. 4 = read, 2 = write and 1 = execute. Therefore, 755 would show up as rwxr-xr-x (a fairly common combination). The chmod command has a letter-based syntax as wel...

Only the current start timestamp is available (in @DATE and @TIME).

The last start and end times must be obtained through DataStage API function DSGetJobInfo() or the log interrogation functions.

It's by far the most common solution. It means you don't have to be given access to their precious mainframe!

It can be done, but the politics of getting access to the mainframe system usually means that they produce an extract (using a COBOL program or SQL) into a text file and FTP that to some location that you can process. You do not specifically require a DataStage mainframe job. Of course, if you do ha...

Does the compilation actually finish, or are you saying that it still appears to be compiling after five hours? If the latter, it may be simply that you have lost the connection between the server and the client, and the job actually did finish compiling on the server. It is a parallel job or a job ...

Look at the final ten or so lines of errors.txt (or of report.txt).

Have you defined the DSN in the $DSHOME/.odbc.ini file?

The second form is a "regular expression" and can not be used in the command position of a command.

A Google search on UNIX "regular expression" returns over 1 million hits. One of the best is this one.

You need to be on the server machine. Change directory to your project directory and execute the given commands there. An alternative is to use the Administrator client command window. In that case the UNIX commands are each "wrapped" with an SH verb. SH -c "rm -rf hashedfile" SH -c "...

Or, even better SELECT INSTANCE, CREATOR FROM DS_AUDIT WHERE CLASS = '2' AND DTC > '<<Earliest date,(D)>>'; DS_AUDIT is a DataStage table that records the date/time and by whom each object was created, modified and deleted. It has no exposure in any of the clients, so you need to execute a q...

Yes it can, and the methods can be found by searching the forum. The technique is to use stage variables to "remember" the values from previous row and to compare the same with the current row.

I think you also need to be doing a similar comparison on MemTyp, based upon your description.

Several possibilities. For example: InLink.TheColumn / 1000 Fmt(InLink.TheColumn, "6R3") Oconv(InLink.TheColumn, "MD3") Left(InLink.TheColumn, Len(InLink.TheColumn)-3) : "." : Right(InLink.TheColumn, 3) Fmt(InLink.TheColumn, &...