DSXchange

It looks like your SAP BW instance is busy doing other things, so can not allocate resources (process chain) to your request.

Record 4242 contains characters which are not defined in the file's NLS map.

First call is to dsjob with -jobinfo. This returns the status. You can then make the decision about whether to use the -run option (perhaps with run mode RESET?).

Use a Custom trigger and detect that something other than was requested was returned. For example Len(returnvalue) <> 19 (assuming that it returns an ISO 8601 TimeStamp).

It's worse than a Bad Idea - it's impossible. This is not a DataStage restriction - it's an operating system restriction. A sequential file may have N readers or 1 writer. The operative word here is or - you can't be reading and writing the same file simultaneously with standard utilities. Nor can y...

It's something that the UNIX administrator on the remote machine does. Outside the scope of my expertise to provide details, I'm afraid. Try man rsh (or man remsh as appropriate) - it may help.

I missed the fact that you are passing it back to a job sequence (a separate process). System variables don't work between processes; aren't accessible in downstream activities. But you could pass it back through the job's user status area (DSSetUserStatus) rather than through Ans. To answer your or...

I think it's just a hangover from when INTEGRITY was a mainframe application (and didn't support delimited files at all). Later they introduced file format operators (to "translate" delimited files), but the start and end properties just seemed to carry through. Tell IBM.

It's fairly standard SQL - which pieces aren't you certain about? EVAL is a UniVerse SQL extension to allow BASIC expressions to be used in much the same way that regular SQL expressions are. FMT is a keyword that overrides the default column width and justification, which is 10 characters left-just...

Might be more efficient were DS_JOBOBJECTS additionally constrained only to process ROOT records, as it is only these that contain parameter collections. (Actually I need to check that - shared containers also have parameters - do they have ROOT records in DS_JOBOBJECTS?) And wouldn't SELECT DISTINC...

Sequential File stage is the fastest of the passive stages. It has clever mechanisms, such as look-ahead and buffering, built-in. On the down side, you can't begin reading from a single sequential file until you've finished writing to it. You can with a hashed file, but it may not be appropriate to ...

Vincent is correct, of course. Been kinda involved with parallel of late.

If you just want to know what server jobs and job sequences are running now, you can look at the job processes with a UNIX command.

Use (pipe into) cut or awk or sed or similar to produce the report you require.

Change your SQL to include an UPPER (or is it UPCASE in Teradata) function.

You will need an ANSI-compliant C compiler, such as Visual Studio, in addition to everything else.