DSXchange

The best way to think of what Validate does is that it gets the job to do everything except process rows. It opens files and database connections, validates SQL statements against the database, checks the metadata, and do on. Validate is a useful thing to do after deploying a job into a different en...

Make that "beginning to end". Some languages work right to left.

Routines for parallel jobs are not written in DataStage BASIC; they are written in C++. Algorithm Design 1. Determine weekday of first day of month. 2. Determine weekday of last day of month. 3. Determine number of days in month. 4. If number of days in month = 28 then Number of Mondays = 4. 5. If n...

NO such magic role in the roadmap. They can look at the designs in development environment, which is what they should be doing in a rigorous software development life cycle. Only executables should be promoted into production for maximum rigour.

Probably. Use stage variables to give effect to the algorithm I described. A Routine will be re-usable.

Somewhere in there you're trying to write a string of length 7241 characters into this field. Only you can solve this.

Make ORACLE_HOME (and the other Oracle environment variables) project-specific by setting them up in Administrator. You can then add them to jobs as job parameters and override on a per-job basis. You can never have two different values of ORACLE_HOME simultaneously; there is only one ORACLE_HOME va...

What you want to occur is happening. DataStage alerts you that what you are doing may not actually always work (some decimal numbers are too large to be represented as integers). You can use a message handler to demote this alert to an informational message or a NOWARN specification in your Modify s...

There are equivalents in the unified metadata repository, but their names and structures are a little more complex and, indeed, they may not be separate tables at all. Remember that the common repository contains metadata about ALL DataStage projects, not just one, and that it contains metadata from...

This feature becomes available in the deployment utility within Information Server Manager, a new tool shipping in December 2008 if all goes according to plan. You can also compare the deployment package to what's already in production before deploying.

DS_TEMPnnn is used when designing job number nnn to hold temporary saves (for example when you click OK to close a Transformer stage) and prototype records for the RT_CONFIGnnn file which will be moved there when the job is compiled.

Convert the alphabetic and numeric (by which I assume you mean the English alphabetic and numeric characters - there are Japanese characters for numbers too) to zero-length string and check the length of the result. Len(Oconv(InLink.TheField,"MC/A":@VM:"MC/N")) = 0

Given that the server to parallel transition lab takes four days as an instructor-led class it's clear that answering that here just isn't going to happen. Parallel jobs require an almost completely different mindset, and this includes forgetting certain server/390 techniques. Parallel jobs can be e...

Don't allow the developers to have any role at all in the protected project.

Probably the easiest is to create a routine the tests the first day of the month and the last day of the month to determine what day of the week each is, and to calculate the number of Mondays from that.