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
Search found 76 matches
- Thu Jan 04, 2007 10:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Limit the number of records
- Replies: 4
- Views: 2779
- Sat Dec 30, 2006 1:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: BUILD OPS GENERATION FAILED.
- Replies: 6
- Views: 4358
Re: BUILD OPS GENERATION FAILED.
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
- Thu Dec 28, 2006 4:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: The specified field does not exist in the view adapted schem
- Replies: 7
- Views: 7048
- Wed Dec 27, 2006 11:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error inserting null value to fixed width seq file
- Replies: 5
- Views: 4084
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...
- Wed Dec 20, 2006 12:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Could not check all operators
- Replies: 8
- Views: 5513
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...
- Tue Dec 19, 2006 10:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Could not check all operators
- Replies: 8
- Views: 5513
- Tue Dec 19, 2006 8:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Could not check all operators
- Replies: 8
- Views: 5513
Solution
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...
- Tue Dec 19, 2006 4:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Could not check all operators
- Replies: 8
- Views: 5513
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: ...
- Tue Dec 19, 2006 1:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Could not check all operators
- Replies: 8
- Views: 5513
Could not check all operators
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 ...
- Mon Dec 18, 2006 12:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Duplicates while inserting in to target
- Replies: 7
- Views: 3320
Re: Duplicates while inserting in to target
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...
- Mon Dec 18, 2006 12:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: initcap
- Replies: 6
- Views: 4886
- Mon Dec 18, 2006 12:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: initcap
- Replies: 6
- Views: 4886
- Thu Dec 14, 2006 5:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup stage key multiple matches handling
- Replies: 7
- Views: 14702
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...
- Wed Dec 13, 2006 8:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can We calculate the no. of Alpha Char. in a string
- Replies: 6
- Views: 3610
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...
- Wed Dec 13, 2006 7:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: C++ Module
- Replies: 3
- Views: 1834
Re: C++ Module
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...