DSXchange

(If Left(InLink.TheDate,2) > 79 Then "19" Else "20") : InLink.TheDate : svDayNumber Are you sure that this will always cover only the 20th and 21st centuries? Also investigate the CENTURYPIVOT configuration parameter for DataStage (in the uvconfig file) - by defa...

That code does not handle the "not found" ("not matched") case. The Ans variable needs to be initialized. JOBCONTROL.H isn't needed. InitialCounter is not used. Here's a variation on the theme. FUNCTION FindLineInFile(DirPath, FileName, ValueToMatch) DEFFUN OpenSequentialFile(PathName, O...

No. You need to separate them out into separate columns for the Pivot stage. Define the maximum number of columns you might ever need, and set the unused ones to null. Another technique (though you will have to execute in sequential mode) is to convert all the commas to line terminators (LF in UNIX)...

Welcome aboard.

What you seek to do is called a horizontal pivot. What you need to achieve it is the Pivot stage.

One that cannot fail?

Indeed that, or something similar, is the ONLY solution.

You can not prevent the Sequential File stage from creating a file (provided permissions allow).

There is nothing directly within DataStage for doing this. You can generate this information using the Reporting Assistant or "hacking" the repository (perhaps with a DataStage job). You would need to know what fields within DS_METADATA contain the information you require; this metadata is not in th...

You can use a UV stage and get a hashed file to behave like an SQL table. Under this design you CAN modify keys in hashed files with an UPDATE statement. That what happens under the covers is actually a delete followed by an insert if you change the key remains completely transparent to you.

The answer is "not directly". DataStage is an ETL tool; what kind of transformation would you expect to perform on an image file or a BLOB? Those who have had this requirement have tended to perform some kind of hex encoding, so that DataStage is able to move only printable characters. You may, even...

An ugly question, Adam, and one with no "out of the box" solution. Probably the easiest method, using the API, would be to look in the controller's log for "job run requested" events. DSGetLogSummary(DSJ.ME, DSJ.LOGANY, DSJobStartTime, Oconv(Date()+1,"D-YMD[4,2,2]"), 0&...

Welcome aboard. :D There are three stages for performing comparisons; you ought to investigate the Difference stage and the Compare stage. The Difference stage returns a simple result and all columns from both inputs; the Compare stage returns three columns; the result and the two input records as s...

See page 5-15 of Parallel Job Developer's Guide which describes the (mutually exclusive) Null Field Length and Null Field Value properties that you can use on the Inputs link Format tab in the properties editor. Which one is correct for you will depend on the format of the file you are writing.

Any form of "computer programming" is actually communicating with the next programmer. Consider what the next programmer will find easier, but do not forget that, as aditya observed, there may be other activities that also need to be scheduled/controlled. Most of these could probably be managed via ...

Take a look at the supplied routine DSSendMailTester to see the proper way to invoke the function.

Good catch! My SQL solution earlier will still work, but there is no Funnel stage in server jobs. But do you really need to collect them at all? Four parallel streams of processing can feed inserts into the single table. You can design these into one job, or make one job multi-instance and run four ...