DSXchange

I checked it kumar. THere is no such character

The ouptut is

0

I am using cat in command and file name in parameter. I am using in the stage as follows: Expression type = Custom COnditional Expression value : Execute_Command_12.$CommandOutput ='0' (for one link) Execute_Command_12.$CommandOutput<>'0' (for naother link) Even though my procedure gets executed suc...

I am sorry for my mistake. My files ares tored in unix box.

And The procedure returns "0" if success and can return any oracle error number if not sucesss.

Is there anything similar to type(windows) in UNIX.

Is it cat?

I am unable to get a clear picture of how to implement using Command Activity Stage

Could you give me some more ideas plz

Thanks Actually the error can be anything and not only 1. I developed a routine as follows: $INCLUDE DSINCLUDE JOBCONTROL.H EQUATE RoutineName TO 'GetErrorNum' EQUATE filename TO FileName * Attempt to open the Error file. OpenSeq filename TO SeqFile Else Call DSLogFatal("Error opening ":fi...

Hi I am having ajob sequence. One of the job activity in the job sequence has a job in the following way: STPstage--->Sequential File. So now the sequential file is storing the output of procedure as Error num = 1 or 0. But my sequence is runing irrespective of whether the procedure fails or success...

Thx all Actually my Oracle team will develop functions and give it to me to implement the job calling the func/proc. I tried executing the SQL code in TOAD too with SELECT stmt. It is supposed to give errornum = 0 if it gets executed succesfully. But it is giving 1. So I figured out that it is not t...

Hi I would like to call a function which is in Oracle. I know one way of doing it (Call it as select in OCI stage) But the function which I am having does not execute with SELECT stmt and gives it error num as "1". But when I execute this function normally, it is doing good. So Now I decid...

Thx..

I changed in the target also now. Its working

Hi I am trying to read data from oracle and laod the data again to a table in oracle. I am getting invalid number error. i checked the datatypes and loaded one by one. i found that one of my field "REP_ID" is causing invalid number error. In the source it is of varchar datatype and nullabl...

Hi I am trying to extract the data from a table. I am using a DRS stage as source.I loaded the table definitions and thereby columns. When I click on View Data button, it is giving warning as "OCI has fetched truncated data" When i say ok, it is displaying some of the data. what might be t...

Thanks for the idea.
Anyway, I figured out the problem.
I am a novice to this forum and I feel sorry if my way of posting questions seems to be rude. I would be good from next time.

HI I am struck in the rates table now. The problem is : I am doing a lookup on saome keys like year and period. If the Currency_Code is not USD in the main table and lets say it is EUR, now I have to do lookup on the rates table for the conversion rate to USD. Main table: Curency_Code, Amount, Amoun...

Thx very much. i will try doing the thing you suggested