DSXchange

Understood. Thank you Ray.

oh my bad. The test project doesn't have user routines. But I have a question. why it will gives failed error. it make me confusion.

Thanks ray. you are correct. I am able to export user created routines.

Hi, i am using 11.7 windows version. i am trying to export all ds objects thru isx commands. i am able to do for jobs, connections, parameters settings. But when i am trying to export routines, it is giving error like export failed. Below is sample command.(i renamed the servernames and creds). Any ...

Sorry for late reply.

Ray, im not premium user to see your post.
I gone through all the tabs and options in connector stage but couldn't find any. Are you talking about grid in sql builder?

Hi, I searched in DSXchange posts and didn't find matching posts, so I'm writing new topic. I designed an job in DataStage 8.7. This job has sequential file -> transformer -> Oracle connector. While loading to target stage I'm able to write user defined SQL or SQL built thru the SQL builder option. ...

Thanks Craig.. Yes, you are correct. we are getting crc hash value to identify new records. Change capture stage is good idea. In existing job, we calculate crc value for all columns (all columns concatenated in one string to calculate crc32). Then this value is used in a lookup with target table. I...

Hi, Sorry to replying in 10 year old thread. i have shared server container, we are using CRC32 function(for all the columns concatenated). Im using this in parallel job. it is taking too much time. we are in thought to replace this container with some parallel functions. Could someone suggest, how ...

Naveen, Im using sequence activity inside sequence job. This activity is set to ANY mode. Three jobs are used as to trigger this activity stage. after sequence activity, email notification activity is used. if three job activities are triggered. If any one of the job completed. im receving an email....

i came up with work around. for all the jobs, i added two trigger conditions, like ExecAll<>Y and jobstatus=1 to one sequencer activitiy. ExecAll =Y and jobstatus=1 to another sequencer activity. First sequencer is set to Any. Second is set to All. Again one more sequencer to both. then email acitiv...

sorry for the confusion. In my sequence i have three nested conditions to trigger individual jobs. Assume, to trigger jobA, condition is ExecAll=Y or Executone=A. For job B,condition is ExecAll=Y or Executone=B. For JobC condition is ExecAll=Y or Executone=C. If i pass the parameter ExecAll=Y All th...

I had issue with excel file while transfering the file to unix box. OS admin cleared the issue and then job works fine.

We found an solution. DS 8.1 use less block size compared to DS9.1. So while we are updating the records, blocks arrays are different.

Our DBA identified the issue. while updating the rows, locks are happening in DS9.1. So He increased the INITRANS for tables in database. Problem is solved.

Hi, I have a sequence like below. Three jobs are designed based on nested conditions. followed by sequencer, user variable activity and email notification activity. If all the three conditions are meet, three jobs will run. But im receiving only one email. Is there anyway to get three emails?. Alter...

We recently migrated from 8.1 to 9.1 version. For oracle database, we changed from entripse stage to connector stage. we are using 4 node config file. when we run the job, jobs are getting hung. queries are strucked on wait status. DBAs are saying multi DML statements are pointing to same segments/b...

HI, Is there prerequisites to extract excel files? I am using unix based DS 9.1 version. Client is windows 7. I installed excel 2010 in client version. I am able too see the data in windows. I moved the file to unix machine through winscp. I am trying to extract the data using unstructured data stag...