Re: Stored Procedure/Powerbuilder - Permission Questions
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 proc.
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 Powerbuilder
. 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
} *********************************************************************
}
}