• How can minimize System ASP used

    My As/400 System % System ASP Used goes to 76 %, How can we minimize this, I already delete Spool File.

    Anupsingh10 pointsBadges:
  • Junk characters in CSV conversion through CPYTOIMPF

    Hi, I am sending data from iseries to excel through CPYTOIMPF i've used this command in CLLE, in query output there is a char field value is '01.03.2011' but when i see in output by wrklnk temp it shows some junk data in this field . RUNQRY     QRY(ADO150Q) CPYTOIMPF  FROMFILE(ADO150F)...

    Rpgle400tech145 pointsBadges:
  • AS400 – SQL

    I want to use Functions in Update Queries Set operation Update File Set FName = Substring(Name,1,10) Where EmpNo = 99 How to perform this one using SQL Queries    

    rajeshece1,215 pointsBadges:
  • Same fle being used by two programs in a job.

    This is in cobol 400. Suppose program A opens a file in input mode and after that program A called program B which again opens the same file in input mode. File got opened successfully. Now assume that file is only getting closed in program A. Is this correct? Are we supposed to close the same file...

    Thotts45 pointsBadges:
  • V6R1 storage limit exceeded for data queue

    Just upgraded to V6R1. Getting the following message in one of my applications: Storage limit exceeded for data queue. Why and how do I correct?

    Kfbarl5 pointsBadges:
  • Progress bar in rpgle

    Hi i have created a progress bar in rpgle , i just want to know is there some way to calculate the completion % of the program . I want this as i want to show the status bar with the percentage completion . My main program just runs 2-3 commands . So just want to know is there some way to calculate...

    munduuu420 pointsBadges:
  • AS/400 Printer will not stop printing 1st page of document

    I have a HP printer setup as a network printer in the AS400 and it will not stop printing the first page of anyting sent to it. Literally there is no end to the printing. All other printers o.k. What is the problem?

    Christin25 pointsBadges:
  • Printing from AS400 A4/Portrait/132 car

    WHat do we have to do ( WSCT ) in order to be able to print in PORTRAIT a spoolfile that has 132 caracters on an A4 document

    William110 pointsBadges:
  • SQLRPGLE Error in UPDATE Query

    Hello, I have a SQL Statement in SQLRPGLE which Updates a 3 fiels in a file with 30 fields. SQL Statement is as below. UPDATE TABLE1 SET TXDATE = :SYSDATE, TXTIME = :SYSTIME, SETFLAG = :w_Set, MSG = :w_ERR, Comment = ' ' WHERE ID = :W_ID This works fine on one iSeries server and throws...

    sim400305 pointsBadges:
  • Get your free IT book: The Rails 3 Way

    Here's your chance to win "The Bible for Ruby on Rails Application Development"! There are two ways to get your copy of the book that "strips complexity from the development process," answer one of four questions and post the link to your answer in the discussion section below. Another way to enter...

    MelanieYarbrough6,345 pointsBadges:
  • AS/400 Display Files Not Retaining Last Window

    So I have used this “dummy record many times before. Now with a new program/dds it will not.. Could it be b/c my new program is defined DSPSIZ(27 132 *DS4) and the program calling the new programs display size is DSPSIZ(24 80 *DS3)…  i need the calling program 80 column screen to stay while I...

    RonKoontz1,780 pointsBadges:
  • Transfering (save/restore) job scheduler from one AS400 to another

    Other than a SAVSYS, which I believe saves the native job scheduler which can subsequently be restored, is there a way to simply save and then restore (on a different AS400) all the entries on the job scheduler on their own?

    Zack250 pointsBadges:
  • Subfile loading procedure

    Hi , I am new to as/00 .I have a doubt in the loading procedure between load all and page-wise?

    assa150 pointsBadges:
  • Check IF Field is Numeric in AS/400 SQL

    is there a function to check if field is numeric (like ISNUMERIC in standard SQL)?

    Jaggerdude60 pointsBadges:
  • Mask a password in as400

    how to mask a password with asteric which is retrieved from a physical file in rpgle(as400)

    Keo55 pointsBadges:
  • Variable number of parms in CL

    I know I have check in RPG for a variable number of inputted parms. Can I do that in CL also?

    CharlieBrowne39,780 pointsBadges:
  • DDS Keywords for AS400 Windows screens

    I have an Interactive Maintenance Screen program that calls a program to display an AS400 Windows. WhenI get to the first Screen and the call to the AS400 Window display is made, the background is blacked out and only the Window shows up. Is there any way that the background (first) Screen can be...

    Ppeier10 pointsBadges:
  • How to take the backup with reducing time

    Hi, i have taken the backup in 2 hours, but now user want reduce the backup timing. any one that can help me? we are using fiber in latest model tap divces and cartridge. thanks in advance

    kingstoniseries205 pointsBadges:
  • Access 2003 IIF Function?

    I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle's use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending mileage of the...

    Hld111025 pointsBadges:
  • Error with QSZPZVLI in library QUSRSYS

    I performed an upgrade last weekend from V5R3M0 to V6R1M0 on the system everything has seemed to be running great until last night.   We got an message the an Error occurred while processing object QSZPAVLI in library QUSRSYS and the the system performed an Unattended IPL stating the the System...

    Shadow4412265 pointsBadges:

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