Search found 77 matches

by rajiivnb
Sat Jan 27, 2007 1:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error using Aggregator stage with more records
Replies: 2
Views: 2091

Error using Aggregator stage with more records

Hi, I get an error as the below, after loading 3153072 records. PstnRlns..CalMaxId: At row 3153074, link "PassThr_Agg" Call to input link returned numeric error code: 19 . I use a Aggregator stage and IPC stage. But I hope the error is with the Aggregator. Its not reaching upto IPC stage, ...
by rajiivnb
Thu Jan 25, 2007 7:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unkown result in the output of a routine which use SETFILE
Replies: 15
Views: 6287

Thanks for your time, Chulett
by rajiivnb
Thu Jan 25, 2007 7:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unkown result in the output of a routine which use SETFILE
Replies: 15
Views: 6287

One is in Windows and another in UNIX. The problem is with UNIX server.
Can you please tell me, in what situation it gives TEST FAILED and TEST COMPLETED ?
by rajiivnb
Thu Jan 25, 2007 7:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unkown result in the output of a routine which use SETFILE
Replies: 15
Views: 6287

Unkown result in the output of a routine which use SETFILE

Hi, We wrote a routine with the below, where to find the total number of records. (20 records) Cmd = 'SETFILE ' : hshdflpth : ' ' : 'hsdfile' :' OVERWRITING ' PERFORM Cmd PERFORM 'COUNT ' : 'hsdfile' Ans = @SYSTEM.RETURN.CODE If i run the routine with a hashed file path and name given, the output is...
by rajiivnb
Tue Jan 16, 2007 11:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: split records to multiple output files
Replies: 2
Views: 1416

In server jobs we can use a folder stage

Hi,

In Server Job I used a folder stage to do this logic. In a folder stage give your input column as the filename and the other columns concatenated give it to Record field of the Folder stage. This will create multiple files.
by rajiivnb
Fri Feb 24, 2006 12:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: joining rows
Replies: 17
Views: 6513

Hi You can use the RowProcCompareWithPreviousValue tranform to check the distinct of those first two columns, if its equal u can have a stage variable, and concate rest of the columns which u want it in a single column. before that, the records should be sorted, based on ur first two columns, So cre...
by rajiivnb
Wed Apr 27, 2005 9:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Manipulating look up columns
Replies: 4
Views: 2083

Hi,

You can try a UV stage for a hash file, where you can alter ur key columns of a hash file based on the lookups . You can see the functionaliy of UV stage in the help or in this forum.

Thnx

Rajiv
by rajiivnb
Sat Apr 23, 2005 12:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 'Read-only', should be checked for release jobs ?
Replies: 1
Views: 1434

'Read-only', should be checked for release jobs ?

Hi group, Can any one tell me, whtz the use of checking the 'Read-only' object option in export dailog box. will affect anything, while taking export of 'Release jobs'. Should i check this 'Read-only' objects option, while taking the export of 'Release jobs'. Wthz this 'Read-only' option says. thnx ...
by rajiivnb
Sat Apr 09, 2005 4:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while compiling Sequencer
Replies: 4
Views: 2575

Error while compiling Sequencer

Hi Group, I created a new project, and all the jobs were compiling and working fine. If i compile a seuqnce which i created in this project is throwing this error. Previously this problem was not there, in my old project. only in this new project am getting this error. I havnt exported any sequence ...
by rajiivnb
Fri Apr 08, 2005 4:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while compiling Sequencer
Replies: 4
Views: 2575

Error while compiling Sequencer

Hi Group, If i try to compile the Sequencer, with two job activity, its throwing the following error, <JobSeqGenError> <Code>2017</Code> <Desc>XML parser error on input line 0: source='', reason='The system cannot locate the resource specified. '</Desc> <LineNum>0</LineNum> <Line></Line> <Ref></Ref>...
by rajiivnb
Wed Apr 06, 2005 4:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Prblm while clearing large data
Replies: 14
Views: 5532

prblm while clearing large data

Hi group, Thnx for all ur answers. but my situation is am using a ODBC stage where i have to clear the table which has more than 3 lacs records and freshly need to insert the new records. totaly i have 100 tables with a big sequence. am running only the big sequence. so i checked the 'clear all and ...
by rajiivnb
Mon Apr 04, 2005 10:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Prblm while clearing large data
Replies: 14
Views: 5532

Prblm while clearing large data

Hi Group, We have a table called STORE which has some 3 lacs rows. In the target ODBC we set the update option as, 'Clear table then Insert rows'. But if we run the job, after 1,88,183 records it throws warnings as new record cannot be inserted . one of my friend said, datastage is not deleting larg...
by rajiivnb
Wed Mar 30, 2005 11:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error with DRS Stage
Replies: 6
Views: 4856

Error with DRS stage

hi Ray,

yes we solved it. By setting that particular column to Varchar. thnx Ray. ill open a new thread for the new error. once again thnx Ray.
by rajiivnb
Wed Mar 30, 2005 3:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error with DRS Stage
Replies: 6
Views: 4856

problem with DRS stage

Hi group, We are using datastage 7.1. And we are using the DRS stage as the target stage. We have effective date field in the target with type date (10). I used the DSJobStartDate, as input. but its giving the following error. my database is INFORMIX. "Des_status_time", while processing co...
by rajiivnb
Wed Mar 23, 2005 10:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Informix Wire, unexpected network error
Replies: 3
Views: 2042

Informix Wire, unexpected network error

Hi Ray,

Actually this problem comes only to this particular job. recently this error is coming when ever i run this job, before it was fine. Can you tell me clearly what should be done for this.

thnx,

Rajesh.