Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
get routine into & put routine from
I understand thats these commands ( get routine into & put routine from ) are for doing a bulk copy of the procedure and redeploying it . This works fine with the same OS. suppose i hav to to the same operation across OS ie from windows to AIX. what is the procedure to be followed. Is there... -
AIX ( SQL4301N ) : Error while building ora8. external Stored procedur
We hav set up a new databse set up on AIX . this externale procedure ora8.. is giveing us a trouble. since we are new to this ... we need help.... CALL SQLJ.INSTALL_JAR('file:/home/tmsadmin/ora8UDFs.jar','ora8.OBDEV9II') I get the error db2 => CALL... -
Errors encountered while Ececuting a procedure
I have run that this problem comes when we execute a particular procedure and the database goes down the procedure has DECLARE sql_statement VARCHAR(5000); DECLARE rowcount_cursor CURSOR FOR v_stmt1; DECLARE rate_filter_refcur CURSOR WITH RETURN TO CALLER FOR v_stmt; PREPARE v_stmt FROM... -
Errors encountered while Ececuting a procedure
SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "10.80.10.46". Communication function detecting the error: "recv"...
