DSXchange

thanks. that has worked.

hi i am trying to calculate the average price via the aggregator. the scenario is as follows. i have a prodid, amount and qty. i am multiplying the price against quantity in the transform to obtian the total value. the quantity can be any number i.e 1 - 100. when i perform the average aggregation in...

it is a simple select statement. no rows should be returned as the table is empty but i receive a million blanks.

hi, i have an Oracle table which contains no data. however when i access this table through an OCI stage it returns in the excess of a million blanks. i am putting the OCI through a hash file into a transform. the reason why i am doing this is because at a later date the table will be eventually pop...

Hi,

If i want to check if records do not exist between a Flat file and a OCI stage in order to report a message will the command 'NOTFOUND' be appropriate.

I am proposing the following if LnkFrmOCICust.NOTFOUND then message else ......

Thanks

[quote="ray.wurlod"]Are you running a UNIX version of DataStage in the Cygwin emulation, or are you running a Windows version of DataStage? quote] We are running a Windows version of Datastage, we only use Cygwin when checking or renaming files prior to running DS jobs. When I say "fr...

we are experienceing a strange intermitant situation at the moment using Datastage v6.0.3 on a windows 2000 (SP6) environment. Every so often the system freezes and becomes unusable causing us to reboot. I was wondering if anyone has ever experienced this type of situation or whether there is any ad...

This environment is a datastage Project - which we term Production. We also have another environment termed Development. Hmmm. Environment sounds synonymous with project in the posters world. Access to servers is handled via userids and passwords, not a problem to lock down a server that way as som...

I am a new starter to Datastage. The company I have recently joined are using Datastage v6. We have a requirement to make one of our "environments" to be read only. This environment is a datastage Project - which we term Production. We also have another environment termed Development. To m...