| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| problem using Quick sort function |
« View previous topic :: View next topic » |
| Author |
Message
|
| siva1431202 |
 Posted: Mon May 30, 2011 12:40 am Post subject: problem using Quick sort function |
 |
|
Novice
Joined: 04 May 2011
Posts: 20
|
CREATE PROCEDURE quickSort( IN refList REFERENCE, IN sibling CHAR, IN element CHAR, IN typeCast CHAR, IN ascending BOOLEAN)
This is a very good function given for Sorting but i had a small doubt regarding this.
my Input is as follows:
<Employee>
<Emp><empid>1</empid><fname>Dill</fname><lname>Phil</lname></Emp>
<Emp><empid>2</empid><fname>Fohnny</fname><lname>Bill</lname></Emp>
</Employee>
Which values should be passed in the function as i want to sort using EmpID.
Could you please Suggest me.
I am trying this but i am getting Error.
CALL quickSort( OutputRoot.XMLNSC.Employee.Emp, 'empId', 'value', 'INT', TRUE );
Is it a correct one?
Thanks in advance.... |
|
| Back to top |
|
 |
| siva1431202 |
| Posted: Mon May 30, 2011 12:42 am Post subject: |
|
|
Novice
Joined: 04 May 2011
Posts: 20
|
sorry the input is:
<Employee>
<Emp><empid>1</empid><fname>Dill</fname><lname>Phil</lname></Emp>
<Emp><empid>2</empid><fname>Fohnny</fname><lname>Bill</lname></Emp>
<Emp><empid>3</empid><fname>Graham</fname><lname>Bell</lname></Emp>
<Emp><empid>1</empid><fname>Dill</fname><lname>Phil</lname></Emp>
<Emp><empid>3</empid><fname>Graham</fname><lname>Bell</lname></Emp>
<Emp><empid>4</empid><fname>John</fname><lname>Abraham</lname></Emp>
</Employee> |
|
| Back to top |
|
|
| j.f.sorge |
| Posted: Mon May 30, 2011 6:22 am Post subject: Re: problem using Quick sort function |
|
|
Master
Joined: 27 Feb 2008
Posts: 218
|
| siva1431202 wrote: |
I am trying this but i am getting Error.
CALL quickSort( OutputRoot.XMLNSC.Employee.Emp, 'empId', 'value', 'INT', TRUE );
|
Post the exact error message or ask the developer of your quickSort PROCEDURE for the correct parameters.
_________________
IBM Certified Solution Designer - WebSphere MQ V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| mqsiuser |
| Posted: Wed Jul 06, 2011 4:39 am Post subject: Re: problem using Quick sort function |
|
|
Yatiri
Joined: 15 Apr 2008
Posts: 637
Location: Germany
|
Instead of this:
CALL quickSort( OutputRoot.XMLNSC.Employee.Emp, 'empId', 'value', 'INT', TRUE );
please try out this:
CALL quickSort( OutputRoot.XMLNSC.Employee, 'Emp', 'empid', 'INT', TRUE );
If the parsing has been done with a proper schema which "marked" empid as an integer, there might be no typeCast necessary:
CALL quickSort( OutputRoot.XMLNSC.Employee, 'Emp', 'empid', '', TRUE );
_________________
Just use REFERENCEs |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
