DSXchange

The key piece of information is the 16 Rows affected part, which is an extra informational message the database is returning and which causes DataStage to generate the warning. What database is this? Are you purposefully trying to update multiple records at a time? am using sql server 2008 for both...

HI ALL, I have a simple server job, plain simple source to target mapping with no transformations in transformer. every time i run the job, am getting the following WARNING MESSAGES FOR ALL THE ROWS. majority of the rows are getting transferred to the reject with a few being written to the target ta...

This date... is it an actual Date datatype or is it a string? For the former, there are functions to get that, for the latter you can use substring. Also, you marked the job as Server yet posted in the PX forum, which job type is it? That will change the answer as to the function needed. its in dat...

Hi,
I have a querry, a small one...I hope someone can help me out with it.

I need to extract just the month from the date which is in format YYYY-MM-DD. can some one help me out with it.

Thanks in advance

That helps. You are checking if the stage variable LastGiftResponseDate is null on line 118. There is no property to allow a stage variable to be null. So you cannot set it to null or check to see if it is null. Many times the error that is causing you grief is not the first thing that you see a wa...

That helps. You are checking if the stage variable LastGiftResponseDate is null on line 118. There is no property to allow a stage variable to be null. So you cannot set it to null or check to see if it is null. Many times the error that is causing you grief is not the first thing that you see a wa...

lstsaur wrote:Are you running 7.5.3 version on Windows platform?

yup...

Please post the entire error message. Output from transformer compilation follows: ##I TFCN 000001 15:32:17(000) <main_program> IBM DataStage(tm) Parallel Extender 7.5.3 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I TOSH 000002 15:32:17(001) <main_program> or...

Is this the entire error? Is it complaining about a lookup stage that is defined to reject, but there is no reject link? well its a part of the error....rest of the errors are regarding the data conversion...i am using the look up, but it is not to carry a reject link...after look up i have transfo...

kwwilliams wrote:One of your stages (probably a lookup, transformer, or database stage) is specified to reject but you don't have a reject link coming out of the stage.

Hi Keith...i checked for those, but they r fine...i have reject only at the target oracle level and that too is taken care off...

What does that mean, exactly? An exact search for your full error message returned 134 matches and I'm sure they all "open up" just fine. :? Can you be more precise on the problem you had with the search? true...it has 134 matches, and when i try to open the link by clicking on the topic,...

vinothkumar wrote:Please do a search in this forum and see whether it helps.

HI...i did so..but i guess either the page is expired or some other prob..as it didnt open up...

Hi ...am trying to compile a job and this is the error that i am getting...can anyone please reflect upon it..
The number of reject datasets "0" is less than the number of input datasets "1"

You need to choose the Upsert method, then copy the Update statement into the clipboard and change it to an Update Only method and then paste the Insert statement into the Update field. There is no Insert only method in this stage so you need to trick it. I guess they expected insert only streams t...

was wondering if anyone can give an insight if there is an INSERT option in the ORACLE Enterprise stage as a WRITE method....