Mainframe, MVS and zOS Discussion

Hi,

Please have a look at below input:

SCLA SCLA SCLA
SCLA SCLA 9 SCLA
SCLA SCLA SCLA


output should look like this:

SCLA SCLA SCLA
SCLA SCLA 9 SCLA
SCLA SCLA SCLA


Could someone please help me on this how to do that?

Hi,Every one

The interviewer asked that, "what will be present at the end of record in case of VB record. Assuming VB record's maximum length is 100 byte and first record is 100 bytes long while the second record is 60 bytes. At 61 positon will there be any delimter ?

I could nto answer this ...

Search manual on what? "GROUP BY" is not there, so I assume it's not applicable.

But your reply makes me think, if I need to group by some specific filed from the segment, I'm left to write a bit of program only?

Hi,

In IMS DB is it possible for us to do a Group By, like DB2?

Thanks Anuj.

Thanks Anuj this has worked but why do you use '5' as starting position?

Thanks Anuj this has worked but why do you use '5' as starting position?

Hi,

I've an input variable block file.The data file is like this:

FD004A001<some varibale data>
FD004A001<some varibale data>
FD005A001<some varibale data>
FD005A002<some varibale data>
.
.
.
FD100A006<some varibale data>

All the records records can be in any sequence. I need the records ...