Search found 4 matches
- Mon Sep 24, 2018 11:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error message: ORA-01858: a non-numeric character was found
- Replies: 6
- Views: 5020
Re: Error message: ORA-01858: a non-numeric character was fo
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 ...
- Mon Sep 24, 2018 5:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic file structure
- Replies: 5
- Views: 3421
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...
- Wed Jun 06, 2018 11:00 pm
- Forum: General
- Topic: how to pass filename to sequential file stage in runtime
- Replies: 9
- Views: 5916
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...
- Tue Jun 05, 2018 4:26 am
- Forum: General
- Topic: how to pass filename to sequential file stage in runtime
- Replies: 9
- Views: 5916
how to pass filename to sequential file stage in runtime
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
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