DSXchange

You can create routine in designer as well as manager. Open designer, see look for Routine tree in the repository under project. If u don't find there, right clik there and click show routine under popup menu of customization. There u can create server/parallel/mainframe routine. hope it will help ...

us1aslam1us wrote:Those are the types of routines. I you open new server routine you will see a drop down section which will have this.

Also Routines are not developed through designer but manager.

Aslam,
Why Rountines can't be developed using designer, i used to develop server routine using designer.

us1aslam1us wrote:For your second query, It all depends on the dependencies between the jobs.
If your Job_Activity3 is independent of Job_Activity then you can run them in parallel and so on....

In my case all are independent jobs.
I am wondering , how is it possible to run job in parallel in server job??

Log into manager, click on File, click on New Server Routine . You have an option for Transform Routine or before/after . Choose the appropriate one and start coding. Dsguru2B, I don't find "for Transform Routine or before/after " in manager File/New Server Routine. I only see New Server ...

asitagrawal wrote:I tried UTF8 for the DB2 stage, but no luck..

How did u resolve? Did u start getting correct characters in the file ??

In my case I used UTF8 for entire job.
try changing some other map.
Those invalid unhandled character was trunacted some other character.

Almost certainly you need a patch to address the inability to open Job activity in job sequence, and my guess is the XPSP2 patch. Contact your support provider. Your second question is irrelevant. ... Thanks Ray. Though I can't see answer of second part query. One day I will see that also. Regards,...

ray.wurlod wrote:Don't load junk data? ...

Ray,
You are asking or saying?

My source contains around 2 million customer details, out of which 70% records conatins unstructed data/junk character in free format.
No way cleansing this big data.

Thanks

You can create routine in designer as well as manager. Open designer, see look for Routine tree in the repository under project. If u don't find there, right clik there and click show routine under popup menu of customization. There u can create server/parallel/mainframe routine. hope it will help u...

I am in process of creating the sequence, Basically I have two questions: 1) While designing sequence job, I am unable to open property of Job_Activity stage where as I am able to open property of other stage like Terminator_Activity stage etc. Could you let me know is there anything that I need set...

Hi, As per DBA this problem comes due to loading junk data into table.He suggested to use set integrity command. I see don't have this issue for job where data size is small. For big data size job, I see this issue. Anyway using above command things are going fine. But very time consuming task for a...

Thanks Ray, I will check with DBA and will know what is the issue. For the time being i am calling db2 set integrity check sql statement after job subroutine in every job and working fine. For every job i have to do apply this logic. which is time consuming task for all the job. Is any other better ...

Hi, I am getting some peculiar error when i try to access db2 table after loading using odbc stage. The error like this "operation not allowed for reason code "1" on table" This happens not for all jobs, only for few jobs. after checking set integrity on table, i can access the ...

Hi, I am getting some peculiar error when i try to access db2 table after loading using odbc stage. The error like this "operation not allowed for reason code "1" on table" This happens not for all jobs, only for few jobs. after checking set integrity on table, i can access the t...

chulett wrote:This is the FAQ post I mentioned, in case you hadn't found it yet.

Thanks Chulett,
I implemented ur logic and it's working fine.

Once again thanking you.

Regards,
Rafiq

Hi Chulett,
Thanks for response.
One morething where to use Convert or EReplace function i mean in transformer or in basic routine

Thanks