DSXchange

Stream data from the Master file and perform a reference lookup on the Transaction file (it has the same key). You now have the row from each - perform the addition when deriving the output column GPREM on the output link of the Transformer stage. ____________________________________________________...

Its not clear whether you want to do this from a DataStage job, from a UniVerse command prompt or in a Routine. Within a DataStage job, point the hashed file stage at the file by specifying its directory rather than its account name. Count the rows using @INROWNUM as they are processed into your job...

Hi Peggy Since you seem to have a unique key you can choose this way: Take the Transaction File as the streaming input (main input) into a transform stage. Make a reference look-up on the Master-File and add GPREM from both input sources in the transform stage. Send the result form the transform sta...

Hi all,

Anyone konws how to count nrows of hash file which located outside the account.

TIA,
Boyd.

Hi Shrini What price are we charging them for this date code. Regards Yzelle -----Original Message----- From: Srinivas b [mailto:gulfcbs@yahoo.com] Sent: 25 December 2001 13:19 To: datastage-users@oliver.com Cc: jbilly70@hotmail.com Subject: Re: valid date CONSTRAINT CODE Dear John Billy, Hi.We had ...

Hi there, my objective is to update master file with a transaction file. For example Master file attribute: KEY : H-3-99-12345 AGENT : 45678-00 GPREM : 600.00 Transaction file attribute KEY : H-3-99-12345 AGENT : 45678-00 GPREM : -300.00 The master will become as the following after the updating pro...

hi, first thing to check is the time out settings on the ODBC broker on the server. we had problems with that. increase it appropriately. we also had another problem. Use of too many joins in the odbc query was slowing down data extraction. here appropriate indexes ( in line with your join condition...

HI Peggy, Please use this code in your Transformer: NumericRound4(DSLink3.t_odis) replace t_odis with your column that causes problem. FOR ALL... In SQL Server 2000, please only use the following Varchar/Numeric and Decimal for numbers with fractional components (decimal upper limit is 28 in SQL Ser...

This is a topic for an orphaned message.

Dear John Billy, Hi.We had a similar problem .We were extracting date fields from Informix 7.3 (HP Unix) to SQL server 2000 (Win 2000) The problem was all the proper dates get returned ok.the problem is for NULL and invalid dates : So we wrote this piece of code in the Transformer: If (IsNull(DSLink...

This is a topic for an orphaned message.

Folks, I need to connect from a Win (NT or 2000 ) box client with DS 4.2 to a Progress RDBMS Ver 7.3E on SCO Unix Box (Server) We installed the ODBC drivers from Merant (merant.com) and we tried other ODBC evals like data direct...None seems to even work In one case alone (with a win 98 machine) we ...

I have also faced similar problems with jobs. I have tried validating the job ..and then it would work. But the behaviour is not very consistent, so I cannot really be sure. > > > > Hello Luc, > > Below I have pasted some error warnings that might > prove to be useful in > > the > > future. From wha...

I have also faced similar problems with jobs. I have tried validating the job ..and then it would work. But the behaviour is not very consistent, so I cannot really be sure. > > > > Hello Luc, > > Below I have pasted some error warnings that might > prove to be useful in > > the > > future. From wha...

I have a feeling that the rows per transaction is only important when there are multiple links in to the Target stage. If you plot two links in to the target stage then another field will appear on the screen containing rows per transaction. The online help should give you what you need. ----- Origi...