dynamic field level auditing

[Guest.Visitor]

Hi GDroke. The short answer is "No." The long answer is....."Also, no." RPG does not allow you to reference a field and/or the field's contents as a variable. I think you can using Embedded SQL, but I have never attempted to do so. -Mean 1

[gdroke@hmstn.com]

That's mean, 1. Would you please give me an idea how you would use embedded SQL to perform this task?

[Guest.Visitor]

Any book on SQL programming will give you sufficient info. It is easy to code. Very similar to SQL statements.

[gdroke@hmstn.com]

I need a way to capture field level, file changes without hard coding the field names. I can retrieve the field names, but those names are just characters in a variable to the RPG program. Is there any way to make the RPG program recognize the "data" as a field name. Is there a better approach?

[ukpi1b]

I have an example how to use variable field names to extract and validate data in a file/field via CL and QMQRY. If that will help, I will post my answer. Please, let me know