Convert null value to space.

[Ranjeet Gena]

Hi all,

I have created a file with FB/LRECL=200, which is actaully pulled from a database. Because the data comes from the database, the file has gor some embeded null values (x'00'). Can you please suggest a JCL that can convert null (x'00') into spaces (x'40')?

Thanks

[Akatsukami]

JCL cannot do what you ask, as it only establishes environments and executes programs. I recommend using your shop's sort product.

[nicc]

And with your sort product you could robaby use FINDREP. Any queries should be posted in the part of the forum suitable for your sort product.

[Ranjeet Gena]

I've used this on the final file. It works for now :

Code: Select all

OPTION COPY 
    INREC FINDREP=(IN=X'00',X'40')

[zprogrammer]

Thanks for posting the solution Ranjeet

[William Collins]

I hope you don't have any packed-decimal or binary fields in you input.

[Ranjeet Gena]

Hi -

No I had not had those fields in the file.