DSXchange

Hello Gurus, Today i created a job where i send a E-mail to me and my project mates as and when a job gets completed.. Now when the job gets completed i get a warning in director:" SeqLoadHash..JobControl (DSSendMail): Parameter 1 ('0') does not start with a keyword ".. but the mail was ac...

Hello Gurus, I need some help in my job design, i have a sequential file as input and a transformer and one seqential file and reject data as output.. in my transformer i use a constraint for moving the data.. whenever the job has some reject record i see the status in the director as Finished(See l...

This is a common problem that usually everyone face while designing datastage jobs. If some one open a job in Designer and if it is open for more than session expiration time then the job gets locked. It is always better that you inform your collegues that if some one opens a job they have to close ...

I am giving a sample Store Procedure where you pass the Country_id Open a cursor to store all the values there.. CREATE OR REPLACE PROCEDURE <Procedure_Name>(Country_id NUMBER) IS BEGIN IF Country_id IS NULL THEN Cursor Country_out is Select * from table; Else Cursor Country_out is Select * from tab...

Are asking about how to write a Stored Procedure for your condition?...

I haven't used store procedure in my project.. This topic has been discussed already i am give that link...viewtopic.php?t=91200&highlight=Stored+Procedure

Hi, Data source is empty mean that data has not moved to hash file.. have you checked source.. what are you using in as a source?.. is it a file or database connection.. if file have you properly specified the delimiter..check the source data first by looking at the view data option.. which first en...

Hi All,

This is same issue that was discussed two days before.. So go through that you can unlock the job with the help of administrator.

viewtopic.php?t=91295&highlight=

Hope this help..

Can you tell us wht that job is doing?.. does that involve any hash files or files releated jobs.. just give more information about this job. A job will get locked when it is opened in Designer and the session getting expired.. so when someone tries to open that job you will get a error message sayi...

Job parameters are always Project specific i.e is Environment Specific.. parameters will be different for development Env compare to Production Env.. one of the way to reslove this is using some tool(I am not sure which tool.. probalby some expert can help you in that).. or we can use the option wha...

Thank YOU KIM for posting this...I would be a great help for beginner's like me to start understanding complex datastage comcepts.. Thanks once again KIM...

How are you running this store procedure?.. does the user has permission's to execute the procedure.. confrim this from your DBA..also give us some info on wht does that store procedure doing...

I think since you done have a key in the second lookup it is taking more time to retrive the result.. can you try using a sort stage to sort the incoming data from the database.. this might retrive the data quickly..i am guessing ..just give a try and let us know what has happened...

Does COUNTRY_CDOE, COUNTRY_NAME, DOMAIN_NAME and IP_NUMBER are also keys in this table or not..or IP_NUMBER is the only key.. are you using the concept of surrogate keys in this table..give us more info or the datamodel so that we can find why this is taking more time to execute...

i got full permission from my administrator after that the issue got resolved..so currently i am ok with this.. but going forward if a new user joins then he has to be given full permission tot the client folder... i don't know how my admin will accpet or not.. so it is better for me to get the Patc...