DSXchange

Have you created a function that performs the "put" (= write to file) activity? Have you registered this via a discovery function, so that DataStage can map its generic "put" to the name of your function?

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Ensure that the quote character is 000 in all SequentialFile stages.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

The automatic resizing of a dynamic hashed file does not emit the message about the date/time stamp in the header being updated; it's a normal part of dynamic hashed file operation. RESIZE is not the only utility that can generate such a message, some of the file repair utilities do as well; the poi...

Next week's the week.
Congratulations on reaching 300 posts before the new site kicks in.

Use a Pivot stage to generate one row for each course (and key column), then you need only define one lookup (given that it's the same course table). You now have the (up to) 12 records that you want to load into Oracle.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

When you expand the tree view in Version Control you will see the version numbers. Ensure that you have selected display by version number rather than by batch number (a batch number is a unique id assigned to all those things imported into Version Control in the same pass). Ray Wurlod Education and...

INTEGRITY 6.x

The question came up in class, and I was struggling to get a neat differentiation.

I get some of my best work done on long haul flights, away from the distractions of home. [;)]
It makes the time I do have at home much more valuable, too. I get home about one week per quarter.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

If you're certain that you have a good backup, and your project has been destroyed, try deleting the entire project directory then restoring. Let us know whether this works. There are a lot of tricks involved with restoring DataStage projects, particularly if it's not to the same location; various r...

This message is typically generated when you run utilities such as RESIZE. Are there any routines in your job stream that might invoke such utilities? It's really an informative message rather than a warning, but DataStage takes the view that any unexpected message emitted by a child process (phanto...

In DataStage version 6 and later, when you're specifying a job parameter, there is a command button called "Add Environment Variable". Use this.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Everything you want to do is able to be done using Version Control for DataStage. The good news is that it's on the DataStage CD, and therefore incurs no extra monetary cost. You do need another project in which to store the versioned objects. Ray Wurlod Education and Consulting Services ABN 57 092 ...

I'd use a Sequential File stage and a before-stage subroutine from the Transformer stage it feeds data into. The before-stage subroutine uses ExecSH to execute the UNIX command cat file1 file2 > file3, and the Sequential File stage reads file3. If your DataStage server is on Windows, the before-stag...

(Advertising, perhaps) If you can't figure it out you can create a specification of exactly what you want it to do and hire a competent consultant to create the job control code for you. There are several competent consultants who post on this forum and elsewhere. Ray Wurlod Education and Consulting...

Once the legal niceties are worked out with Ascential there will be a white paper on exactly this topic on DSXChange.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518