DSXchange

Not clear what is your exact requirement
Is it to load less number of rows to the target?
in that case head or tail stage would do.
I am not getting what you did in force compile as it never gives any options to limit the rows

sorry that I am not getting your requirement, please clarify

sendmk wrote:Hi

buildop -f -BC /opt/SUNWspro/bin/CC -BL /opt/SUNWspro/bin/CC -C

I have never seen cc in Capital letters, this should be small lettered cc right???

Just a thought,
Ajith

Are you using a modify stage somewhere in your design and modifying the Field which is not found???

What is the filter condition??, are you sure that the column it says not found exists???

Need more info

In the column definition tab of the output, go to the relevant key column, do an edit row. From the properties set the field width and padchar property accordingly. This will solve the problem. I am wondering why is this happening to a char column , anyways try redoing the stage, That is how I solve...

Ray, It was not giving any score when it was aborting. The problem was due to an incorrect column name in modify stage. When I corrected it it was okay. I got the score after running it, but I have no idea how to analyze it. It looks like it, main_program: This step has no datasets. It has 1 operato...

thanks ray, will check it out and post it ...

Three of my jobs had the same problem. When I validate the job I get errors like this VendAcptStsRsnHighestSurKey_agg: Error when checking operator: Could not find input field "VEND_ACPT_STS_RSN_STG_KEY". It is there, but datastage is not seeing it, may be that stage got corrupted or somet...

I dumped the score Log looked like this; main_program: Max inbound connections per node = 1 Max outbound connections per node = 1 main_program: Defining Section Leaders. main_program: Contacting Section Leaders. main_program: Broadcasting score. main_program: Score (9,371 bytes) sent. main_program: ...

main_program: orchgeneral: loaded orchsort: loaded orchstats: loaded main_program: Returning step status of APT_StatusOk. main_program: Could not check all operators because of previous error(s) [api/step_rep.C:1144] (There is no previous error mentioned in the log) main_program: Creation of a step ...

Probably you can do one thing, split the job into two, one for writing the insert records to a dataset and one for loading it into a oracle target. Then schedule the second job after the first. That will reduce the database hits too . Secondly, make sure that your datatypes match, there are no leadi...

chulett wrote:

ajith wrote:There is no initcap function in PX Transformer as such. I think you have to write a parallel routine for that.

Posted as a 'Server' question, hence my answer.

My Mistake , You are right

There is no initcap function in PX Transformer as such. I think you have to write a parallel routine for that.

Thanks,
Ajith

Hi Mahadev The jobs are already existing and we are not allowed to add or remove stages unless it is very much necessary. Is there any posibility of using Lookup satge to match first or last value in case of multiple matches of the key Thanks in advance. Regards, Girish There is an option to take a...

Actually, I'd say the support for string manipulation in DataStage is very extensive. 'Better' is a relative word, so perhaps in some instances in some shops there are 'better' ways to do it, but I prefer to stay in the tool if at all possible... and I don't recall the last time that wasn't possibl...

Hi, I have heared that c/c++ compliler is installed while installing DataStage. So can we write c/c++ code and deploy it on DataStage. If yes then how? I have no idea since I am new o DataStage. Thanks Sanjeev Welcome Sanjeev, You can write custom code for parallel routines to implement various tas...