1
  • 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.  

    aceofdelts1,720 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following