• AS/400 printing blank pages

    Why does AS/400 print a blank page with each print job to Canon printer?

    ghensarling5 pointsBadges:
  • Reading a file in Reverse Order in CL Program

    ) In CL program how can we read a data base file in reverse order.

    Chraghuveer25 pointsBadges:
  • Excessive JOBLOGS from subfile

    Since upgrading to 7.1 this past month we are experiencing a problem from one program from a subfile that is causing excessive job logs creating huge spool files. A message will appear in the subfile then its automatically answered with a 'C' and this happens several times in the spool file causing...

    UARTJ115 pointsBadges:
  • Convert hour in AS/400

    I have a query where the field 'Time' is on hhmmss and I need it only with hhmm. How can I do that?

    SusanaM60 pointsBadges:
  • Secure FTP for our V4R3 system

    Can we use secure FTP from our V4R3 system?

    Pamtobin35 pointsBadges:
  • Order Confirmation in AS/400

    How do I get an order confirmation in AS/400?

    gparthenios35 pointsBadges:
  • AS/400 Journal Name for a Source Table

    Is there a way to find the journal name for a source table? What journal is a given source table being journaled in?

    patelsa03275 pointsBadges:
  • Load data from two physical files in a subfile

    How to load data from 2 physical files in subfile which have two subfiles in single screen?

    vasanthisrini30 pointsBadges:
  • List of library objects into CLP

    I need to create a program. This program will must copy files for the back up. I mean, before RSTLIB (for restore 10-15 files from savf into library) command all same objects in library must be copied to the special library for back up objects. Please help me.

    Motorbreath65 pointsBadges:
  • File read with RRN

    I want to delete record from one logical file and delete from another logical file based on RRN. Both logical files are from same physical file. How to achieve this?

    prdevghare25 pointsBadges:
  • SQL join for two files with identical field names

    When joining 2 files that have identical field names, what does the syntax need in order to handle this? I know the old IBM Query uses a file prefix. On AS/400 platform (DB2)

    aceofdelts2,130 pointsBadges:
  • Auto increment in AS/400

    How do I have an auto increment column in a physical file?

    adriandjsanchez10 pointsBadges:
  • Authority to view a user profile

    I want to grant authority to our technical support personnel to see a user profile. How can I do this without giving them *ALLOBJ authority, or granting them object authority against each individual user profile?

    KDCKnowlton5 pointsBadges:
  • AS/400 Keyboard Shortcuts

    Can someone help me about the keyboard shortcuts in AS400? Previously, I was able to used some shortcuts like copy, paste and cut but now that I was transferred to other cubicle, keyboard shortcuts are not defined. Hope someone can help me. Thanks

    Radycal45 pointsBadges:
  • What’s the performance of CPYFRMQRYF and OPNQRYF?

    I would want to know the performance of this 2 commands OPNQRYF and CPYFRMQRYF. I will join 2 files and have some selection criteria. File A has 3000000 record and 1500000 number of deleted record in DSPFD. After that it execute CPYFRMQRYF command. So now the problem is this program take longer...

    yeepiyaya160 pointsBadges:
  • Convert IBM SCRIPT to AFP format

    How do you convert IBM SCRIPT to AFP format for printing purposes?

    AV228645 pointsBadges:
  • VBA code to transfer data from iSeries to Excel

    Hi everyone, could someone provide VBA code to automate the Transfer of data from the iSeries into an Excel 2003 Spreadsheet. Currently we have to manually use the iSeries Excel Add-In. All fields are left default except the Library/File field where we enter PRODDTA/F56EXT. The data then transfers...

    Mblair.au25 pointsBadges:
  • sFTP to AS/400

    Hi, We are currently FTP'ing a file to an AS/400 system and then use QUOTE command to invoke their program. We are now moving to sFTP and would like to know if there is an alternative for QUOTE command in sFTP to trigger their program. Many thanks!!

    psrini19865 pointsBadges:
  • Change program date in qsys

    What makes the change date change in lib qsys for programs?

    woodbine5 pointsBadges:
  • Setup SAVRST for secure connection between LPARs

    Is it possible to setup SAVRST to use a secure connection between LPAR's? I'm using V7R1.

    NotSoIBMguru15 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