DSXchange

RCP and the use of a schema file are completely independent of each other. RCP allows the passthrough of any input column named on the output link without needing to define a derivation for it. I prefer not to use it, because it thwarts effective lineage analysis. The Schema File property allows the...

Is this really a Windows server? I've not encountered LPARs in a Windows environment.

No idea. Why not try it and let us know?

Try importing the table defintion from the file. Having done that, open the table definition in your Repository, visit the Format tab and click the button caption Sync Parallel. Then visit the Layout tab and choose Parallel option to see a record schema that will work. Use that in your schema file.

And one more thing is Data in DataSet not in Sequence order it starts from 1 and after 96 again row starts from 3704 and ends with 3799 and sratrs from 97 ends with 192. Sequence no changes app after every 95 rows. Any idea hwat's going-on and how to staight-up this. Thanks srimitta All the numbers...

The report shows all of these to be abandonded "printer shared memory segments". Each DataStage process is allocated one of these when it logs in, and removes it when it logs out normally. Aborting or killed processes may not get the chance to remove their shared memory segments. They are viewable w...

They are not intended - or indeed able - to be used directly in a BASIC Transformer stage, for example because DSAttachJob is a subroutine, not a function. My code is intended - as I believed yours was - to be used in a server job routine that was invoked from the BASIC Transformer stage.

Somewhere like C:\Program Files\Ascential\DataStage\Templates

Template categories become sub-folders in that folder.

The templates themselves can be viewed with any XML or text viewer.

You have also not revealed what's different between the two environments (development and this one). In particular, are the compiler and linker options (environment variables) set the same way?

The options for server components are only available if whoever installed the DataStage server licensed both parallel and server engines. It is perfectly possible to license the parallel engine only, which I believe is what has happened. You can verify this on the Licensing tab of the Administrator ...

Use a Sequential File stage. Set it to use a Filter command. Use type or copy as the filter command.

DataStage reads the output of the filter command.

Our new, enthusiastic poster's location suggests that he/she is an employee of a very large consulting company (no, not IBM). I am regularly amazed at how parsimonious these companies can be when it comes to increasing their employees' skill sets.

In the Manager client there is a tool in the Tools menu for managing Configurations.

Read about configurations and how to use this tool in the Manager Guide manual.

Make the field length longer or truncate the data.

Nice theory, but the RT_... tables aren't indexed.