Search found 77 matches
- 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, ...
- 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
- 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
- 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...
- 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.
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.
- Fri Feb 24, 2006 12:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: joining rows
- Replies: 17
- Views: 6514
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...
- Wed Apr 27, 2005 9:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Manipulating look up columns
- Replies: 4
- Views: 2083
- 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 ...
- 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 ...
- 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>...
- 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 ...
- 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...
- 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.
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.
- 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...
- 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.
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.