DSXchange

Thanks every one for all the help.
I will try that .

Thanks
sheema

ok,kenneth than should i type in my update statements as it is in the before and after tabs of ORAOCI stage.or should i follow any other format.

my target database is oracle.

It is a target table .
ok,i had that doubt whether i can update tables which are not repository tables.so should i have 2 jobs which run before and after the job respectively.
Is there any way that i can do it in a single job .

Thanks
sheema

No,it is a table in my schema.

I have a job where i need to run a update statement on table xxx before the job runs and another update statement on table xxx after the job is completed. I have put the update sttements in Before and After Job-sub routines respectively under the ExecTCL option.but i see a error Output from UniVerse...

I did not get any warnings.
But when i created Indexes on the table today,it is running fine.
Thanks for the help.

Thanks
sheema

My job uses a flat-file as source that passes through a transformer, where 7 or 8 new fields are appended with some values and then i have 4 hash files as lookups to 2nd transformer.I check if row exists i perform an update operation or else insert operation into Oracle via 2 OCI stages. The problem...

Thank you for sending the routine ray.

Sheema

Ray,

I am waiting for the IsValid() function for server Jobs which you promised to post.

Thanks
Sheema

Hi Ray,

I need a routine which checks if the date is in valid format ,if not convert it into desired format.
I came to know that you have a routine written for this purpose,can you please display it .

Thanks

sheema

Is there any way that i can validate the date through stage variables.


Thanks
sheema

I want to do this using Stagevariables.

In first stage variable Stage1 i use IConv(Date,"DYMD[4,2,2]")

Now i want to check the status of the above stage variable and do an OConv().Can you guide me how to do this.


Thanks
sheema

No,I cannot see the premium content.


Thanks
sheema

Thanks,I am not able to see the premium content.

Any help is appreciated.

Thanks
sheema