DSXchange

We Can achieve your requirement by writing the Basic Routine and call that in After Subroutine box. First thing is make the constraint as per your requirement in a new link called dummy link ( Condition is data='False') in that link just create a column called Dummy and direct to Copy stage and leav...

Finally I got the sloution.

We have to give the values as 101A'\,\'101B'\,\'101C in the parameter and inside SQl we have to pass the parameter in Quotations like IN ('#FACPARAM#').

It worked for me.

Hi Ray, Thanks for your reply. I am passing the parameter #FACPARAM# and passing the values as '100A','101B','101C' and inside that SQL I am passing the parameter without Quotations like FAC in (#FACPARAM#). In this Case job is aborting. If I pass the values in the parameter like 101A,101B,101C and ...

Hi All, My Requirement is like these : In my SQL I have to use IN condition for checking the few strings. I have to pass these strings in a parameter as per my requirement. I am using the DB2 EE stage for my extract from DB2. But, my job is aborting as it is not able to perform IN function with the ...

Hi Dsxians, Today I have encountered one strange thing in DS Parallel Lookup. Its related to Condition Box on Constraint Tab. I have one reference link for my Lookup stage and Whenever I tried to insert some condition on my Reference link by using the Inputcolumns from Driving link, I didn't get tha...

Hi Swathi, There are so many stages in Parallel to support reject process. Lookup ----- Lookup fails (capture the driving link) Merge-------- join fails (Capture the refrence/updated records) Tranformer -------- caputure the records which are not satifying the requirements (Like null handling) Seque...

If you are not able to do, whatever mentioned by our DSxians....
Just go to the Dataset Management tool in Designer/Manager. Just select your file it will shoe number of rows in each node. Is it ok for you ?

Hi ,

What about next val function ?

Just add a new column called SEQ_NUM in database column list and in the Oracle stage in place of '?' give the function nextval for SEQ_NUM.

Try out.

Hi Kadet,

It seems your problem with null handling in the transformer. are you doing any null handling with the stage variable in your job ? what transformation your doing in your job ?

Just check your doing any wrong conversion ?

Hi All,

Thanks for your replies.

Can you give me some idea of Basic cod about my requirement (Abort job based on a condition)

Hi All, I have a requirement to abort my job based on a constraint in Transformer. My constraint is If cloumnA is null then abort the job and insert a statement like 'Job is aborted CloumnA is null'. I came to know that it is possible with subroutine called Call DSLogFatal (Message,CallingProgName) ...

Hi,

The main reason for your problem in compilation is, your using Isnotnull and substring function together on same field and at the same time.

So, Split the condition and use the logic like these.....

If Col1='A' Then If Isnotnull(Column2) Then Column2[1,7] Else Setnull() Else Setnull()

Hi Ray,

Thanks for your valuable suggestions. I will try what ever you said and let dsxians know the result of my job.

Thanks once again.

Create another output link from the Transformer. Its constraint is the logical inverse of the constraint you have been using. On this link set Abort After Rows to 1. The link can connect to a Copy ... Hi Ray, Its a good idea to capture the rows to another link and abort the job. Here my doubt is if...

This section leader died,

First reason for this is you are using wrong username which don't have privileges of your databse.

Unix SIGNAL kill also one of the problem.

lack of resources also one kind of problem.

Post the complete details to analyse more on your problem.