DSXchange

Hi Everyone!

Does anyone have a rule of thumb for how many transforms should be included in one job for the best maintainability or for best practices?

Thanks,

Sharon

Hi, Can anyone help me to convert DB2 Long Varchar(360) to the Oracle Varchar2(360) in the datastage ? The Datastage has complained about input string is too large to be stored in the target database. I tried strip function on db2 and trim function within the datastage transform stage, both resultin...

Thank you for all of your help. The error was in how the DBA had set up the table. -----Original Message----- From: Himanshu Patel [mailto:hpatel1@nc.rr.com] Sent: Tuesday, October 22, 2002 12:31 PM To: datastage-users@oliver.com Subject: RE: ds error Holly, A few questions to possibly help analyze ...

Question for the forum,

Can DataStage handle being given an OUTPUT record layout that contains what Cobol calls "numeric edited items". Does DataStage know what to do when asked to move/assign data to a numeric edited item such as PIC +9(3).99?

Thanks
Himanshu

Holly, A few questions to possibly help analyze this. I do remember in the past when I had similar insert problems, I went thru the following checks. 1. Are you sure its the NULL fields that are the problem? 2. Have you manually tried to u and paste these values into a insert statement and try a man...

You could use the NullToEmpty (TransformsBuilt-InNull) Transform in each of the derivations for the fields which are not allowed to be NULL. Thanks, Lester F. Callif / Ascential Software, Inc. Centennial, Co -----Original Message----- From: Godfredson, Holly To: datastage-users@oliver.com Sent: 10/2...

It would be helpful if you provided the ddl for STOR_DIM. Mike Gohl International Truck and Engine Corporation Enterprise Data Warehouse Team Leader Phone: 630.753.5567/Fax: 630.753.6710 Internet Address: mike.gohl@nav-international.com -----Original Message----- From: Godfredson, Holly [mailto:HGod...

Could you please help with the following error? We have redone the job and have tried to reassign the source as NULL, then NOT NULL, but neither will work. We are extracting from an Informix IDS 7.31 database and loading to a IBM RedBrick 6.11 database. The job has run successfully in the past. Than...

Hi, you could achieve this using link variables which include the last error and SQL error information. You could using these link variables to create a link constraint. The output link for errors could contain a single column with a call to the DSLogFatal in the derivation. hope this helps Simon. >...

You could have a stage variable which passes DSGetLinkInfo(DSJ.ME, transformstagename,linkname,DSJ.LINKLASTERR) to a Transform Function which calls DSLogFatal if the passed value is not an empty string. -----Original Message----- From: bxdatta@regence.com [mailto:bxdatta@regence.com] Sent: Tuesday, ...

Try setting up a rejects link from the Transformer stage that is feeding the OCI stage, and setting the warnings limit for that rejects link to 1. The job will then abort on the first rejected row. ----- Original Message ----- From: bxdatta@regence.com Date: Mon, 21 Oct 2002 19:12:40 -0700 To: Subje...

Hello ! I wanted to update a table by a User Defined SQL in an OCI8 stage (thats part of a bigger job) .. I wished to avoid row by row processing... Whenever the sql fails (maybe rollback error, not null constraint violation etc), I wanted it to gererate an "abort" error instead of a single warning....

Chris, Thanks. Its been running since the error but I hadnt gotten back to you yet. Thanks, Kenny -----Original Message----- From: chris.thornton@ascentialsoftware.com [mailto:chris.thornton@ascentialsoftware.com] Sent: Monday, October 21, 2002 4:10 AM To: datastage-users@oliver.com Subject: RE: JOB...

Peter, Id certainly suggest that you talk to support about it. It would seem reasonable to expect a fatal error when the query is first declared, rather than every time a row is updated. It would also seem reasonable for a consistent treatment of the error. -----Original Message----- From: Beug, Pet...

Hi, Does anyone know why the OCI Oracle stage plugin considers an ORA-00942 error a warning on update and a fatal on insert? On an update (update existing rows), I get the following error as a warning for each row I attempt to update: Warning PshBwebTblUpdateLod..JobExecutionErrorXfm: ORA-00942: tab...