DSXchange

What stage are you using for the update? I think this is the case for both Oracle and ODBC stages. One solution is to write your own query instead, so that the key columns are not updated. Something to keep in mind (as I have seen developers just blindly import the entire record definition), is to o...

Rui, Could you send some more details on this ? Bibhu From: Rui Soares on 01/04/2002 12:59 PM Please respond to To: "Datastage-Users (E-mail)" cc: bcc: Subject: UPDATE problems Hello! Im using a DS 4.0, and im doing a Update to a table, the problem i find is the query, are updating including the key...

Hello!

Im using a DS 4.0, and im doing a Update to a table, the problem i find is the query, are updating including the key. how can i changed this ?

Best whishes for 2002!


Rui Soares
NOVABASE - Data Quality
EMail : RumSoares@BES.PT
Tel : 21 4168000 (ext : 266313)

The directory permissions are set to drwxrwsr-x which I would have thought would carry over to the underlying files. -----Original Message----- From: Kenneth Bland [mailto:kcbland_2000@yahoo.com] Sent: Friday, 4 January 2002 3:52 PM To: datastage-users@oliver.com Subject: Re: Object Permissions Chec...

Check the directory permissions. You may have an s messing with you. Good luck! -Ken --- Peter Oates wrote: > I have set umask=002 in the dsenv file and objects > seem to be created with permissions of 755 rather > than 775. This causes an error message when other > developers attempt to execute the...

I have set umask=002 in the dsenv file and objects seem to be created with permissions of 755 rather than 775. This causes an error message when other developers attempt to execute the job. Is there anything else I should be checking ? regards, Peter NOTICE This e-mail and any attachments are confid...

Thanks Rick and Vincent for the info on how to get version control for 5.1!

Much appreciated,

Scott

It seems to work now for DS_JOBOBJECTS ( thanks Ken ), setting the READONLY column to RO or RELEASED WHERE NAME = Job -----Original Message----- From: Greg Smallhorn [mailto:greg_smallhorn@hotmail.com] Sent: Wednesday, 2 January 2002 4:31 PM To: datastage-users@oliver.com Subject: RE: Setting jobs t...

Ascential Software has actually purchased Version Control from DCS-Strategies and is available for release 5.1 of DataStage. (Contact your sales rep or Ascential directly) Or can be downloaded from the Tools4DataStage.com web site. Also the Co-Sort plug-in is in existence just not marketed and sold ...

It is a bit misleading! The Ascential web site also mentions Version Control in 5.1 however the link provided takes you to the Tools 4 Datastage web site and the Version Control tool developed by DCS-Stategies. This version control tool was sold by DCS as an add to DataStage but I believe Ascential ...

So for Job 1 - I should expect to see a table: DS_JOB1 ?? I cant seem to find either DS_JOB1 or DS_JOB001 in my project. -----Original Message----- From: Greg Smallhorn [mailto:greg_smallhorn@hotmail.com] Sent: Wednesday, 2 January 2002 4:31 PM To: datastage-users@oliver.com Subject: RE: Setting job...

At a DataStage engine prompt, or in the Administrator command window, execute the statement: SELECT * FROM DICT DS_JOBS WHERE "TYPE" = D ORDER BY "TYPE", "KEY.CODE"; This will give you a list of the public columns in the DS_JOBS table. In release 4.2 at least, there are no hidden columns in this tab...

I noticed in a project where I promoted all the jobs using the 5.1 Version Control Tool that the value of READONLY is RELEASED. I tried changing my sample job to have READONLY = RELEASED but again it allowed me to save/change the code. Is there a way to list out all the columns on the table DS_JOBS ...

Can anyone explain about PHANTOM?, because when i run the job, i am getting warning Phantom 933 and the message is "Program "JOB.1536909952.DT.1241937883.V0S26": Line 257, Variable previously undefined. Zero length string used. DataStage Phantom Finished" This is code produced by a Transformer stage...

Obviously theres something else in 5.1. I have not had a play with it yet.



_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx