DSXchange

There may be a database lock on the repository owned by a defunct process. To determine whether this is the case, execute these commands. . $DSHOME/dsenv $DSHOME/bin/list_readu | grep RU | grep -v : If there is a lock you will see it in this report. The name of the job will appear in the rightmost c...

No.

It is simply not possible to change the value of a job parameter while the job is running.

The library dssybctl.so should be in /ETL-batch/Ascential/DataStage/DSEngine/lib; please check that it is, and that the executing user for DataStage jobs has read and execute permission to it.

From DSINCLUDE/JOBCONTROL.H Equ DSJE.BADLINK To -9 ;* LinkName does not refer to a known link of the stage Are you certain that the value passed from the Input Values field (to the InputArg argument) is correctly spelled and correctly cased? Even in your post you've been careless with case (DSgetLin...

A DataStage export is created on the client machine. You don't need to move it to be able to import what was exported into another project on another host. All you have to do is to connect to the other host (which must, of course, have DataStage (legally) installed). In the common connection dialog ...

T42 means a shared container, containing server job components (specifically the XMLWriter stage).

Welcome aboard! :D

I need to write a Datastage basic routine to lookup a hash file and return the result.

Why? This is exactly what the Hashed File stage does! Why do you want to re-write DataStage functionality in code (to be used within DataStage!), which you then need to maintain?

Welcome aboard! :D

Have you checked all the things that were mentioned earlier in this thread?

If you have a problem extracting it in SQL, why not use the DataStage system variable @INROWNUM? This gives a count of the input row numbers on the input link to a (Transformer) stage, starting at 1 and increasing by 1 for each row processed. Sorting in the SELECT statement does not impact the value...

Welcome aboard! :D What you seek is not delivered in DataStage. One of the reasons is that so much of the SQL can be job parameters - table owner, table name, constants in a WHERE clause. It's true that you can not use job parameters as column names, but there is no search-and-replace facility for c...

Creating test data is an art. It helps if you're cynical, suspicious, or even outright paranoid. Ideally you test every possible condition. Practically, you test all, or most, likely combinations of conditions. You create a test plan showing the test data to be used in each case, the expected outcom...

A Routine of type "transform function" is invoked for every row processed, accepting one or more argument values and returning one value (though this can be a dynamic array, and other values can be returned through system variables). A simple routine can return the sum of the current and previous tw...

Welcome aboard! :D Obviously, from your description, you've gotten the lookup part fairly well sorted out, and now you seek to take the sum of base amount the three highest PPERIOD_CD values in each particular PYEAR_NUM. To accomplish this you need to be able to remember the two previous values. If ...

What do you want in your report if a job is only conditionally executed in the batch? This can be achieved in a Job Sequence via triggers and/or a nested condition and, of course, in a hand-coded Job Control routine.