DSXchange

Routine activity always fails if returned value is other than 0. Then what is the need of allowing dufferent expression types like (custom, retun value..) . Is this a bug in datastage. So if i get a return value other than 0 and if i dont uncheck the "automatic handling" and 'Log warning i...

when i tried to execute a routine in a sequencer, this is the error i got

"Routine DSU.mdsCountLines did not finish OK, return code = '61'"

Now where can i find the information about the error codes for routine

Put another way, there is no documented mechanism that allows you to establish DEFFUN declarations for trigger expressions. Sorry guys, I am really brand new to this field.Can you please let me know "what is meant by DEFFUN". The problem is solved by using an execute commandactivity. But ...

Put another way, there is no documented mechanism that allows you to establish DEFFUN declarations for trigger expressions. Sorry guys, I am really brand new to this field.Can you please let me know "what is meant by DEFFUN". The problem is solved by using an execute commandactivity. But ...

I was calling this routine in JOBACTIVITY--->TRIGGER---->Expression. No indication of syntax error.

Hi. I have a small issue. In my sequence there are 5 job activities. In the third job i will produce a sequential file. If the flat file contains any records, whole sequence should be terminated. For this i have used a terminator stage attached to job activity 3 and for its trigger i have given 'cus...

From dataset i am removind duplicates using the remove duplicate state. Now my requirement is to capture those duplicates which are removed and place in a sequentil file. How can i capture those removed duplicates.

Not via rollback since you commit in job #2. What you need to do is to include some mechanism for identifying the rows that are loaded (such as a unique run ID or a timestamp) and delete these should that become necessary. If you need to "rollback" updates or deletes, it becomes a little ...

I particularly know what row is going to be updated. How can i create a before image of the table with datastage itself. even i create a before image of the table, can i recover it using the datastage. Imp.point is this recovery should be automatic. I cannot go and run the recovey job, after knowing...

i would like to debug my job while running(or after) row by row. Can i do this in datastage. I dont know how to debug . relatively new to datastage. please help me. If this is found in document, please give me the location of that in the document.

Hi I have a really interesting scenario " Initially i run the sequencer. There are 6 jobs in the sequencer. In the 2nd job i will update an oracle table. later all the jobs will be run. but if any job (3,4,5,6) job fails, i have to rollback the data in the oracle table.(i want the data in the o...

"They" did a lot of work with Transformers for version 7.5 - they now generate code that's quite close to an operator. The incentive to remove them is not as great as it once was. There is no real alternative to taking the first character somewhere - the Switch stage does not have any com...

Why not just substring the first character and check that? I have tried that and its working. But the original job has lots of transformers in it. so i want to get rid of any transformers (i have used transformer to substring the first character) if i can. Is there any other solution using other st...

HI. Lets say i have 4 records aaardtg basertydfi cdrefitjf deryihlffg There is only one column point to note is first record start with a, second with b, third with c and last one with d. I read this data from a sequenctial file. Now i have to split this 4 records to 4 individual flat files such tha...

I have tested the code in toad. its fine. But it is not working from datastage.ITs schema is
ATTRIBUTE16, VARCHAR, LENGTH=150, NUllABLE
its not a key column and there is nothing under scale