DSXchange

Here is my XML and XSD message XML message <ANALYTICS> <INSTRUMENTS ASOF_DATE="2/28/2013" CREATE_DATE="3/8/2013" RECORDS="9361"> <INSTRUMENT> <LEH_SUBSECTOR_LONG>CASH</LEH_SUBSECTOR_LONG> <KTRD_10YR>0.00000</KTRD_10YR> <SM_SEC_TYPE>CASH</SM_SEC_TYPE> <KRD_3YR>0.00000</K...

I saw my xsd file, but i could not find any "list" for node. Is there any tool which can create a xsd file from my xml file. I have create mine from link http://www.freeformatter.com/xsd-generator.html

Please let me know if there is any toll available.

Regards

Hi I have created a test job with the new XML stage with a test XML file and the job is working good. After this I have gone to the actual file and took just the first section of the file and append the the XML ending trailer part to it and accordingly i have created the new XSD file then did the ch...

Yes Ray, I have the .xsd file. I have created this file from my XML data file.
But when i am associating the .xsd file to my schema file it is showing error
Invalid character (Unicode 0*2d)

I have searched my xsd file but i did not find any such character

Regards

Hi All, This is first time I am using XML file stage (DS 8.7). I have gone through the document from IBM, but I am not able to set up a job which reads from a XML file and load the data to a sequential file. Please help me, If any body has any document which describes step by step to implement my re...

Hi All, I have some new issue to address for the same job. I have 2 types of file, depending on the type I have to pass a value to one parameter. Suppose say for type A file the value should be GX else it will be GY. I want to implement this using User variable activity stage. I will create a script...

Thanks Chulett for your response. I am doing the same, checking time and then sending a STOP command to DS engine. All this is happening before the end loop stage. <some satge> ---> <execute stage> -----> <End loop> ----> <begin loop> From your last Ans (" branch past the End Loop " )are y...

Hi Chulett, I wrote a script and kept it just below the Endloop stage. Inside the script i am checking whether the system time is greater or equal to 20 (24 hrs) and if the condition is true then by help of dsjob -stop <proj name> <job name> command I am stopping the job. I have tested the job and i...

Hi All, I have requirement, which says like this. I will be running a sequence (say AA) for a given end time (say 8 PM), and gracefully abort/stop the sequence once the system time is > 8 PM. So i thought to write a script to do this. Initially I though to run the job from unix just to check whether...

Hi All, I have a sequence (seq), and I made the jobs in the seq to run multiple time with the help of looping. The flow is, the seq starts with St Loop and then wait for files if file comes the run the load job or else go to end loop and again start from the St Loop. The number of time the loop will...

Hi All, Is it possible to achieve this using User Variable Activity stage (UVA) or any combination of sequence stages. What ever i found is, UVA can only store a value in variable. In my case I have to find a file pattern in a directory and number of file also. Can it be possible to check all this i...

Thanks Chulett, I was not sure whether I can continue with the old one or not so start a fresh one. Yes, file watcher stage does not accept wildcards. And I can not use shell script to check and create trigger file and make the file watcher stage wait for the trigger file. I have to try other approa...

Hi, I have a sequence. Sequence starts with a loop followed by a sequencer stage. From sequencer stage I have 3 file watcher stage, out of the 3 file watcher file watcher 1 -- looks for exact file name (abcd.txt) file watcher 2 -- looks for file pattern (xyz*.txt), can be one or more files. file wat...

Hi All,

I am trying a approach with 3 waitforfile stage. Once it is i will share the flow.
Thanks you very much for all your help.

Regards
Manoj

Hi, I have design the sequence (each for a job) and it looks like this. startloop --> filewatcher --> job A | | | | | | endloop <-- sequencer <--- Archive but now the issue is whenever i run the job it only goes to sequence (down). It does not cones to Job A, if the file is present in the directory....