If you use @INROWNUM function it give max record in each of the node.
i think this function is not help full to identifying last record.Try with this:
@PARTITIONNUM+(@NUMPARTITION*@INROWNUM-(@NUMPARTITION-1))
Regards,
Venkat.
Search found 30 matches
- Mon Jun 16, 2008 2:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to check for last record
- Replies: 6
- Views: 3115
- Mon Jun 16, 2008 2:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to check for last record
- Replies: 6
- Views: 3115
- Mon Jun 16, 2008 1:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: My job is getting aborted and getting following fatals
- Replies: 5
- Views: 2925
- Mon Jun 16, 2008 12:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: My job is getting aborted and getting following fatals
- Replies: 5
- Views: 2925
My job is getting aborted and getting following fatals
Hi, I am trying to run a job with single source and single target in between i used one copy stage the job is getting aborted and giving the following fatals, APT_CombinedOperatorController,0: Write to dataset on [fd 14] failed (Error 0) on node node1, hostname huxd0208 APT_CombinedOperatorControlle...
- Wed Apr 30, 2008 1:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Index too large
- Replies: 6
- Views: 2873
- Tue Apr 29, 2008 5:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Index too large
- Replies: 6
- Views: 2873
No. While operator combination is enabled there is no sensible way to determine which operator is generating the error. Disable operator combination. Describe your job design, so we at least ha ... Hi Ray, This is giving the SCD stage operator .But why I cont find.Can please explain me more details...
- Tue Apr 29, 2008 3:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Index too large
- Replies: 6
- Views: 2873
Fatal Error: Index too large
Hi,
I am getting following FATAL Error while running my jobs.
APT_CombinedOperatorController(2),1: Fatal Error: Index too large
Previously these jobs are running fine.
Can any one give some input..
Thans in advance
Venkat.
I am getting following FATAL Error while running my jobs.
APT_CombinedOperatorController(2),1: Fatal Error: Index too large
Previously these jobs are running fine.
Can any one give some input..
Thans in advance
Venkat.
- Mon Jan 14, 2008 6:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: I am getting an error while saving/compiling the jobs
- Replies: 4
- Views: 1314
- Mon Jan 14, 2008 6:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: I am getting an error while saving/compiling the jobs
- Replies: 4
- Views: 1314
I am getting an error while saving/compiling the jobs
Hi,
I am developing jobs in Parallel i.e 8.0.1.
I am getting an error while saving/Compiling the jobs, The Error message is
unable to save editserv.impl.jobdefnimpl@70b7225d
Any ideas, Please help me out..
Thanks in Advance
Venkat
I am developing jobs in Parallel i.e 8.0.1.
I am getting an error while saving/Compiling the jobs, The Error message is
unable to save editserv.impl.jobdefnimpl@70b7225d
Any ideas, Please help me out..
Thanks in Advance
Venkat
- Thu Dec 27, 2007 6:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SCD stage compilation error
- Replies: 5
- Views: 1562
SCD stage compilation error
Hi, I am facing problem with SCD stage while compliing the job it is giving the following error "If at least one type 2 column present,then SCd stage requireds either a current indicator column or expire date column(or both) to be present inthe dimension table. but in my SCD stage both having.....
- Wed Dec 26, 2007 7:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: rtld 072-001 (xml input stage)
- Replies: 1
- Views: 767
rtld 072-001 (xml input stage)
hi, i got the following error when runnig the simple parallel job. job design is: seqfile-->xmlinput---->seqfile error: rtld 072-001: symbol execute ............./opt/ibm/ibminformation server/server/ds components/bin/xmli.so :but run time defifnition at the symbol was not found i guess this info re...
- Wed Dec 26, 2007 1:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting the error while reading the XML input file
- Replies: 4
- Views: 1475
- Thu Sep 13, 2007 2:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to convert VARCHAR to DECIMAL
- Replies: 2
- Views: 1323
How to convert VARCHAR to DECIMAL
Hi,
In my jobs i am using two oracle stages. one is source and other one is Lookup. In source column Datatype is Decimal and lookup column datatype is varchar.
Please help me out.
In my jobs i am using two oracle stages. one is source and other one is Lookup. In source column Datatype is Decimal and lookup column datatype is varchar.
Please help me out.
- Fri Aug 17, 2007 4:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: "DSD.BCIPut call to SQLExecute failed"
- Replies: 1
- Views: 925
"DSD.BCIPut call to SQLExecute failed"
Hi All, While loading data from Sequential file to RACE AS/200 Tables using ODBC we get warnings for each row. Source file is fixed width file (Source and target is having inly one Column). The error message is EP_lodins_popf0027and0102..MapToPopf0027DbTgt.Popf0027DbTgt: DSD.BCIPut call to SQLExecut...
- Fri Aug 17, 2007 1:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: " Parameter marker text size exceeds allocated space&qu
- Replies: 1
- Views: 779
" Parameter marker text size exceeds allocated space&qu
Hi,
While loading data from sequential file to RACE AS/400 tables by using ODBC stage, i got warnings, the warning is
" Parameter marker text size exceeds allocated space"
While loading data from sequential file to RACE AS/400 tables by using ODBC stage, i got warnings, the warning is
" Parameter marker text size exceeds allocated space"