Re: Query Definitions Using Printers

Jerry

No direct APIs that I know of. I suspect that those utilities use something like DMPOBJ, although I have no knowledge of that. With that command, you get spooled output with the contents of the object - a *QRYDFN in this case. The printer name is definitely in there, but I can't guarantee it's always in the same place. There are probably offsets to the various kinds of information.

Try DMPOBJ YOURLIB/YOURQRY and then look for the name of the printer in the spooled file - if it's a query that is set for printing. Try it with a couple different ones with different fields selected. See where they are, then look for a binary hex value that gives you the offset.

Do you have a headache yet? Take 2 and sleep 'til morning!!

Vern

On 7/26/2010 3:43 PM, Jerry Adams wrote:

Is there a way to get a list of the *QRYDFN objects that use a printer? I have a couple of utilities from the trade mags that will list the database files, but none that includes the printer files.

This is a quick and dirty one-off so I'm looking for something to an outfile, but an API will be acceptable.

Thanks.

Jerry C. Adams
IBM System i Programmer/Analyst
If Lincoln were alive today, he'd roll over in his grave. - President Gerald Ford.
--
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx