DSXchange

I am trying to capture rejects while upserting records into Sybase. I am using the "insert new rows or update existing rows option." When a record is rejected the REJECTED, REJECTEDCODE are set to 0 in the transformer reject output link. Has anybody else experienced this issue. I appreciat...

DSguru - There is no "Array size" setting for Sybase OC stage chulett - You are right on target. I couldn't think of it. When I tried "insert only" option it worked. That brings back me to the BASIC transformer issue. It still doesn't capture REJECTED, REJECTEDCODE. Perhaps I sho...

The BASIC Transformer in parallel jobs is not the same as the server Transformer stage. For one thing, it won't do reference lookups. See extended post in parallel forum for appropriate techniques to use in parallel jobs. I tried the same in a Server job. Still nothing works in case of insert rejec...

I am trying to capture rejects while upserting records into Sybase. I am using the "insert new rows or update existing rows option." When a record is rejected during insert, no warning is written to the log. When record is rejected during update a warning is generated. In both cases the RE...

Hi, What is the meta data of the DS column definition and the target table definition? what is set in environment variable that effect the precisoin both for DS and Sybase? Target sybase column datataype is float. DS column is float (15). It I change DS column from float to decimal I get a run-time...

Source is sequential file varchar datatype. Althought its decimal, I am reading as varchar and converting in the transofrmer to decimal. Target is Sybase float datatype. source_value = 499000 My transform is: stringtodecimal(source_value)/100000 result should have been 4.99, but in the table the val...

Thanks Kenneth. I guess we have to limit access to development as suggested.

Can I setup a DS user that can only view job design thru Designer but cannot run jobs? The existing "DataStage Developer" role gives permissions to both design and run jobs.

Regards
Sri

I am wondering if there is an equivalent of transaction grouping in Oracle Enterprise stage. This feature is available in Server jobs and I don't see in parallel jobs.
Thanks
Sri

I am designing a Server job. I have a flat file with muli-format records. The first charcter in the record indicates the type of record. Depending on the record type the format changes. Example data: '|' is the field seperator A|2SK1531|DOOB|276708|2767 N|78751|ACON|DonG. Auch C|87228|COMA|C001|3148...

The enhancements have to be new jobs.
Yes, server and parallel jobs can co-exist in a project and they can be called from the same sequencer

Hi, I just finished an in-place upgrade of DataStage from 6.0.1 to 7.5 in our testing environment. I performed the upgrade as root. Everything looks fine except that all jobs are running as 'dsadm' irrespective of the user (owner of the project) that invoked the job. If the job is creating a sequent...

raju_chvr, Thanks a lot for sharing your ideas. I tried LK1.REJECTED OR LK2.REJECTED. Like I articulated in my original message only a failure on LK1 (first link) is resulting in reject, DS is not considering rejects on LK2. Though it generates a warning in the log. As for designing two jobs, these ...

Hi, I am using tansaction grouping (unit of work) and would like to capture errors using a reject link. In my job I have one transformer and one Oracle stage, and there are two links from transformer to Oracle stage with transaction grouping enabled. If there is a reject on either of the links I wou...

Ray, But I believe "update existing rows" option updates the record if there is a record with the matching key exists, irrespective of whether any of the column data really changed. How do I do a conditional update? Meaning update the record only if the data changed for atleast one column....