DSXchange

We have multiple developer groups for DataStage 5.1 and wanted to secure our environment so each group would not impact the others. ie. one group cannot modify/delete objects from anothers project. The issue Ive got is the DS 5.1 install recommends all DataStage users belong to the same group as the...

Has anyone managed to create a script to import jobs using a UNIX script or DS routine similar to the functionality provided by the dsimport.exe command ? regards, Peter NOTICE This e-mail and any attachments are confidential and may contain copyright material of Macquarie Bank or third parties. If ...

Did you edit the dsenv file (or whatever it is called now as I think it was renamed in 5.1) to include the ORACLE_HOME envirnoment variable and the Oracle shared libraries in the servers path? It should have copied your original file to a new name during the upgrade (check the readme), you can get y...

Hi there, I wuld like to submit you a question on a problem that Ive found installind DataStage on Sun Solaris box. Ive installed DataStage 5.1 on Sun Solaris box with Oracle 8.1.7 and the jobs that use ORAOCI8 plug-in Abort with the following message: ds_loadlibrary: error in dlopen of oraoci8.so -...

Preferably Compaq Tru64 against Oracle databases, but Im guessing my concerns could apply across other flavors of Unix... and databases. We are planning our migration from 4.2.1r8 to 5.1 on a Compaq Tru64 Cluster and have some concerns over some of the new prerequisites for this version. I was wonde...

I am currently running Datastage 4.0 and also have a continuing problem with this error message. My team has sent this problem into the users group several times over the last 3-4 months and have not been able to get the issue resolved. If anyone has any suggestions as to how to correct this, please...

Another way to do a count on hash files is by opening administrator. hi-light the project that the hash file pertains to and click on command. Here you just type: count hash file name This only works at this command prompt for hash files that happen to be stored in the project directory only. Stashi...

This is a topic for an orphaned message.

I also have experienced problems with certain jobs aborting with abnormal termination of certain stages. I dont quite understand what these message imply only because these are jobs I run all the time and out of no where they will abort. I was informed by a Datastage tech support person that this wo...

At 12:01 PM 1/11/02 +0800, you wrote: >Hi David, > >Thanks very much for your suggestion. Following that we were able to >solve our problem by changing the permission of the following directory >/DataStage/Ardent/uv/catdir/*DataStage*DSR from 664 to 666. > >However, we are not able to determine whet...

Hi David, Thanks very much for your suggestion. Following that we were able to solve our problem by changing the permission of the following directory /DataStage/Ardent/uv/catdir/*DataStage*DSR from 664 to 666. However, we are not able to determine whether that directory permission was originally 66...

Dont forget the ending ; Or you can use the Retrieve command > COUNT hs_file_name (No semicolon at the the end on that form.) Regards, Clif Thursday, January 10, 2002, 10:22:27 AM, lfrumke@sears.com wrote: > YN, > Just use a regular select statement in UniVerse, i.e. > select count(*) from hs_file_n...

YN, Just use a regular select statement in UniVerse, i.e. select count(*) from hs_file_name Leonid YN on 01/10/2002 12:03:30 PM Please respond to To: datastage-users@oliver.com cc: Subject: Hash file records count Hi All, I wanted to know how to count the number of records in a hash file. Much appre...

Hi All,

I wanted to know how to count the number of records in
a hash file.

Much appreciated.

Thanks,

YN

__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/

Or, if you want to keep your code in its own directory (separate from DataStage code but still within the project directory), create it like this in DataStage Administrator: CREATE.FILE MYINCLUDEDIRECTORY 19 This has to be done for each project. When editing or migrating code, you can place it in th...