DSXchange

I have used keymanagementnext value for a target column in the development and when releasing the same job to production i would live to have the surrogate value to start from first number. Could any one help me in this regard.

Hi All, My scenerio goes as below, Please help me to solve this... 1.One column in the oracle table is having XML path in .XSD format.This column has 68 rows. 2.We need to take all the rows in the above mentioned column and parse the XML message. 3.Each XML field will be stored in a column in DB2 da...

Hi All,
Does datastage supports JDBC connection.I want to know further details on this JDBC connection.Is there any separate licence pack available for this purpose.


Thanks in advance.

Regards,
Premila

sorry it is not the same sequential file given to source and target it is to be given at source and reject file name and target is given a different name.....

Hi ,

Can this be possible that my souce and target both refering to same sequential file.

Regards,
Premila

Thanks ray
All the suggestions were really helpful to me.Resumed working.

Regards,
sangvi

with my design i have an extra column that waits for a derivation to be passed when called from reference link....is there no dummy derivation that i can call to make datastage understand it is a dummy column.. or else how sud i process this job ..this is one requirement from my client. help me out ...

Hi Kcbland, there is four columns in sequential filesay name datatype col1 varchar col2 numeric col3 date col4 numeric for the above i used a aggregator to find the summing col4.all before using aggregator i added a column counter and made that column as a key so that col4 is grouped by col1,col2,co...

Hi , I need to have a reference lookup with a hash which has two keys fields .One key field is a counter and another is the field that finds matching rows with the database table.Actually this counter field is not matched with anyof the columns in the table and so is a dummy . If this the case what ...

Hi, As per the below post in the forum i tried all the possible ways but still get the same error.Please suggest me a way to get rid of this.I had gone thru few other post in the forum but still i couldnt resolve the issue. http://dsxchange.com/viewtopic.php?t=88975&highlight=exclusive+access+to...

Yes the job is actually running and i could see the log file giving me the warning message though i reset the job.I had cleared the log file as instructed in forum for the same subject. I even try to export and import the job and even tried deleting the job but i m given with a error message saying ...

Hi,
I worked around with all the possibilities given in this forum but still unable to resolve this error.i tried even
GUI opt for Immidiate purge but again no result i still get cannot get exclusive access to executable file for job ...Please someone help me out .

Regards,
Sangvi

Hi,
Now i am ready to meet any challenge from client side with this forum as my right hand support. Kudos for all those who give us valuable suggestion through posting inspite of all their busy schedule.

Regards,
Sangvi

Hi, 1. We are facing a problem in running released jobs through server edition. Its giving mutex error problem for the IPC stage. The same job is running fine with non_released version i.e., the original job. Its throwing error only for the released version. we are sure that we released the exact jo...

Hi
I had a step working for this just wanted to verify will that be fine.Called the date field from file into the transformer with DateGenericGetMonth function and then use aggregator to group the field and got the result wanted.

Regards,
Sangvi