• Select subfile in AS/400

    How do I select a subfile in AS/400?

    Clynch77720 pointsBadges:
  • Fetching multiple rows in SQLRPGLE

    Hi, When I try to fetch more records, I couldn't do it. Please see my code below and explain. Thanks.

    as400dev590 pointsBadges:
  • Hide AS/400 Parameter

    How can we hide the parameter from user view and pass with some default value.

    22917560 pointsBadges:
  • Using CPYFRMIMPF to copy data from a TXT file to DB file

    I am using the CPYFRMIMPF to copy data from a TXT file into a DB file.  The delimiter is a ']' character.  The command runs but no records are copied.  The error says "0 records copied from member TXT.  Copy command ended because of error".   Upon further review I found "The copy did not...

    SteveLane75 pointsBadges:
  • How to copy tables between two libraries without repeat CPYF command using script?

    I need to copy tables from library to another on the same iSeries v7.1. Is there a script to copy multible tables without repeat CPYF command?

    HBlue5 pointsBadges:
  • SMTP new user

    Our automated email (via SNDDST) works great for existing users, but not for our new users. My hunch is we're missing a step in the setup. I did a lot of this 11 or so years ago and vaguely remember needing to add/update a value in order for a new user to use SNDDST. If this makes sense then please...

    aceofdelts2,400 pointsBadges:
  • App to view files with RTF extension

    Is there an app for my android I can download to view file a with a RTF extension?

    Rowanvlynn5 pointsBadges:
  • File size limit in System/36 environment?

    Is there a limit on number of records in a data file ... in the System/36 environment? Sadly, we still have some applications running that way (not my fault).

    aceofdelts2,400 pointsBadges:
  • AS/400 user ID which i do not want to be disconnected at all.

    I have a user id which i do not want to be disconnected at all. Is that possible since i have set a system value for QDSCJOB. All profiles need to be disconnected if not active for above 15 mins, therafter after another 30 mins the interactive job is ended. But i need this one profile which submits...

    JohnsonMumbai1,425 pointsBadges:
  • Recovering the entire System i – cannot log in

    I had to restore System i from EntireSystem copy. Unfortunately after restore I can't log in. After signing on qsecofr profile system goes back to sign-on screen.

    chypcik30 pointsBadges:
  • AS/400: Difference between WRKMLMBRM and WRKMEDBRM

    What is the difference between WRKMLMBRM and WRKMEDBRM commands in AS/400?

    kamalesh5 pointsBadges:
  • AS/400 FMTDTA command issue

    We used FMTDTA command to copy data from one PF to another PF. However, in the target file, one of the fields (length 8 packed decimal), got junk values like (+++++++++++). The file from which the data was copied had all correct values. Also we ensured that both the files (source and target files)...

    sanras12340 pointsBadges:
  • How to track down who made changes to a User Profile in AS/400

    How can I track down or view/search the audit log to see who made changes to a User Profile

    surfettekw20 pointsBadges:
  • Replace leading blanks with zeros in RPG

    I have a 3A field on my display file, when user enters ' 50' I want to chain the file with '050' since record in stored in file like that. How can I replace the leading blanks with zeros in this case?

    RamvishakRamesh2,505 pointsBadges:
  • iSeries file purge

    What is the best method to use in order to delete multiple old files at one time?

    pincknc5 pointsBadges:
  • IPDS printer prints 2 copies of barcode page

    We have a homegrown program that prints a barcoded (6 0f 9) page. I have ran tests and the spool file has only one page of data and is set to 1 copy. When we send the report to an IPDS printer (HP-4050) it prints two copies. Why should it do this? All other reports sent to this printer are normal....

    azohawk2,290 pointsBadges:
  • SFTP on AS/400

    sftp on the AS400. Gilbert Martin seems to be the master of this sftp thing. my email is ekaradsheh@edicom-ias.com if you can email me that article it would be great.

    Emadkaradsheh105 pointsBadges:
  • ASP Spiking

    What can I look for to see why my ASP is Spiking? I have checked wrkactjob, cleared old spool, files, JE's are fine.

    as400lu40 pointsBadges:
  • Install Cumulative PTFs on AS/400

    I am getting ready to install a Cumulative PTF package for V5R3M0 on the AS/400. I have 7 CDs that are labeled Cumulative PTFs and 4 that are labeled AS/400 Service Order. Will the 4 with the Service Order tag be used? Are there HIPER and Database PTFs that will need to be installed? What options...

    AtlantaStadium5 pointsBadges:
  • RPG SQL embedded

    Hi guys, I have this problem, look at this RPG code: dcl-s hostvar packed(8 : 0); dcl-s outvar zoned(8 : 0); ... EXEC SQL SELECT FIELDA INTO :HostVar FROM LIB1/FILE1 ; outvar = hostvar; EXEC SQL INSERT into LIB2/FILE2 (FIELDB) VALUES (HostVar); I get into Hostvar FIELDA that is packed(8 : 0)...

    Damiano25 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