DSXchange

To add a little something to Craig's post; you can not use the GUI to specify the result from a reference input link as/in the reference key expression in a subsequent reference input link in the same Transformer stage - you have to type it in. It stays red (you can validate the expression to get th...

Do you really mean all the records, or all the columns? Or one column from all the records? Do you want them delimited, or simply concatenated?

There are many possible solutions, depending upon exact requirements. Most, if not all, will involve one or more stage variables.

Use Code tags to make your design clear. DB2 --------> HashedFile : : V DB2 -----> TransformerStage -----> DB2 You are populating, then using, the hashed file in the same job. The rows/sec figure on the hashed file output link is totally misleading, because its clock has been running since the job s...

The :1, :2 syntax is appropriate only for Oracle. Use "?" with other databases. Nor does Sybase have a TO_DATE function of this form. UPDATE FRS_FILE_REGISTRATION SET #DATECOL# = ? WHERE FILE_REGISTRATION_ID = ? Make sure that the job delivers two columns, one containing the date as a non-Key column...

My compllaint was related to travissolt's post, not yours. "Unable to initialize plugin" is typically related to the plug-in not being able to find something it requires in the shared library search path or in the command directory search path. It can also result from required database environment v...

Where was it defined (in the environment (in the dsenv file) or in the Administrator client)? You can use the DSExecute subroutine for the appropriate shell (UNIX or DOS) to echo the value of the environment variable. Trim the output of field mark characters - these have been produced by translation...

Check the permissions on the share (not the permissions on the folder) H:\DEV_ZGP0GSAS\Temp

When you display all the locks the header line shows you what the various columns mean. You will find out that the PID and the User # are both in the listing of locks held. I use this technique to get the heading even on a filtered report from the operating system command line. list_readu | head -2 ...

That reminds me of the old gag where Moses is coming down from the mountain and announces "on these tablets there are fifteen - oops! (crash!) - ten commandments."

Your client is wrong, wrong, wrong. Hashed files should be on disks that are local to the machine where the DataStage server is installed. The fact that you are connecting via Citrix is immaterial - that is a client-to-client connection. Tell your client - you can cite this site as your source of ex...

15. Cynical (paranoid?) so as to generate effective test data.

Have a life. This must be the most important point on any list. I have a number of activities completely unrelated to ETL, some of which (such as umpiring a sport or modelling railways at a scale of 1:160) require sufficient concentration that I can completely ignore anything even vaguely related to...

If you make it "right" (either by editing ints.h or making a copy of strstream_s.h called strstream.h or strstream (whatever ints.h requires)) does the problem go away? If so, you ought to report the problem to your support provider, as it may be a bug in the code.

You can save some time on questions like this by clicking Help when in the stage in question. DataStage help is quite good, they've spent a lot of time making it all context-sensitive, "click on the diagram", so that you can rapidly find the item of information you need.

I neglected to mention that the IBM DataStage Essentials classes have a module entitled Best Practices. It includes things like adopting a naming convention for jobs, stages and links, developing and testing incrementally and things like that. To my mind it is incomplete not just within itself but a...