DSXchange

There are many possible solutions. Please be more exact about exactly what you want to do, particularly where you want to use the multi-valued column, then we can be more precise about the best approach.

It should run in parallel. Its code will be executed in each processing node. There is nothing you need to do.

The pattern used in MatchField must exactly match the text. You're very close. The pattern must be a single string surrounded by double quote characters, with literal text within it surrounded by single quotes. Ans=Matchfield(Arg1,"0X'Server sent command exit status '0N",3) You hav...

Change the logic only slightly. If those two lines are always there, then the test becomes Call DSExecute("UNIX", "wc -l " : filename, Output, ExitStatus) Convert @FM To "" In Output ;* remove any "line feeds" If Trim(Output) <= 2 Then * logic ...

There's much more that you can do with the Fmt function; you can read all about it in on-line help or in the DataStage BASIC manual. In "10R", the 10 is the number of character positions, so that it knows how many left spaces to add, and the "R" simply means "right justified", which is what you soug...

There are two sets of things you need to remove. In job logs, field number 7 is used to store the invocation ID. However, field number 7 is not exposed in the file dictionary of RT_LOG, so you need to generate a reference to it on the command line. DELETE FROM RT_LOGnnn WHERE EVAL "@RECORD<7>&q...

In that case try replacing DSJ.LOGINFO (which returns only informational messages) with DSJ.LOGWARNING (which returns only warning messages) in your DSGetLogSummary call. You might also introduce a "quick check" on whether the job finished successfully using DSGetJobInfo. Read more in on-line help.

To expand on what Craig said, "YYYY-MM-DD" is not the same as the "YYYY/MM/DD" you specified in your date picture. Change the date picture argument of TO_DATE such that it uses "-" as the delimiter character.

The line LogEntries[10] = DSGetLogSummary(...) is trying to overwrite the last 10 characters of anything that might already be in the LogEntries variable with the result of the function. Square brackets in DataStage BASIC imply substring operations. What you are trying to do in the routine is to get...

Is the job parameter in YYYY/MM/DD format? Is the parameter type Date? In this case, beware that DataStage may convert the date to internal format. Check by outputting the value into a text file. If it does, you'll need an Oconv() function in your derivation. The Oracle TO_DATE function is perfectly...

Some of the temp files will be being generated by the DataStage agent processes supporting your connected client. The settings in udtconfig are not at all related to these; rather, their temp directory is set by the UVTEMP configuration parameter in the $DSHOME/uvconfig file. Its default value is /t...

A small observation, if I may. The number of records in a file can never be less than zero.

It IS RT_STATUSnn, but you need to be aware that you also have to consider that there are three different record types in this hashed file, and that you also have to select the correct wave number. It's not as easy as it first appears. Also, chances are that it will change markedly in the next (majo...

I recall reading (in one of the readme files?) that dsjob has been changed so that it can now return the exit status of the job itself.

Alas I can't recall the details just now.

Original vendor (Torrent Systems) and now very hard to find.