DSXchange

Hi All, When i try to execute the below query in sql developer/Toad it's fecthing the required results. DATE1 & DATE2 is date datatype in oracle SELECT nvl(abs(to_date(DATE2,'dd/mm/yyyy') - to_date(DATE1,'dd/mm/yyyy')),0) as DATEDIFF, FROM TABLE; But, when i try the same in Oracle Connector in ...

Like chulett suggested we need to have before job script in which we can check for the number of columns . If the columns are more/less than the expected then send a mail notification. coming to column definations we have to use schema file with RCP. the schema file needs to be updated in before job...

Without Parameters , what i mean is you should not pass the date from outside. we should generate the date and form the file name. My requirement is i will be getting files for each day and i want to read a file that comes today when my batch runs. In Routines can be pass a value to existing filed i...

Hi,

I want to pass file name to sequntial file stage in runtime without using parameters. I heard it can be done with routines .Pleasse let me know how to do with routines . Also if any other ways to pass.
Example . include date in filename. like abc_20180605.txt

Thanks,
Rrcr