DSXchange

so.. a problem seems to be with the instance of the string *oracle11g* in the for loop

thank you for the pointer lstsaur, here is my current file it has a problem with the line libs_11g="`ls $APT_ORCHHOME/bin |grep oracle11g`" error: cp: *oracle11g*: The system cannot find the file specified. #! /bin/sh # Copyright (c) 1998 - 2002 Ascential Software # All Rights Reserved # #...

revised my above code and put in 11g where appropriate also added the if logic i get a particular error: installing Oracle driver [: install.liborchoracle 320: expression syntax error Using F:\oracle_base\product\11.1.0Installling driver for Oracle Version 11g cp: *oracle11g*: The system cannot find...

I found the unicode columns in the original odbc read stage .. they must have carried through even though other datastage stage didn't show them as being unicode that got rid of those warnings solved the numeric value out of range connected odbc write stage --rejects link--> peek stage changed Write...

i set the ORACLE_HOME and APT_ORCHHOME using the sh command from the windows command prompt (can do because mks is installed right) so then it told me that it installed 9i "Installing driver for Oracle Version 9i" "Oracle installation is complete" I restarted all datastage servic...

so now I'm trying to "re" execute the install.liborchoracle with the command prompt I go to F:Ascential\Datastage\PXEngine\install and type install.liborchoracle and it just opens it up in notepad again :) do you use the command prompt to "re-execute" this file? so i will probabl...

yes I opened the file up in notepad, this is how I modified it: --------------------------------------------------------------- #! /bin/sh # Copyright (c) 1998 - 2002 Ascential Software # All Rights Reserved # # THIS IS UNPUBLISHED PROPRIETARY SOURCE CODE OF ASCENTIAL SOFTWARE. # The copyright notic...

They're also good to make sure that all your data has been loaded into the target data warehouse area (i.e. the "staging" area). In the case where for example, not all your source data files where available then you could wait until all the staging jobs completed, at this point you'd know ...

Hello, I have 2 jobs. The problem is with the 2nd job. 1st job: ODBC reads from oracle --> Modify stage KEEPs certain columns (all of which CANNOT contain any null values) --> creates a Data Set file successfully. 2nd job: reads from Data Set file created in 1st job --> ODBC writer to oracle databas...

ok I saw a fix for this on the ibm web site however it was for unix

I will look into what info I can find for this fix for windows.. does it involve using the mks toolkit?

I'm using Datastage 7.5x2 EE for windows

I got this to work in the ODBC stage with an oracle client system dsn based on a named service I created with Oracle Net Manager (on the Oracle client), I can view data in the ODBC stage like this. I'm still having this same error in the Oracle Enterprise stage however.. The problem is with the PATH...

well I noticed that my ORACLE_HOME path was wrong I had my Oracle base directory (the term base coming from the Oracle Universal Installer) instead of the home so I corrected it and made it: F:\oracle\product\11.1.0\db_1 still having problem also added the APT_ORCHHOME to my Path however I have 2 ho...

Hello, I'm running on Windows Server 2003 Enterprise Edition. Oracle 11g database server and client both installed on the same machine. Datastage enterprise server and client both installed on the same machine. I have searched the datastage docs, dsxchange forum and google in order to try and solve ...

thank you again, and I am expecting the Server to Parallel DVD course to arrive shortly..

I am definitely looking forward to it.

Also thanks Ray Wurlord for informing me that will be part of the course.

thank you,..

I actually found what I was looking for in the Parallel Job Advanced Developer's Guide.