DSXchange

Regu, for your original problem you can use as I wrote before the Documentation Tool. For your second problem the Access of the uv-shell I can tell you, that I dont have any problem accessing it. Wheter the datastage general shell in dshome nor the UV-Shell of the project-directory. I am AIX 4.3.3 a...

Hi, You can use the XML reader stages and store into the Hashstage then direct into ur OCIplugin. I think you can slove it in this way. KAM ----- Original Message ----- From: "DaeHwan Kim" To: Sent: Friday, February 21, 2003 3:53 PM Subject: handling xml data on oracle 9i with DataStage. > Hi Guru. ...

Hi Guru. I Now search a case handling XML Structure data on Oracle 9iR2 with DataStage. My customer want to use datastage for XML format Data on Oracle 9i, They now make new OLTP system as banking system. they now setup new system. so They want to extract data from the new system ,transfomat and tra...

Yep - checked and double checked all of those things but still no joy. I think Ill log a call with Ascential and see what they come up with. Thanks for your help. Regu. -----Original Message----- From: Simon Fryett [mailto:sfryett@hotmail.com] Sent: 20 February 2003 18:15 To: datastage-users@oliver....

Hi, I have come across this problem with AIX before. The AIX libraries tend to be linked and sometimes these links become destroyed or simply moved during upgrade or update. Having said that the library trying failing to load in this case is a DataStage one, normally if it is the AIX library it woul...

Hi There, Ive the same problem on my server. Ive installed DS 5.2 on 2 AIX platform and the result is the same. The error is exactly like the Regu one. Best regards Giovanni Boccia FromRegu.Saliah@astrazeneca.com Todatastage-users@oliver.com Cc DateThu, 20 Feb 2003 12:45:01 +0100 SubjectRE: A list o...

Try one time "uvsh" instead of "uv" Wolfgang > -----Original Message----- > From: Regu.Saliah@astrazeneca.com [mailto:Regu.Saliah@astrazeneca.com] > Sent: Thursday, February 20, 2003 12:45 PM > To: datastage-users@oliver.com > Subject: RE: A list of hashed files > > > Simon - Ive added the AIX libra...

Simon - Ive added the AIX library path but its not made any difference. Any other ideas? Cheers, Regu. -----Original Message----- From: Simon Fryett [mailto:sfryett@hotmail.com] Sent: 20 February 2003 11:07 To: datastage-users@oliver.com Subject: RE: A list of hashed files Hi, It looks like your LIB...

Hi, It looks like your LIBPATH is probably missing the AIX library path which is also needed, in 4.3.3 is under the /usr directory structure structure somewhere cannot remember off the top of my head. Simon. >From: Regu.Saliah@astrazeneca.com >Reply-To: >To: datastage-users@oliver.com >Subject: RE: ...

If you know what processes hang you can kill them in the Taskmanager, but you have to be cautious. Even doing so Windows may keep the RAM occupied even if it is free. The days when I worked with Windows Servers a rule of thumb was: Reboot the Server once a Week. Wolfgang > -----Original Message-----...

Thanks - Riccardos suggestion worked just fine. However I still have a problem trying to Telnet to DS.TOOLS. The steps I carry out are as follows: cd `cat /.dshome` . ./dsenv bin/uv This gives me the error below. Ive checked the environment for the variables SHLIB_PATH or LD_LIBRARY_PATH, but they d...

The error is because your library path environment variable (SHLIB_PATH or LD_LIBRARY_PATH or whatever) is not properly set, probably because you did not execute the dsenv script. The rest, as Wolfgang said, is tricky and really depends on how exact your metadata management has been. What do you mea...

Hi Regu, I know that on DS5.x or later all job objects are stored into a new Repository table. So try statement this from the Administrator command line or telnet UV session: SELECT NAME FROM DS_JOBOBJECTS WHERE OLETYPE LIKE %HashedFile%; Hope this helps Riccardo ----- Original Message ----- From: "...

Hi Regu, By Administrator launch the following command: SELECT NAME FROM VOC WHERE TYPE = F AND F1 NOT LIKE %DataStage Job File% AND NAME NOT LIKE &%; Someone is a system hash file but maybe this is helpfull for your needed.... I hope so. Best regards FromRegu.Saliah@astrazeneca.com Todatastage-user...

I have a job in DataStage (5.2) that I am working on that uses an ODBC stage to connect to an Access database. While I was doing some testing, my DataStage job seemed to be hung up so I stopped it. When I did this the Access database now appears as if it is permanently being used by another user. I ...