DSXchange

Thanks Krub.

Thanks Ray. I'll try to do it in that way you have adviced.

Ray, Actually iam using the same table(3 stages) and also the different ones, The sinario is I have to lookup for msr_prd and I need to reject, the same way I have some more validations with other DB2 Table and need to update in ctrl and other stuffs. The problem comes in the Links iam using the job...

Hi, Hi, I got a problem while connecting more than 8 transformers in my job. But If iam running with 7 connections of transformaer I did't get this problem. The Error I got is, Message : ConnectionTEST..DSDB28:[IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or ...

Hi Vis,

Change ur plugin.


KAM

Hi, My Datastage Server is Installed in Unix. In our SQL Server we have stored procedure which extracts data and places into the file system. But unfortunately it can only place into SQL Server which is in NT Server. I want that file to be placed directly into the Unix File system. Which is the best...

I am designing my jobs to read a file and get all the parameters value to start the job. Is it good idea to use Sequential file or Hash File to store values which we are going to use for all the jobs. If we use this file for all our jobs will there be any problem with the Share Lock when multiple jo...

Hi Ray,

I tried inthat way only but it's not working. Any other alternate for this problem ?
Thanks,

Kamal

Hi following is the statement i used to assing values after reading from hash file. There is no error in the job but the parameter passed is empty. Thanks Kamal Open "C:dataDSLink2" To filevar Then ParamName = "User_Name" Key = "User_Name" ReadV ParamValue From filevar,...

Hi Uneumann,

Iam Using 5.2 and Row per Transactions is set to '0'. I did't get what you are mention about Transaction Grouping, Kindly clear this.
Thanks,

Kamal

Hi All, I am using stage constraint and abort rows as 1. When I run the job it stops immd when it violates the constraint but also it commits all the records till it processed. I don't want that to happen. Any chance of getting rollback in this if one record violates the constraint. I am using oracl...

Thanks for your reply Ray, What i need exactly is to use a hash file to store all my user names, passwords etc. and to read it in the control file before starting the job and assing it to the default parameters. I had made it worked with text file but i want this to use hash files. It will be useful...

Hi All,

How can I read Hash File using script and how to assign values after reading it.

Thanks

Hi all,

I want to Include CTRL file information into my blob image and i convert into XML in my first stage. My CTRL file info's in separate table. If i include into Blob the XML structure is changed. kindly give me some solution for this.