Posted: Mon Oct 29, 2012 6:39 pm Post subject: Need to put records a Sorting order as mentioned below.
Can you pls help to get the records in below order using sort.
eg: Records are like :
==> We are looking sort these records such that for ";FUNDVALUEDTL" the type codes (08,06,01,02) highlighted in bold; records should be in order as type code 01 then 02 then 06 then rest. Issue here is the position of type code is not fixed but for sure it comes after two semi- columns( after b]FUNDVALUEDTL[/b].
We thought below sort but not able to collect what exactly should be there after WHEN condition.?????
apparently William was able to point you in the
so that you could learn, yourself, how to accomplish the task!
That makes responding to questions enjoyable.
Not only have we shared,
but someone is well on their way to sharing, also. _________________ Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
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