DSXchange

chulett wrote:Is the Express compiler listed as one of the supported versions?

Yes, it is indeed

We just installed datastage 8 on a windows server 2003 computer, after installing the microsoft visual c++ 2005 express compiler. When I try to compile a parallel transformer job to see if the compiler is working, I am getting a compilation error. Can anyone tell me how to find out what the problem ...

I've been wondering about this: do you need to partition on all 5 columns? if you would partition on the first column in the sort, already each node only needs to sort data in its own stream without needing to repartition? So I would think for the sorting it wouldn't matter if you partition on all 5...

Hello Bandish - that sounds like it might work, but in this case we have a potential of millions of rows per hour, so doing a sort is not an option for performance and resource reasons. I think you don't need to sort on all columns, just on the timestamp column. If you generate the record-identifie...

check the properties of stage variables which should solve the issue. .. If stage variable property is non-nullable then we should not assign any null value to the stage variable. If we do we get a default value of 0. You make it sound like there is a property you can set to make a stage variable n...

When I try to set a stage variable to a NULL value using SetNull(), and I use this stage variable in an output derivation for a nullable field, the output becomes 0 (integer field) or an empty string (string field). For example if I have - an integer stagevariable svar defined as ' if 1=1 then SetNu...

A shell script would be fine, but can I used orchdbutil to import a definition into the datastage project? I only know about "orchdbutil show etc" to show the definition from the command line.

Is it possible to import multiple table definitions using Orchestrate schema definitions? I want to import a number of tables from Oracle using the Orchestrate import. Is it possible to somehow do this for several times in a row without having to click through all of them? I know you can show table ...

How to setup or identify or make: resource disk and scratch disk in SMP on Suse Linux enterprise server 9 as I need to put that in configuration file? Please help as I am trying to make a configuration file. :) What do you want to make? In the config file you need to say which directories will be u...

So it's a matter of which character is more important: the first one of the last one?

Why do you find DRS stage better?

We need to make connection with SQL Server from Datastage. I was wondering what the difference is between using the ODBC (Enterprise) stage or using the DRS stage to connect to SQL Server. I think they both use the ODBC driver (being on Unix). Is there any reason to use the ODBC Enterprise stage or ...

Yes, NLS is enabled and NLS_LANG is set.

Did you check the data in DB2? Is 10000 the correct number, or are the 100 records that you are getting, the correct result?

When I get data from an Oracle table using the ODBC Enterprise stage, all the text fields come out as unprintable characters. For example the text "AMSTERDAM" in the database comes out as "䅍協䕒䑁䴀 " The texts are all normal texts without any special values. I can read the same tabl...

Can we have multiple specifications for same source column in the Modify Stage? coz i tried that and i get the error message that it was already 'bound' I have a requirement where the source column is nullable and i need to change its nullability via this modify stage, but i also need to change dat...