MVSFORUMS.com

aruna_space · Beginner Joined: 13 Mar 2007 Posts: 15 Topics: 5

Hi,

We have a very BIG data which needs to be processed in Stored Procedure, which is not sufficient to pass in Linkage section as PARM value. So it comes in as XML file.
Can we process the XML file through Stored Procedure.

I understand we can use XML parse in case of normal COBOL program but for a Stored Procedure, i am not sure how to give the XML file as input and READ.

Kindly Advise,
Aruna.

William Collins · Supermod Joined: 03 Jun 2012 Posts: 437 Topics: 0

How big? Greater than 128MB?

kolusu · Posted: Wed Jul 02, 2014 10:55 am Post subject:

aruna_space,

Please search before posting. Check this link

http://mvsforums.com/helpboards/viewtopic.php?p=14678#14678
_________________
Kolusu
www.linkedin.com/in/kolusu

aruna_space · Beginner Joined: 13 Mar 2007 Posts: 15 Topics: 5

Hi,

I found a way to CREATE a table with XML data with the help of the link given.
But still, the data i am gettin in XML format is around 90,700 bytes. I need to recieve it as input through Stored Procedure.

So i have 2 problems:
1. Recieving Big data inside Stored Procedure
2. INSERTing into XML field in XML table

My Input will be something like this.

kolusu · Posted: Wed Jul 09, 2014 11:00 am Post subject:

aruna_space · Beginner Joined: 13 Mar 2007 Posts: 15 Topics: 5

Hi Kolusu,

I still Need to recieve XML input into the Stored Procedure through Call string.

Need to read the XML data from Call String and INSERT it into the table that is created.

Thanks,
Aruna.

kolusu · Posted: Thu Jul 10, 2014 1:03 pm Post subject:

aruna_space,

I am confused now, I thought you defined the xml file to the SPAS and you should be reading it like any other sequential file. I thought that was the original question.
Why do you need the CALL statement?
_________________
Kolusu
www.linkedin.com/in/kolusu