DSXchange

Because Routines have arguments, and because the UNIX shell has no argument-passing mechanism, what you seek to do is not possible. You would need to create a wrapper program (see my recent post on this), which you can not do using DataStage clients. Use the right tool for the right job. For somethi...

Are BASIC program different from routines or are they same? A program has no arguments, begins with a PROGRAM declaration, and finishes with an END statement. There is no way, using DataStage clients, to create a program. A routine has one or more arguments, begins with a SUBROUTINE or FUNCTION dec...

It's very easy. Follow these four steps. Step 1. Throw away everything you developed as server jobs. Step 2. Forget nearly everything you've learned about developing server jobs. Step 3. Learn the parallel extender design paradigm. Step 4. Using your original source to target mappings, develop paral...

... or at least feel a little bit guilty about lying about it!

Nearly there! Create a file (say testin) containing two commands; the first to set up the width and length, the second the query. SET.TERM.TYPE WIDTH 132 LENGTH 10000 SELECT CATEGORY AS CATGRY FMT '25L', DS_JOBS.NAME AS JOB_NAME FMT '25L' , MAX(EVAL DS_JOBOBJECTS.'@RECORD<6>') FMT '45L' AS L...

How about a check box in the area where posters of new topics (questions) have to record DS version and edition and server platform (see also earlier suggestion about re-labelling this "server OS"). Check box label is "I have already searched the forum for answers". This serves as a reminder that th...

Welcome aboard! :D

Although it's not intuitive, try putting the pathname of the file in the Table Names field on the General tab.

If this is correct, can you give me your suggestions for triggering the jobs 7 only after completing the each and every jobs 0 to 2, and then complete the job sequnce. We cannot use All mode because it should not wait for job 7 to do after all the jobs 0 to 2 are complete. This statement is interna...

There are no data types within DataStage; everything is handled as string unless the context requires otherwise. So you can use FMT on "numeric" fields. You can use NUM to test whether a string can legally be regarded as numeric. Cameron's reply can be improved in two ways. Because you specified num...

Can you show exactly what you're doing with the uvsh command? uvsh is a well-formed UNIX (or DOS) executable, and will receive input on stdin and generate output on stdout and stderr. So your line size is affected by whatever environment variables configure it (this differs for different operating s...

Or you can qualify the column name with the table name (just as you would in SQL to avoid ambiguity). Do this in the Derivation field of the Columns grid.

Is there any VSS (Microsoft Visual Source Safe) plugin for DataStage? No. Such a thing does not make any sense. Plug-in stages are for processing rows of data. If not, is it possible to develop the same? Yes, but it would be a waste of time, for the reason given above. Can anyone explain the fundam...

I suggest that you also post this question on Ascential Developer Net where you are more likely to receive a reply from an Ascential technical person. Who ought, in theory at least, to know what's going on under the covers.

echo IS a DOS command. However, you will need "DOS" rather than "UNIX" in the DSExecute call.

What is the exact error message returned from DSExecute? (The error message is in the third argument, the exit status is in the fourth argument.)

Did you build your constraint expression using the expression editor or by manual typing? The IsNull() function must apply to the key column on the reference input link (the lookup) - for example IsNull(DSLink1.keycolumn) Your original request suggested that you may not have this totally correctly s...