DSXchange

ray.wurlod wrote:"ROSS" could very well be 12 bytes. ...

Hello,

Is there a way to use a user defined datastage environment variable NLS_LANG to make it work?

chulett wrote:What is your source characterset? "ROSS" may be only four characters but your target only supports 10 bytes and "ROSS" seems to be 12 bytes.

Hello,

My source character set is Project default (ISO8859-1).

Hello Datastage version: 7.5x2 Platform: windows Oracle version: 10g r2 Server job description ----------------------------- sequential file stage -> transformer stage -> ORAOCI9 stage (oracle) Oracle NLS values ------------------------- SELECT * FROM NLS_DATABASE_PARAMETERS NLS_LANGUAGE AMERICAN NL...

also see my other now resolved post for more

viewtopic.php?t=127700&highlight=

I used Oracle 10g instead because it's supported.

I got it to work with 10g.. it was good to know about install.liborchoracle for the windows version as I wasn't able to find that in the documentation.

I finally got this working. My problem was with my environment variables setup. In the windows control panel, I noticed that there were "user -defined" as well as system variables. By putting all the variables in the appropriate "user defined" or system sections I was able to get...

Hello,

I was recently asked, in regards to a datastage job if I knew "data profiling."

Are there any "data profiling" tools or methodologies that one would be able to carry out using datastage 7.5 or 8?

Hi,

I was wondering if anyone could take a look at this one with the additional details I have posted..

solved it

I used UltraEdit to convert the line terminators to CR/LF (DOS).

Problem was on the Save in UltraEdit needed to specify CR/LF in the save as window - was on default even though the UltraEdit was configured to DOS by default.

Hello, I'm trying to import a .dsx file into Datastage Manager. I'm on the Windows Enterprise (parallel) version 7.5x2. This is actually the setup file for the Server-Parallel Training by Ray Wurlord. When I try to import it I get the following error: File F:\S2P_Setup.dsx does not appear to be a va...

Hi dsex, Can you please send the link to down load Visual Studio 2003 C++ compiler. I tried from Microsoft site .But it is not available . Thanks in advance. i used the c++ compiler that is part of the visual studio 2003 enterprise architect edition installation. the other stand alone one is not av...

OK thank you, Here are my environment variables from Datastage Administrator: General: PATH (Shell Search Path) empty TMPDIR (Temporary Directory) empty User Defined: ORACLE_HOME F:\oracle\product\10.2.0\db_1 ORACLE_SID orcl APT_COMPILEOPT -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c APT_COMPILER cxx AP...

I have an Oracle schema setup which contains tables.

These problems I'm having happen when I go to import the table definitions from the these tables into DataStage Manager.

Hello, I have installed the Visual Studio 2003 C++ compiler. I have installed DataStage Enterprise Edition Server and Client on the same machine. I have also installed the Oracle 10g server and client on the same machine. I am trying to import metadata from the OE sample database that I created that...

yes, I get:

SQL*Plus: Release 11.1.0.6.0 - Production