MVSFORUMS.com

[dhulipalla]

Table
-----
Scode char(5)
Pcode char(5)
type char(1) having values p/s

[shekar123]

Hai Dhulipalla,

The input data as well as desired output data provided you is unreadable format.Here is the solution if u want to display data in the format as it should have been ,you have to embed the data within the code tag and i have used color tag with green option and you have to close tags too.

For example in your case you should use:

Code:

XXXXX AAAAA P BBBBB S CCCCC S YYYYY DDDDD P EEEEE S FFFFF S GGGGG S

Similarly

Code:

PCODE PCODE TYPE ----- ----- AAAAA P BBBBB AAAAA S CCCCC CCCCC S DDDDD P EEEEE DDDDD S FFFFF DDDDD S GGGGG DDDDD S

Does the data formated by suits me your requirement ? Hope this helps.
_________________
Shekar
Grow Technically

[dhulipalla]

Shekhar..I formatted my data..thanks for your suggestion..

Table
-----
Scode char(5)
Pcode char(5)
type char(1) having values p/s

[kolusu]

dhulipalla,

I have no idea about what you are trying to do. A better explanation would make it easier

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[dhulipalla]

Kolusu,

I have a table with the following data where each SCODE is having multiple PCODEs with type P & S

[kolusu]

dhulipala,

How do you relate BBBBB and CCCCC records to scode of XXXXX ? There is no indicator to tag those records to scode of xxxxx

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[dhulipalla]

Kolusu

We can tie the PCODE BBBBB, CCCCC with XXXXX.

[kolusu]

dhulipalla,

Try this

[dhulipalla]

Kolusu,

That's working fine..Thanks..