DSXchange

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, ...

Thanks for your time, Chulett

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 ?

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

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.

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

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

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

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

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

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

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

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.

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

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.