• 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?

    vasanthisrini15 pointsBadges:
  • Order Confirmation in AS/400

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

    gparthenios35 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?

    prdevghare15 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,080 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:
  • 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:
  • 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...

    yeepiyaya125 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:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 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:
  • Netserver expert anyone?

    I'm trying to access windows folders on a server and I get this error: 'Error exchanging security information... Error Class:1, Code: 5 = Access denied. My passwords do match and I previously accesses these folders. The problem started when I changed my password.

    yaazhisai160 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:
  • AS/400: How to start a new session using menu option

    I have created a menu using STRSDA. I wanted to add a option to start a new session in IBM iSeries access. (Usually I open a new session by selecting file -> Run the same.) Is there any related command is available in AS/400 so that I minimize work in opening new session each and every time....

    RPOOJA15 pointsBadges:
  • AS/400 file downloaded to Windows Server

    When downloading AS/400 data files to MS SQL server files, will the storage size be about the same on server as it was on AS/400? We have a 102 gb AS/400 database library we want to download to SQL Server.

    jm101515 pointsBadges:
  • WhatsUp Gold to monitor iSeries

    Can Whatsup Gold Application monitor iSeries in a more detailed and deep down monitoring such as susbsystem, jobs, job count, logs, etc.? Thank you

    Jedlasquite360 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