MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2014

Re: testing an SQL procedure



fixed

On 9/2/2014 2:45 PM, Gary Thompson wrote:
Thanks Rob, Thanks Buck,
I ran that select on prod and test parts and both return *FILE not found
tried FROM group_ptf_info and FROM wrkptfgrp ?

WRKPTFGRP is a command, not the name of a table. Rob made a good point
that WRKPTFGRP is actually quite old. select * from group_ptf_info
works on my 7.2 system.

I'll suggest those two links to ops mgr
Also, my user prof has all except *SECADM

Try WRKPTFGRP on a command line.
--buck





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact