Re: Stored Procedure/Powerbuilder - Permission Questions
Alicia,
My apologies for the all-too-quick reply. Further thoughts:
Create your SP as Informix on the server.
Part of the problem as reflected from finderr -668, and -648 and the
-172 and -13 error codes may well have to do with permissions and
trying to write or execute. Also, using "system" to do the impossible.
I'd hope that the Informix user id might straighten that out.
Yours,
Nick
On Tue, 16 Sep 1997, Nick Nobbe wrote:
}
} Alicia,
} I think you might want to try creating the SP on the server using dbaccess.
} Yours,
} Nick
}
} On Mon, 15 Sep 1997, Alicia Slaughter wrote:
}
} }
} } Environment:
} } Powerbuilder v5.0 running on Windows NT v4.0
} } Informix - Online v7.21 running on a DG/UX vC2
} }
} } Question(s):
} } 1. I have some folks here trying to execute a system call that runs a C routine within a stored procedure. they are
} } successful at running the stored proc from dbaccess but get a permissions error when they execute from their Powerbuilder app. the SQL code -668 with ISAM code -172. does anybody have any ideas what the cause might be?
} }
} } 2. this is sort of related to the first question, at least I think it is. we have a standard set of debug code in all our stored procs that basicallly allows you to generate a trace file (SET DEBUG FILE TO ...) by passing a parameter to the stored pro
c.
} we have designated /tmp on our UNIX server as the directory where we would like all these trace files to be written. however, we get SQL code -648 with ISAM -13. this setup works fine if we execute the stored proc from dbaccess but not from Powerbuild
er
} . again, does anybody have any experience with this one?
} }
} } I am not sure if these problems we are experiencing are Powerbuilder, INFORMIX or our UNIX system, but I thought someone out there might have experienced my pain on this one.
} }
} } thanks in advance!
} } alicia
} }
} }
} }
} }
} } ********************************************************************
} } Alicia Slaughter
} } EDS-D/SIDDOMS 5113 Leesburg Pike,
} } Skyline 4 Suite 800 Falls Church, VA 22041-3201
} } phone: 703-845-3513 fax: 703-845-3899
} } email: alicia.slaughter@med.osd.mil
} } *********************************************************************
} }
} }
}
}