DSXchange

Thanks a lot. Where can we get that code information from. I am facing with one more issue. My data is having some other fields in flat file which is as follows: "Korea" "321" "FY2003" #SI #SI 212.89 #SI 3SI 63.90 "ASIA" "211" "FY2002" #SI ...

Hi

My flat file has data in this form:
"Korea" "321" "FY2003" ....

These are tab delimited. How to mention this in sequential stage properties. Quote character is "

But my function has to get executed when my procedure completes its execution.

Moreover I am restricted to use Dynamic RDBMS stage

Could anyone let me know, How to call a Function which is in oracle. Actually First my Stored Procedure has to execute and after the suuccesful execution, the function has to be called. My function is taking two input parameters The source code of my function is osmewhat like this: CREATE OR REPLACE...

I used a normal job activity..

I figured it out in one way. I am atatching the file in the notification activity.

Do you suggest anyother way

I developed a job sequence:

Initial Job-->StoredpRocedure--->Notificationa ctivity

I would like the output of the stored procedure (error num and errortext) in my email.
Currently i am able to egt only logdetails.

How to send the errornum and errortext to my email

Do you mean to type in columns. I tried in that way. I have seen the following in the output:

ProcCode ProcMessage Errornum Error Mssg
0

Errornum and Erromssg were typed by me.
Does DataStage automatically map the output parameters to the columns I have defined?

Any Suggestions plz

In my case ProcCode and ProcMesage are appearing by default. How to make appear my output parameters (ErrornUM and ErrorText) in column section.. My piece of procedure looks like this CREATE OR REPLACE PROCEDURE Proc_name (errornum out number, errortext out varchar2 ) AS CURSOR c_user IS select * fr...

Thanks for all the suggestions. Right Now I am able to work on STP stage. But I am facing with a trivial problem My job requirement is (A) First I need to run a job (simple mapping). If this job finishes succesfully, it should call a Stored procedure. (B) The stored procedure is just having only two...

Thanks.

I am working on it.

So First I need to run the job.
Then design one more job with a STP stage and call the procedure. Is this the right way of doing it

I am using DataStage 7.5..
I am new to Stored Procedures. I did not work with them before.
ould you plz tell me how to approach the situation. I read the manual, but I did not get a lot from it.

Hi I am having a stored procedure code in TOAD. I am also having a DataStage Job. My requirement is to call that procedure after this job finishes. The procedure has only output parameters and theya re absically Errorcode and Text. The procedure should return only these two values. These should be w...

The Error message is omewhat like this DataStage Job 1738 Phantom 8193 Program "JOB.1518842743.DT.1420153957.TRANS1": Line 279, Improper data type. Attempting to Cleanup after ABORT raised in stage gl_headers2..Transformer_100 DataStage Phantom Aborting with @ABORT.CODE = 3 My job design i...