DSXchange

Hi All, I have a job corrupted in one project account(devnew). I was accessing a job in this project account and when I tried to open the job it gave me a pop window DataStage Repository Interface This job has no design time information. I really dont know what has happened to the entire job which i...

Narshimha,

At present I am working on 4.2 and also migrating to the 7.5 version.
Please explain regarding the USERSTATUS that you were mentioning, so that I can use this logic when I move the job to 7.5.

Please let me know how do I pass the file (hash/sequential) as a parameter.

Thanks,
Narry.

Apologise for that statement Guru. But I couldnt figure it out whether to create a hash file/sequential file and use the same file data for the next job. kindly advise as to how should I proceed in using that one column and one row data in the next job transformer to populate in one of the column de...

Hi All, I have created a hash file in one job which contains one row and one column. This value needs to be used in the next job. Kindly let me know how do I use this hash file data in the next jobs. Can I pass the hash file as a parameter and use the data in that? This is a very urgent requirement ...

I think what Ray has mentioned is correct.
Ray, but please throw some light on how to create the lookup file set with the hash file using a shared container in Parallel.

Thank you very much.

Nari.

Ray,
Couldnt get what you have mentioned..Please mention it again as to how do I read the log and input the log message into a column.

Thanks,
Nari.

Kumar,
Please let me know if I need to check regarding Unicode or NLS option for that particular column.

Thanks,
Nari.

Log message in the Director SEQREAD1.DRG_MEME_MEMBER: At row 1, link "lnLoadMeme" Sybase Server message 3621 (severity 10) from stored procedure 'Input_0', line 1: Command has been aborted. At row 1, link "lnLoadMeme" Sybase Server warning 515 (severity 16) from stored procedure ...

Hi I am reading a seq file, applying business rules, inserting the correct records into the sybase correct data table, creating an exception data seq file(by using the rejects option in the transformer) and also inserting the source row, load dtm and exception error message into the sybase log table...

Ray,

Please let me know what does it mean by
Code: InLink.FirstCol Matches "0X'.IR'" : @VM : "0X'.P'" : @VM : "0X'.UN'"

Code logic indicates that we are appending the pattern matching characters.

Thnks in Advance,
Nari.

Hi Craig,

I am able to connect to Sybase from the Sybase OCI stage and execute the Stored Procedure but when I use the STP stage and call the Sybase Stored Procedure job gets aborted with the above reason mentioned by Jagdish.

Your assistance in this regard is highly appreciated.

Thnks,
Nari

Ray,

Kindly help us how do I proceed in writing a custom routine for implementing the iterative approach.

Thnks,
Narayana.

Hi Sam,

Thank you very much for all the valuable inputs.

Please share with me the location of ascential manuals where in I can study through some sample custom routines.

At present I dont have the datastage installed at this location.

Regards,
Naraine.

Hi All,

Kindly send me that routine under the Key Managament Category.


Rgds,
Naraine.

Hi All,

Please provide me some inputs as how to write a custom routine in generating a sequence number.
This routine can be called from any job in generating a UserID.


Thanks
Naraine.