• Create a logical file from a “simple” physical file

    I have the following physical file: File Name . . . . . TCHE4067 Record Name . . TCHE4067  Field Name. . . . .TCHE4067 How you can see this PF has only 1 field named the same as PF and also the same as the Record. I do not know how it was created, but I have to create a logical file from this...

    eroek18220 pointsBadges:
  • Compare file in RPG AS/400

    How to check if the file a contents are inside file b? File contains table q,w,e,r,t,y.file b contains q and w. I want to check whether q and w contents are same in file a and file b. If not, I want to display an error message.("FILE B IS NOT UPDATED")

    sampathrsk20 pointsBadges:
  • How to check that how a file is being used in different programs in AS/400

    Hi, Could someone help me with the below query. Is there any command or way to check that how a file is being used in different programs? Like DSPPGMREF will show that what are the files used in a given program. In the same way do we have any command or process to check what are the different...

    SatishKumar00735 pointsBadges:
  • Vary off command means in AS/400

    Hi, What does vary off on any device mean in AS/400 perspective? Also what does vary on mean on any tape type device? Thanks!

    6r2,475 pointsBadges:
  • Journaled logicals not showing on WRKJRNA listing

    I created a schema on my iSeries. I then moved objects into it, and then started journaling on the physical files. I had created data area QDFTJRN so that any future object moves will get journaled. When I did an output print with command WRKJRNA for files that are journaled my logical files did...

    Rrbond07750 pointsBadges:
  • Enterprise Extender on iSeries

    Has anyone configured Enterprise Extender among multiple iSeries Systems? We need to get of of AnyNet and onto EE before we upgrade to V7R3.  I found documentation on the internet for EE between two systems, but I have six systems I will have to set up EE for.  Thanks for any help you can offer.

    Rrbond07750 pointsBadges:
  • Starting journaling on files in a schema

    I created my schema and moved objects into it. I noticed that files are not automatically getting journaled like they would have if I used the CRTDUPOBJ command. What do I need to do to have files automatically journaled to the QSRJRN journal when objects are moved into the schema? When I created...

    Rrbond07750 pointsBadges:
  • In a display file window is 35 char wide and I want to put field 110 that wraps 4 lines

    I want a pop up window to allow user to type a 110 char field. The window is 35 char wide so I want it to cover 4 lines. Is there a way without having 4 display fields and having to concatenate in the RPG?

    rickgdcbloch5 pointsBadges:
  • LCD command not working in FTP

    Hi, When trying to FTP AS/400 source members to local desktop LCD subcommand of FTP is not working. when using the command LCD C:\ ERROR IS COMING CHARACTER ':' IS NOT ALLOWED in object name so because of this unable to copy as/400 source code to local desktop.

    6r2,475 pointsBadges:
  • CPYFRMIMPF Special Characters

    When I look at this .txt file in Notepad I can see special characters that are superscripted like the TM Trademark letters. When I look at this on the AS/400 IFS, the rows with the special characters are misaligned. When I use CPYFRMIPF to copy these Fixed Format files to a database file, the...

    jimjung20 pointsBadges:
  • CF keyword in iSeries

    After using the CA keyword, how can I use the CF keyword?

    Nitish2001Kapoor5 pointsBadges:
  • While trying to FTP AS/400, 530 Log on attempt by user XXXXXXX rejected

    530 Log on attempt by user while trying to FTP AS/400, 530 Log on attempt by user XXXXXXX rejected. message received.

    Anshan150 pointsBadges:
  • OVRDBF, RRN and record deletion

    I have a CL program where I'm overriding file to qtemp based on *CALLLEVEL. In RPGLE program, I build the qtemp file with some records. After completion of RPGLE, I perform DLTOVR in CL. Now, in RPGLE program, I'm performing an activity of building the file again and again. (I perform something...

    sri8707360 pointsBadges:
  • FTP Get Issue

    Hi, I have a Model 9406-170 with OS: V4R4M0 I can login to this system via FTP and navigate to the AS/400 library (MFG.PMS) that I want to download files from. I have verified through green screen that the files PMCR06.PGM and PMCR06CL.PGM exist in this library. My FTP "pwd" command output: 257...

    smithmt052110 pointsBadges:
  • AS/400: Copy objects into a Schema (Collections)

    We are modernizing our libraries into Schemas. Once my schema is created I copy all objects except of course journals and journal receivers into the schema. Is there a command other than CPYDUPOBJ that will also copy the object's owner along with it like it does for the authorities? Otherwise I...

    Rrbond07750 pointsBadges:
  • Over Lapping Letters when printing reports from AS/400 on Windows 7 Machines

    Whenever I print a Purchase order report from AS/400 to any printer it prints the letters out on top of each other. When I switch to an XP machine and print with the same user, and same printers it prints normally. I have done the printer set up and mimicked the settings on the XP machine. I did...

    HToKC201855 pointsBadges:
  • SETLL/READE/CHAIN

    ID NAME VALUE1 VALUE2 VALUE3 MARKS 1 A 9 1 1 85 1 B 9 1 1 75 1 C 9 3 1 60 1 C 9 3 2 30 1 C 9 5 1 70 I have a file that contains fields as shown above. First 5 fields are the keyfields for the file. Now, i have a scenario where i need to fetch records pertaining to ID = 1, Type = C, Value1 = 9...

    sri8707360 pointsBadges:
  • Looping using READ vs Embedded SQL

    Which approach is better? What all the parameters, we need to consider to come to a proper conclusion? Which approach is better in which scenario? Can anyone explain in detail?

    xselvam20 pointsBadges:
  • How to select records greater than particular date?

    Hi, When trying to select all objects whose change date is greater than 1st April 2018 than below query is not showing correct result:- select * from l1/f1 where odldat>='040118' it's picking up records older than 1st April 2018 as well here change date is of 6 length and data type is char and...

    6r2,475 pointsBadges:
  • Compile a RPG36 source member

    I'm looking for ideas on what else to try. We stopped changing the programs still running in the System 36 environment. We're finally eliminating that, but a few program mods would be useful during conversion. Of course, the method I remember for compiling fails now. The old method was to do OVRDBF...

    aceofdelts2,550 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.

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

Following