DSXchange

For just a few cents per day (a few more, in Canadian cents) you can purchase a premium membership and be able to read the premium posts. You will also be helping to fund the bandwidth charges incurred by this site. For your interest, the total received from premium memberships is not enough to cov...

Is your job design using Data Set or File Set stage(s)? These are, in some sense, tied to the configuration file that was used when they were created. In particular, the resource disk that specifies the location of their data files must be accessible in whatever configuration is used subsequent to t...

What happens if you allow the partitioning from the Data Set to be (Auto) rather than Same? Do you get a repartitioning icon on the link? (You don't need to re-run the job - just change the job, then exit without saving, to answer this question.) The inserted buffer operators are there to attempt to...

Has anyone reported this to their support provider?

If the problem has been resolved, please post how it was resolved. MonthFromDate() - MonthFromDate() is only a partial solution, in that it will only work if the dates are in the same year and the day number of the first date is less than or equal to the day number of the second date. Otherwise the...

Data Elements

Use them all the time. Can perform Usage Analysis on them.

Please post the record schema from both the input and output links of your Combine Records stage.

Does DB2 have a TO_CHAR() function? You can certainly CAST (BIRTH_DATE AS CHAR(10)) to read it as Char(10).

My preferred approach, maximizing use of the GUI, is as follows. In a job sequence, run a small job to load the parameter names and values into a hashed file. Then use a function such as Trans() or UtilityHashLookup() to retrieve the value when setting job parameter values in a Job activity.

I agree with what Ken posted. Particularly if you have a completely disjoint set of keys, the hashed file supports as many writer processes as you want to throw at it. Locking only occurs at the record level when you use a Hashed File stage. If you have duplicate keys, there's still no real problem ...

Check with the UNIX Administrator that the cron daemon is running. It should be, but one must eliminate all possibilities.

Hi all, In a server routine i am running a server job. When the server job does not complete successfully then the routine has to return a non zero routine code. I am calling this routine in after job sub routine in a server job. When I start i set the ERROr code =0. Is the routine code and ERROCod...

If you WANT the duplicates, do nothing. A simple left outer join will deliver all the duplicates from Tbl1, and mimic the behaviour of DataStage lookup. If you want to remove the duplicates, then an approach such as an inner self-join with the distinct key values would suffice.

Note also that the Else clause can be taken in an OpenSeq statement even though the file is open for writing. This indicates that the file does not yet exist; the successful open is indicated by Status() returning 0. Search the forum for OpenSequentialFile which illustrates all the possibilities whe...