DSXchange

Hi, My company is using DataStage version 5.2 and is trying to develop an installation program for setting up DataStage at a client's site. It currently does everything from installing DataStage to creating the database and connections that it will operate against. However, it is not able to create ...

MAT,

I too have had a similar requirement in a project that I did some time back. Do you have an email address to which I can send a more detailed and direct response?

Chris Simms

No, not yet. But I think I have arrived at a solution to my problem. I am fairly certain I have been able to duplicate the encryption/decryption that DataStage v5.2 uses. So as far as my tool is concerned, it should work fine for that version of DataStage. Edited by - csimms on 12/05/2002 16:03:45

Ray, First, thanks for responding. If and I am not saying it does not, DataStage uses one-way encryption, how would an encrypted parameter value used to represent a database connect password work? That is if there is no decrypt() function, how would the DataStage server while executing a job pass an...

Hello everyone, I am developing a utility DataStage v5.2 application to help automate my company's on-site DataStage job update process. My company is of a situation where it must perform on-site updates of a core set of DataStage jobs whose associated parameter values vary by client. The applicatio...

Rasi, We encountered the same problem. We needed to be able to insert and retrieve binary objects from a database. The solution that worked best for us was to write our own custom plug-in passive stage that handled the database connection via ODBC. Using a custom plug-in allowed us to implement the ...

Mathieu, Below is the transform function code that I use to create a type 30 hash file. By modifying the DICT array, you should be able to specify the required fields for you file. Hope this helps you. Chris RoutineName = "rout.CreateQueueHashTable" JobName = "XTekCreateQueueHashFile&...

Hello, I also talked with Ascential's DataStage support. The job API is not shipped with version 5 and will not be shipped with version 6. Also, there are no future plans to make it available for either version. As an alternative, is it possible to make use of Universe's InterCall API when wanting t...

Ray/Craig, Thanks for the ideas. What I did do to solve the problem was to write a before-job routine responsible for executing the table deletes and truncations. This approach seems to work fine. The reason for the before-job routine was that I need a common solution that would work for various typ...

Ray, Thanks! The after-stage routine works great. Sometimes, I guess you have to think out of the box. Chris Chris Simms Senior Systems Engineer Extended Technologies Corporation 9708 Skillman Road Dallas, TX 75243 csimms@xtekcorp.com www.xtekcorp.com 214-540-4108 (Desk) 214-540-4000 (Front Desk) 21...

Sorry for waisting other member's time with this posting. The "Trailer Record" question posted previously gives the answer to my question... Hello everyone, I need to insert a special "E!" end-of-record indicator as part of processing data into a sequential file. Assuming that I ...