Search found 30 matches

by venki
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

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.
by venki
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

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.
by venki
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

The obvious first question to ask is whether the directory /opt/IBM/InformationServer/Server/Datasets exists and, if so, whether the executing user had rwx permission to it and/or the /opt file system ... Hi Ray, up to "/opt/IBM/InformationServer/Server" avaliable, Datasets seems to be li...
by venki
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...
by venki
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

balajisr wrote:Set APT_DISABLE_COMBINATION to true to identify the stage causing the error.

Hi,

It gives problem at SCD stage.
by venki
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...
by venki
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.
by venki
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

Before I didn't get any problem it was working fine.

Two days back ADMIN was created NEW PROJECT in that also we did two test jobs sucessfully. After that i am getting this problem in old and new project also.
Thanks in Advance...
Venkat
by venki
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
by venki
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.....
by venki
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...
by venki
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

Search for "failed to load" would be a good start. Then investigate your shared library search list environment variable. Edit your post and check th ... Hi, Can you tel me what is this error rtld 072-001: symbol execute ............./opt/ibm/ibminformation server/server/ds components/bin...
by venki
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.
by venki
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...
by venki
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"