IBM Mainframe Forum

Hi,
Could anyone please tell me how to write a select statement to retrieve a value in the specific field, which has a string of indicators?

It’s located in the position 472 in one big field which is 700 byte long - SERS-PR-TRANS-RESTRICT.

I tried this and did not work.

SELECT SERS-PR-TRANS-RESTRICT(472) FROM D332SHC.SERS
WHERE OFFICE = ‘111’
AND ID_CODE = ‘0335’


Thank you!!!

Hello,

For someone here to help, you need to post a more complete description of what you want to do. Keep in mind that we know only what you post about your table definition, your data, or your requirement.

I suspect that you want to retrieve a substring. . . .

Are you using spufi or are you working in some program?

Hello,

You might want to look here:
http://publibz.boulder.ibm.com/cgi-bin/ ... j10/3.2.94?

Yes, it did. I used the substring as you suggested and it worked great. Thank you!!!!

You're welcome - good to hear it is working

d