1
  • How to see output for an AS/400 stored procedure

    I have created a CL which calls an RPG program. Now I have to create a stored procedure which calls the CL! As RPG normally sends back the output to CL! How should I send back the output to SP? Will SP normally pick it or is there any command to send back the output to stored procedure (SP). I have...

    bharathtata25 pointsBadges:
  • How do AS/400 stored procedures get output?

    I have created a CL which calls an RPG program. Now I have to create a stored procedure which calls the CL! As RPG normally sends back the output to CL! How should I send back the output to SP? Will SP normally pick it or is there any command to send back the output to stored procedure (SP). I have...

    bharathtata25 pointsBadges:
  • as/400 disk utilization

    Actually the problem is related with High disk utilization. When I login to as/400 server then there is no any job is runnig but the disk utilization is continously increasing after every 30 min . Increament is 0.5% per 30 min . But I could not find that job which uses that disk utilization can u...

    Sms121185 pointsBadges:
  • Procedure imported in AS/400

    Can any one tell me, how to get the list of procedures Inpoterd by a program which ic reated by CRTBNDRPG.

    Jiks5 pointsBadges:
  • Problems running AS400 stored procedure from SQLServer 2005 SSIS execute SQL task

    I need to run a stored procedure (with two input parameters ) that has no output, on an AS400. When I try using the IBM DB2 UDB for iSeries IBMDA400 OLE DB provider, I get the following error [Execute SQL Task] Error: Executing the query "CALL TPSDTA50GQ.PMCTESTTP('PETER', 4)" failed with the...

    PeterJC15 pointsBadges:
  • AS400 stored Procedure,what is the maximum parameters

    I have created one stored procedure with 63 IN parameters and 1 OUT parameters.This stored procedure is calling one rpgle program.For testing I am creating one SQLRPGLE pgm,this SQLRPGLE pgm calls the stored procedure.But when I am debugging the stored procedure,it is not getting executed.Please...

    AmuthaTPT30 pointsBadges:
  • Stored procedure content

    Is there a way to "retrieve source" on a Stored Procedure ?  I need to find out what 2 of our Stored Procedures do - especially what programs thay call. Of course, no documentation and no methodology for source-based creation.  

    aceofdelts2,340 pointsBadges:
  • Dropping a DB2 Stored Procedure

    In my DB2 stored procs I always first drop the procedure and then do a create statement.  Is there any way I could say something like...if exists (select * from sysroutines where routine_name = 'procname') then drop procedure procname;  ?   I tried this, but the proc doesn't like the IF...

    MIkeyDee5 pointsBadges:
  • Stored procedure

    how to capture the messages sent by Stored procedure.. the one which i'm using is programmed to returned '0001110' if certaine condition do not match...how will i capture this or where i'll see these messages... Thanks, NG

    Nutangujar895 pointsBadges:
  • DB2/400 stored procedures

    Can you please tell me how to create stored procedures in AS/400 and when they are to be used?

    ten20081,150 pointsBadges:
  • Stored Procedure in AS/400

    What different ways to we have to call a stored procedure in AS400 multiple times?How to implement this?Please any body suggest.

    Shiven1710 pointsBadges:
  • How to call a stored procedure which is already there in AS400 multiple times?

    How to call a stored procedure which is already there in AS400 multiple times? Do i require to create any macro for that, if yes what is the procedure. Please omebody help.

    Shiven1710 pointsBadges:
  • AS/400 stored procedure passing parameter

    I have created a stored procedure with an input parameter of type varchar(100). I am using the input variable in the query below select deptid,name , max(location) from emp where empid in (empnos); In which the empnos is the parameter i pass to the procedure and the variable is of type varchar....

    Jacky160 pointsBadges:
  • Error while calling an AS/400 stored procedure

    I created a stored procedure as below CREATE PROCEDURE devbidta.POC_ENROL9(IN compid INT) DYNAMIC RESULT SETS 1 LANGUAGE SQL NOT DETERMINISTIC MODIFIES SQL DATA BEGIN DECLARE c1 CURSOR WITH RETURN TO CLIENT FOR SELECT LEAD_NUMBER,MAX(ENROLLMENT_FLAG) AS ENROLLMENT_FLAG, MIN(COLLECTOR_TRAIL_SEQ) AS...

    Jacky160 pointsBadges:
  • Explain Stored Procedures in AS/400

    Hi, Can any one please explain me 1.What is stored procedures in AS/400. 2.What is the use of Stored Procedure 3.Please give me small example how to code stored procedures in AS/400 4.What is the object type of Stored procedures 5. How can we code stored Procedures and how can we call it. and main...

    Mohan K695 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following