• Help with a simple script

    Firstly I should mention that my profession is controlling, not IT, but I assume my problem is rather simple. Unfortunately, I have not even basic knowledge how to solve my problem on an AS/400. I copy data from the AS/400 to the AS/400 notepad. Sometime I have longer lists, so I copy to the...

    PetziMG15 pointsBadges:
  • Transferring data from iSeries V5R4 to Windows 7 PC

    We are getting an error message (sys3827) when we try to transfer data from an RPG2 program on an iSeries 800 running V5R4 to a Windows 7 (64bit) PC running iSeries Access V6R1 (data to be used by Filemaker Pro 11). Any suggestions?

    jeffg25 pointsBadges:
  • IFS object in use

    We have a job which run on a specific time. However this job is failing because of one of the objects in IFS in use. Below is the message --------------------------- Message . . . . : Object in use. Object is /ACBC/XYZC_BCACAC/ABCDWC_20130502031504.txt. Cause . . . . . : An operation attempted to...

    Secskc25 pointsBadges:
  • ASP Utilization

    I am new to AS/400.  Can anyone suggest the command or STEPS to know which file or library is utilizing maximum space.

    Sagarika30 pointsBadges:
  • Sequel IF and Else statements

    I’m a newbie to Sequel and I’m trying to recreate some old Crystal Reports using Sequel. My question is: how does the IF, Else statement work in Sequel? This is the statement for Crystal, for a Termination report, we have six companies and if an employee transfers to one of our other companies,...

    Gamblersgobroke75 pointsBadges:
  • Deleting SAVED journal receivers

    I want to delete journal receivers in a library that have the the status of SAVED. Can anyone offer some CL code to do this in a program? Each receiver begins with AMQA and followed by 6 numerics. I guess I would write out to an outfile then read the outfile to delete the receivers.

    northwoods180 pointsBadges:
  • Trailing the blanks which come in the middle of a string

    Could anyone please let me know how I can trail the blanks that come in the middle of a string? For example, a field contains a name like 'hello hai' I want to trim the blank which came in the middle of hello and hai. Please help me with a piece of sample code.

    JSDHFKJHA335 pointsBadges:
  • Excel to AS/400 VBA – SETTEXT not working

    Hello, I am using Excel VBA to try to process a simply gettext/settext function. I am able to return a value using gettext, but nothing happens using settext...no error..nothing. I've pasted the code below. Any help is appreciated. Sub AS400_Test2() [PCOMM SCRIPT HEADER] Language = VBSCRIPT [PCOMM...

    Carissa85 pointsBadges:
  • Spool print in Times New Roman

    How do you print the spool file in Times New Roman. Report is not PRTF. (Coded internal). I am modifing this program and been asked if we can do it. On the OVRPRTF, the Font Identifier is asking for a Character Value for the Times New Roman. Does anyone know what this Character Value is? The Point...

    Programmerlmi5 pointsBadges:
  • How do I copy a data base file to IFS directory

    How do I copy a data base file to IFS directory

    ITR35 pointsBadges:
  • iSeries logs

    iSeries AS/400 is integrated to RSA envision successfully but unable to get logs from iSeries to RSA envision. Please help. Thanks, Niketan

    niketanjadhav5 pointsBadges:
  • Object is currently in use

    We have a RBO job which failed and when checking in the log, we could see the object currently in use. What can I do?

    ravula700 pointsBadges:
  • Unable to obtain lock on device

    I have messages " unable to obtain lock on device xxx" lots of times for each device I am using VRYCFG to obtain lock on device but I don't know what is the reason of these messages.

    abar1430 pointsBadges:
  • AS/400 Trace Report

    Hi, I ran the command TRCCNN in AS/400 to trace the connection between our AS400 and Tandem. I was able to generate a report but I don't know how to read if there's a lost connection or unnecessary event with the network. Can you help me what are the key or code when searching at the tracing report...

    iSeries40060 pointsBadges:
  • AS/400 (8203-E4A): no display

    AS/400 (8203-E4a) cannot display console. We were forced to IPL.  The AS/400 stops on code B150B10C.

    datecsamoa25 pointsBadges:
  • iSeries WorkStation v5.9 on Surface Pro

    I'm not an IT guy, just a frustrated Outside Sales Rep. I recently BYOD a Surface Pro for work. A HUGE improvement over the 15" 6# monster I had before. The company that handles our AS/400 iSeries Access had issues installing it on my Surface Pro. They rolled back the graphics driver to Intel...

    gwydionjhr30 pointsBadges:
  • Defaults the Physical file with ‘%’ for Character fields and -9999 for Numeric fields.

    Hi all, I have requirements in which I have to pass the file as parameter to another program with defaulting the field value as, If character field default the first character as '%' and if Numeric default till the length of the field with -9999. As per now I'm getting two options. 1. Create the...

    ddaswani170 pointsBadges:
  • CPF5011 COBOL subfile error

    I have not written a subfile program in a while, but am having trouble when errors are encountered. As this is COBOL and the code can be lengthy to weed through on a forum, let me first spell out the scenario. I have 32 records in a COBOL subfile, 11 per page. There is one input field per subfile...

    LetItBe260 pointsBadges:
  • Two OPNQRYF on same file

    I have a file which has account opened date and account changed date. In my RPG program, I need to extract all those accounts opened today. and do some calculations. Then I need to extract all those accounts that are changed today and status is not 'Cancelled' My file doesn't have either opened...

    RamvishakRamesh2,505 pointsBadges:
  • Search for a data in the file in all the library

    I have a file which has an ID field and description. The same file is present in many library. I am trying to create an utility which will ask for the ID and it should display all the library which has the file with that ID in it. How can I achieve this? How to search in that file in all the...

    RamvishakRamesh2,505 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