Re: List of who is the owner of Mapics files.

[graybeard@xxxxxxxxxxxxxx]

You can query the system directly

SELECT DBXLIB, DBXFIL, DBXOWN FROM QADBXREF WHERE DBXLIB = 'AMFLIB1' 




On Tue, 6 Nov 2007 09:52:57 -0800, "Jon Le Roi" <jleroi@xxxxxxxxx> said:
> William,
>
> There is probably a newer better way to do this but this is how I
> learned to get this list many many years ago.
>
>
> Execute a DPSOBJD command to an outfile.
>
> DSPOBJD OBJ(amflibx/*all) OBJTYPE(*file) OUTPUT(*outfile)
> OUTFILE(libraryname/filename)
>
> This creates a file in the library specified with an entry for all files
> in AMFLIBX (of course change to your specific library)
>
> When you query the file you just created, the ODOBOW field contains the
> owner of the object.
>
> Regards,
> Jon 
>
> -----Original Message-----
> From: mapics-l-bounces+jleroi=tegal.com@xxxxxxxxxxxx
> [mailto:mapics-l-bounces+jleroi=tegal.com@xxxxxxxxxxxx] On Behalf Of
> Willie J. Moore
> Sent: Tuesday, November 06, 2007 8:49 AM
> To: mapics-l@xxxxxxxxxxxx
> Subject: [MAPICS-L] List of who is the owner of Mapics files.
>
> I am looking for a way to list all our Mapics files (amflib) and have
> the ownership displayed.
> I would like this to be outputted to a file so I can query it.
> Thanks for any help,
> William Moore
>
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
> a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
> change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/mapics-l.
>
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.