Help with understanding : select stmt from sysibm.syspackstmt

[Kingsly]

How to read "stmt" column of "sysibm.syspackstmt" table in a readable format?

select stmt from sysibm.syspackstmt where name like 'MYPROC1';

I was expecting the stored procedure statements as the output. But executing the above statement yields,

x'0700C4001002000000000000000000000000000000000000 000000000000000000000000000000250005F1000080D5D3'
x'000002550000024DC4C5C3D3C1D9C540D9D3C16DC3E4D9E2 D6D940C3E4D9E2D6D940E6C9E3C840D9C5E3E4D9D540C6D6D9 40E2C5D3C5C3E340D4C4D3404B40D4C4D3D5C1D4C56DC6406B 40D4C4D34 04B40E2E4C2D4C4D3D5C1D4C56DC6406B40D4C4D3404B40E2C 3D9C5C5D5D5C1D4C56DC6406B40D4C4D3404B40E2C3D9C5C5D 56DC9C4406B40D4C1E7404D40C3C1E2C540D9D3C1404B40D9D 6D3C56DC9 C 440E6C8C5D540F140E3C8C5D540D9D3C1404B40C1C3C3C5E2E 26DC340C5D5C4405D40C1E240D9D6D3C56DD7D9C5D7406B40D 4C1E7404D40C3C1E2C540D9D3C1404B40D9D6D3C56DC9C440E 6C8C5D540 F 240E3C8C5D540D9D3C1404B40C1C3C3'
x'C5E2E26DC340C5D5C4405D40C1E240D9D6D3C56DC1D7D740 6B40D4C1E7404D40C3C1E2C540D9D3C1404B40D9D6D3C56DC9 C440E6C8C5D540F340E3C8C5D540D9D3C1404B40C1C3C3C5E2 E26DC340C 5D5C4405D40C1E240D9D6D3C56DC1C4D4C9D540C6D9D6D440E 3E8D8D4C4D36DD4D6C4E4D3C5E240D4C4D3406B40E3E8D8D9D 3C16DD9D6D3C5C1C3C3C5E2E240D9D3C140E6C8C5D9C540D4C 4D3404B40 E 2C3D9C5C5D56DC9C4407E40D9D3C1404B40E2C3D9C5C5D56DC 9C440C1D5C440D9D3C1404B40D9D6D3C56DC9C4404C6E40F44 0C7D9D6E4D740C2E840D4C4D3404B40E2C3D9C5C5D56DC9C44 06B40D4C4 D 3404B40E2C3D9C5C5D5D5C1D4C56DC6'
x'406B40D4C4D3404B40D4C4D3D5C1D4C56DC6406B40D4C4D3 404B40E2E4C2D4C4D3D5C1D4C56DC640D6D9C4C5D940C2E840 D4C4D3D5C1D4C56DC6406B40E2E4C2D4C4D3D5C1D4C56DC640 6B40E2C3D 9C5C5D5D5C1D4C56DC64000000000'
x'0000005700000032E2C5D3C5C3E340F040C9D5E3D6407A40 C840C6D9D6D440E2E8E2C9C2D4404B40E2E8E2C4E4D4D4E8F1 40E6C9E3C840E4D94000010000001D0007000F400000000000 00000401F 00000000007E2D8D3C3D6C4C5'
x'0000001800000010D6D7C5D540D9D3C16DC3E4D9E2D6D940 00000000'
x'0000009400000045E2C5E3407A40C8407A40C8407E40E2E8 E2C9C2D4404B40C3C8C1D9404D407DE2D8D340C59999969940 94A287408696994086A4A3A4998540A4A2857D406B40F2F0F0 405D40000 200000027000700054000000000000000C801C10000000011D 7F14BE56DE2D8D3D4C5E2E2C1C7C56DC600200007000940000 000000000000201F4000000000AD7F14BE2D8D3D76DC9F8'
x'000000F40000002CE5C1D3E4C5E2404D407A40C8406B407A 40C8405D40C9D5E3D6407A40C8407A40C8406B407A40C8407A 40C84000060000001D0007000A80000000000000000401F000 00000007E 2D8D3C3D6C4C5001E0007001080000000000000000501C0000 0000008E2D8D3E2E3C1E3C500220007001B400000000000000 00401F1000000000CD7F14BE56DE2D8D3C3D6C4C5002000070 01F400000 0 0000000000201F4000000000AD7F14BE2D8D3D76DC9F600230 007002540000000000000000501C1000000000DD7F14BE56DE 2D8D3E2E3C1E3C500200007002940000000000000000201F40 00000000A D 7F14BE2D8D3D76DC9F7'
x'0000012600000052C3C1D3D340C4D9C5E8C6E4E2404B40E4 D1E2D8D3D4E2C7404D407DE8D8C9D5D7F7F0F17D406B407DE8 D8C9D5D7F7F0F17D406B407A40C8407A40C8406B407A40C840 7A40C8406 B407A40C8407A40C8405D40000600000022000700358000000 0000000000401F1000000000CD7F14BE56DE2D8D3C3D6C4C50 0200007003980000000000000000201F4000000000AD7F14BE 2D8D3D76D C 9F600230007003F80000000000000000501C1000000000DD7F 14BE56DE2D8D3E2E3C1E3C5002000070043800000000000000 00201F4000000000AD7F14BE2D8D3D76DC9F70027000700498 000000000 0 00000C801C10000000011D7F14BE56D'
x'E2D8D3D4C5E2E2C1C7C56DC600200007004D800000000000 00000201F4000000000AD7F14BE2D8D3D76DC9F8'

How could I convert the stmt from this hex format to readable format?

I am using DB2 command editor to run the query and the database is DB2 V8.0 running on z/OS. I tried the suggestion given in Reading 'stmt' of 'sysibm.syspackstmt". It did not work and gave the following message.

SQL0969N There is no message text corresponding to SQL error "-4700" in the
message file on this workstation. The error was returned from module
"DSNHSQLA" with original tokens "". SQLSTATE=56038

SQL10007N Message "4700" could not be retrieved. Reason code: "4".

Thanks in advance.

[Gara]

Hi,

I found this, you can try vith the CAST function

SELECT

CAST(STMT AS VARCHAR(3500) FOR SBCS DATA)


FROM SYSIBM.SYSPACKSTMT

regards