DSXchange

A varchar2(50) source column containing a string value less than 50 in length with no trailing spaces when loaded to target oracle table where the target column is defined as varchar2(50) is padding out the string value with trailing spaces to 50 characters in length. My understanding was that when ...

As part of our housekeeping processes to get rid of orphan datastage processes we schedule a weekly start/stop of datastage. Unfortunately the stop sometimes fails as daemon drsrpcd will not shutdown - the Datastage documentation for this that I have found on the Internet indicates that the process ...

Ray, it is specifically around the scenario when records are rejected during the upsert. The log shows how many records have been rejected but they do not generate warnings as they would in server. Is there a reason for this and is there a way to make director generate warnings for these rejected re...

Ray,
i'm specifically talking about using the oracle upsert feature.

In server most oracle errors would generate a warning in the director job log.

This does not seem to happen in enterprise.

Is there a reason for this and is there a way to force oracle errors to generate a warning in enterprise.

The oracle stage is performing an upsert.

No warnings appear in the job log but when a peek stage is configured to capture rejected records on the oracle stage, oracle warnings appear in the job log as peek output but not as job warnings.

In server edition oracle warnings generated warnings in the director job log. The job could then be configured so that 'X' many warnings would cause the job to abend. Oracle warnings do not seem to generate job warnings in enterprise oracle stage. Is there a way to force the job to abend if a certai...

Yes that sounds good.

Can it be adapted to search a specific column within the record?

Is it possible to search through all the records of a large volume dataset for column values without having to use the view options in the dataset stage and in dataset manager.

ArndW,

i was specifically talking about the scenario where the inputs to the join/merge did require partitioning and sorting and the productivity gain being not having to add sort stages on all the inputs because auto would performs these tasks autmoatically 'under the covers'.

I have just read the enterprise developers guide section on join and merge stages and it states that if auto partitioning is selected datastage will automatically hash partition on the matching key and then sort the partitions using the matching key. This feature has a productivity gain associated w...

Is their an equivalent feature to the server oracle stage 'before and 'after' SQL options in an oracle stage in enterprise.

if not what is the next best alternative.

I am already converting the term_end_date into a date format using TimestampToDate before applying any of the other functions.

The input date is TermEndDate and is a timestamp format.

I'm trying to use StringToDate and generating the followin error message :- 'Conversion error calling conversion routine date_from_string data may have been lost'. The format is - StringToDate(trim(svTermDate2,' ','A'),"%yyyy-%mm-%dd") svTermDate2 = svTermDateYYYYMinus1:"-":svTer...