DSXchange

Execute them individually in Administrator client's command window. Then select both from the history pane and Save with a suitable name, such as CLEAR&FILES. Execute this via ExecTCL. The other way is to put a field mark between them, but there's no convenient way to do this on the ExecTCL Inpu...

Umm... isn't DSJ.ME always set to 1 ?

You would need the DSJobName macro or an appropriate function call in there. This is implied by the jobname reference in the first solution.

There are two query languages. One, the older, is called RetrieVe. Its SELECT generates a Select List (a list of key values) in memory. Its filtering clause begins with WITH. The other is called DataStage/SQL. Its SELECT generates a report. Its filtering clause begins with WHERE. Each has a DELETE s...

Read the file as a single column, or perhaps two if the record type designator is at the beginning of each line. Use the value of the record type designator to constrain three outputs from a Transformer stage (header, detail, trailer). Parse the single column of data into appropriate fields on these...

Yes. You could, in the routine, invoke DSExecute() to run a shell script, or you could, in the routine, use BCI functions to mimic the ODBC API. In the latter case you will need a licensed ODBC driver.

Server jobs will compile and run on Windows with 7.5.2. Parallel jobs will not. Here's a challenge for kiran_418 - post the first ("job starting") event from your successful job's log, so that we can see whether it's a server job or a parallel job.

Using Entire for the reference dataset causes all of the data to be loaded into a single partition in memory. However all the stream partitions can see this data. That's not quite correct. Entire causes the entire reference Data Set (or File Set) to be loaded onto each partition. Every partition. S...

I want to call a PL/SQL procedure in DB2 from within the derivation field of the derivation inside the Transformer stage. No you don't. It would be abysmally slow. There are various mechanisms available, all of which would require a routine, perhaps to open a new shell in which to execute sqlplus c...

Your actual row structure and your metadata do not match, there being more columns (character positions) in a row than the total of column widths and inter-column characters specified in your table definition for the fixed-width format file. A related possibility is that your data include some doubl...

1.0 1.1 ( very briefly ) 1.2 2.0 2.1 2.2 3.0 2.5 (2.2 + NLS) 3.1 3.5 3.6 3.7 (Jakarta) 4.0.1 (4.0 + NLS) 4.1 4.0.3 4.1.2 5.0 (Kobe) 5.2.1 6.0 (Viper) 6.1 (Rattler) 7.0 7.1 (Twister) 7.5 (Trinity) Source: DSINCLUDE/DSR_ESRPROPS....

Extended Edition. Read about it on the IBM/Ascential web site or search this site.

The version number is 7.5x2, not 7.5.2. The "x" is specifically part of the version number. Version 7.5x2 is currently the only version that supports compilation and execution of parallel jobs on the Windows platform. Version 7.5.2 is not the same thing.

For debugging purposes, put a Sequential File stage between the Transformer stage and the OLEDB stage. What format gets written into the text file? This should also isolate where the problem is occurring.

Do you believe everything sales people tell you?

I'm not saying that at all. DataStage parallel jobs work equally well in an SMP environment or an MPP (cluster) environment. You asked for how we set it up; I told you.

There are different versions of DataStage software for Windows and Linux. Neither will install on the other platform.