Any syntax to find an empty workfile in natural ?

beruoist · New User Joined: 14 Nov 2007 Posts: 70 Location: mumbai

Hi,

I need to know, that is there any function by which we can know that the file is empty

Regards

ofer71 · Posted: Wed Sep 17, 2008 11:08 am

There is no ready-made Natural function for that.

You have at least three options:
1. Use READ WORK FILE ONCE and see if there is at least one record.
2. Invoke a job that tests for file emptyness from within Natural, and check the return code.
3. Call a REXX exec (using IRXJCL) from within Natural to test for file emptyness. Set an appropriate return code on return to Natural.

O.

beruoist · New User Joined: 14 Nov 2007 Posts: 70 Location: mumbai

Ofer,

can you please elaborate a bit in the second point.

Thanks

ofer71 · Posted: Thu Sep 18, 2008 12:39 am

There are many many ways, using JCL, to test if a dataset is empty. Search the forum for lots of examples.

When you have the job ready, invoke it from within Natural, using NATRJE or RPC. Then, after job has been submitted, you can either check its MAX-CC or by any other means see the results (for example, write the RC to a dataset or as an input to another Natural program).

By the way, my first suggestion would be the easiest to implement.

O.

beruoist · New User Joined: 14 Nov 2007 Posts: 70 Location: mumbai

Thanks Ofer