DSXchange

good luck ray.............. youve been a well of great advice. hope to see you back online in the group soon -himanshu -----Original Message----- From: Raymond Wurlod [mailto:wurlodr@au1.ibm.com] Sent: Friday, June 28, 2002 7:44 PM To: u2-users@oliver.com; datastage-users@oliver.com Subject: Going A...

Goodmorning to everyone, Im running in a really strange case. Ive really simple job that after extract rows from 2 Oracle and after some aggregation and transformation load this rows in another Oracle Table. The particular thing is that all the rows are rejected with the same Oracle error. Here as f...

Build your job so that it first loads a copy of the target table into a hashed file. Then use a reference lookup against the hashed file to determine whether the row already exists in the target. Only if it does not (which you can determine via the NOTFOUND link property of the reference input link,...

If it hasnt got enough permission, is it reasonable to expect DataStage to generate the right error message? It cant determine whats wrong because its not permitted to! "Kumar, Narendra" cc: Subject: RE: Datstage server down. 29/06/2002 06:44 Please respond to datastage-users Thanks! I found out it ...

Listies, Yes its true, my position at IBM is one of those that have been made redundant. My last day at IBM is July 30th. Been doing a burst of training for Red Brick Warehouse around the Asia Pacific region lately, which is why I have not been contributing much to the list. (Wading through about un...

The first solution involves loading the data into a UniVerse table (or hashed file) which has been defined with the Field2 column multi-valued. Load the table normalized on Field2, then select from it without normalization, converting the value marks into the delimiter of the text (sequential) file ...

Thanks! I found out it was one of the SAs taking away write access to some of the directories with $uvhome. The error messages thrown out by datastage are not too helpful though. -----Original Message----- From: Hall, Doug [mailto:Doug.Hall@anheuser-busch.com] Sent: Friday, June 28, 2002 3:11 PM To:...

I got this info from the Ascential web site. It is a checklist for this specific problem. If you have recently made any changes to the dsenv file, I would check the LIBPATH variable setting. -Doug - disk space for both the $uvhome and the project directory are 50% free - verified permission: UVTEMP ...

HI Kumar, check if your user have permission to access to that project ? see, in unix, the permission of the directory of the project. Best regards Rui Soares -----Original Message----- From: Kumar, Narendra [mailto:NKumar02@7-11.com] Sent: sexta-feira, 28 de Junho de 2002 20:28 To: datastage-users@...

This is a topic for an orphaned message.

Datstage version 4.0.2r1 -----Original Message----- From: Kumar, Narendra Sent: Friday, June 28, 2002 2:28 PM To: datastage-users@oliver.com Subject: RE: Datstage server down. I ran a ps to check on Datstage processes running - shown below. root 24842 1 0 13:57:17 ? 0:00 /u001/app/datastage/uv/unish...

I ran a ps to check on Datstage processes running - shown below. root 24842 1 0 13:57:17 ? 0:00 /u001/app/datastage/uv/unishared/unirpc/unirpcd root 24845 1 0 13:57:17 ? 0:00 bin/usd /usr/spool/uv root 24867 1 0 13:57:23 ? 0:00 /u001/app/datastage/uv/bin/uvdlockd -config Kumar -----Original Message-...

I am getting an error when trying to connect to the Datastage Server. I get a 39202 "ERROR: Failed to open project" error when I try to connect. Since the server can be stopped or started only by the "root" id I had the root run the "/sbin/rc2.d/S999uv.rc stop | start" job but I continue to have thi...

Hi Sylvain, If you use NT, then you can run telnet and logon the project you are trying to compile all th jobs > LOGTO "project name" (project name is case sensitive all other > UniVerse commands should be in CAPS as shown) > CREATE.FILE BP 19 (create a home for this BASIC program) copy the attached...

Hi, There is a utility called Compile All available at m regards, A. -----Original Message----- From: Sylvain Guilbault [mailto:sylvain.guilbault@cognicase.com] Sent: Friday, June 28, 2002 9:35 PM To: datastage-users@oliver.com Subject: Batch compile jobs Hi everyone, I need to compile all the jobs ...