Re: Query Definitions Using Printers

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

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
>
>