DSXchange

hi craig, i am not passing the data from source to target, i am sending the data to another system via webservice url. let me explain it in detail. i pick data from source, then with the help of XPATHS ( AKA BOD and many more names) i define the XML tag, this tag holds the value of, say , some colum...

thank you all guys, i really enjoyed having those helpful hands and wonderful suggestions .... i will try to find another way around to work without hints, also, i would try RIGHT CLICKIN EVERYWHERE. Thanks to ya all again !!!

source (oracle) -> XML O/P -> WS TRFR -> XML I/P -> TARGET (ORACLE) this is the flow in the job for data. In XML O/P stage, in the output tab, in options tab we can specify the path and choose to save the XML generated with the XML O/P stage. If i choose this option, the data will not flow further, ...

If i import the table definitions of a table, will the synonyms, indexes, constraints be imported too. No. It's not a modeling tool. If not, while running a SQL query from DS do i need to specify any particular command to involve indexes and all other related stuff with the table !! No, not for Dat...

If i import the table definitions of a table, will the synonyms, indexes, constraints be imported too. If not, while running a SQL query from DS do i need to specify any particular command to involve indexes and all other related stuff with the table !!

Would appreciate if anybody can help !!!

i am using DS to send the data via XML. The issue is, i can either send the XML or capture it. i cannot cpature and send at the same time, coz when i try to capture it, the job aborts saving the XML to the defined location. Does any one know If we could capture and send it at the same time. Thanks i...

and dont put the column_name in quotes as i did, its just to highlight. Try this in your SQL query in ORA stage TO_CHAR ("COLUMN_NAME", 'YYYY-MM-DD ') and change the data type to VARCHAR. Now try viewing the data I changed the datatype to TimeStamp in my oraOCI but still i am getting the s...

Try this in your SQL query in ORA stage TO_CHAR ("COLUMN_NAME", 'YYYY-MM-DD ') and change the data type to VARCHAR. Now try viewing the data I changed the datatype to TimeStamp in my oraOCI but still i am getting the same error when i click the View Data option. I knew that DB2 accepts int...

Yes sir, They are RO

Alright let me take all the pain to explain you in peace. 1. Right click on routines tab in ur repository 2. choose "New Routine" 3. Name it "XYZ" and paste the code that you copied from the earlier one. 4. Now edit it as you wish, and dont forget to change the filename in which ...

Well i do ps -ef | grep phantom | grep "username"....i get all the phantoms created with my "username" and they have a PPID of 1. The main concept is that i want to capture an XML. I declare the path in the XML O/P stage in its O/P section, and the job obviously gets aborted crea...

hi DSGURU, its not that i am getting warnings in the jobs, my concern is when i try to bounce my DSServer i need them closed. And i explained you how i will have to close it, Just looking for a better option to not have them opened. Also i noticed more the phatoms, slower is the response from DS. :r...

Try Modifying the routine. Open the routine and click on the 'CODE' tab. Then comment the last line in the code that reads "Writeu NextVal On SeqFile, Arg1 Else Ans = -1". Put an asterisk * in front of it . This routine may not modify as it is built-in, try copying the code and paste it in...

Whenever i choose the option to write the XML O/P to a file, a phantom process is getting created. And these processes dont die on their own, i need to go looking for them and kill each one of them.Is there any option to capture XML without creating phantoms. !!!