• Is it possible on iSeries that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used.

    Is it possible on i series that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used. We had an issue wherein an entire library had to be cleared and all files from had to be restored from a previous backup, after the backup was...

    JohnsonMumbai1,160 pointsBadges:
  • Quick iSeries Access Codes

    I try to use several Quick Access codes, but I can only get DCKH to work. Why won't UZZ or DEED work for me?  DEED brings me to emergency data not update employee data, which is what my code list says to use.  I use ISeries Access for windows, version 5.8. 

    Freeny5 pointsBadges:
  • Can data be restored from BRMS whose expire date has passed.

    Can data be restored from a media whose expiry date has passed though it has not been initialized or formatted. Data was stored using BRMS.

    JohnsonMumbai1,160 pointsBadges:
  • Automate iSeries Backup Checking using CLP

    Hi there, I have created a CLP (I'm not really good at CL) that will run on request via scheduler after a backup has completed. It will check through the Hist Log looking for specific failure msgs. If it finds them it should email oncall support. Not sure if there is a better way to do it but I...

    Stefche20 pointsBadges:
  • How do I know if an iSeries 9406-825 has the proper service processor?

    How can I possibly know if an iSeries model 825 has proper service processor to support HMC?

    Brunocl230 pointsBadges:
  • How to remove the double quotes in CSV file in iSeries

    Hi The command is to remove the double quotes present in CSV file. I have used one shell command. Strqsh cmd(Sed -e 's/""//g' file name > new file name) I have to write this command in CLLE program. CHGVAR     VAR(&RPLC) VALUE('Sed' *BCAT '-e' *BCAT +                 ...

    iiiiiiiiiiiii335 pointsBadges:
  • QINTER will not go down due to keyboard error

    We shut down QINTER at 3:30 AM to do a quick backup. We have 5.4. When someone leaves a terminal or PC session on with a keyboard error (last night was an "invalid F key pressed") QINTER will not go down all the way! It sits there until the session is physically terminated at the device. Anyone...

    LarryKat10 pointsBadges:
  • Copy Spooled File to a Source Physical File Member

    How do I copy a spooled file listing into a member of a source physical file? I accidentally deleted the source member, but have a spooled copy taken via option 6.  I would like to convert the spooled file back into the deleted member.

    Paul10204215 pointsBadges:
  • BRMS Encrypted Restore

    Has anyone performed a single library restore from a BRMS encrypted tape on one server to another?  Here's my dilemna...I can encrypt fine and restore partition to partition on the same iSeries server.  However when I try to restore from a partition on another iSeries server I'm unable to...

    dmkuster20 pointsBadges:
  • Updating an IFS member in iSeries with RPGLE

    Can an IFS member be updated thru an RPGLE program in the iseries?

    aderene180 pointsBadges:
  • RPG Free Array Processing

    I am loading a DS from a database file into an array nine length with three elements, i.e. 100101102. I want to increment the array to load each element one at a time and save it to a standalone variable ( 3 bytes long). In another forum, someone said the receiver must be a %subarr variable. In any...

    ShawnKF5 pointsBadges:
  • Retrieve the iSeries user ID using only password

    Is there any way to retrieve the user ID from their i5OS user profile using inly their password

    Rsh25 pointsBadges:
  • RPG Free Array Processing Problem

    If you've seen this question before it's because when I add my code and submit and view it, it is unreadable. I'm trying to get a "clean" representation of my question. Thanks for your patience. I have loaded a data structure from a database file with three 3 byte fields, i.e. 100101102. It loads...

    SKF75 pointsBadges:
  • How to prevent parameter 2 from getting into parm 1 in iSeries

    I have a command that calls a RPGLE program. One of the parms has a max of 6 but if using less than the 6, I get info from the next parm in that field. How do I prevent that? Here are the 2 parms as defined in the Command: PARM       KWD(EXCLUDE) TYPE(*CHAR) LEN(1) RSTD(*YES) + 

    VGP300 pointsBadges:
  • Where is the error log of an AS/400 trigger?

    when a trigger added to a file on the iseries generate execution errors the log of the program where it is ?  if the trigger program has an internal list where I look? Gracias por su ayuda

    CRAMIREZ25 pointsBadges:
  • lsdisk( command for a local wrklnk folder on the iSeries

    I need to save a directory listing of a local wrklnk directory on our iSeries to a file, much the same way LSDISK( saves the names of files that live in a remote directory to a file. How is this done? Thanks in advance.

    TJA10 pointsBadges:
  • Example of Cobol call to an SQL stored procedure

    I am new to the iSeries and need to know how to use a Cobol program to call an SQL stored procedure. Someone has already created the stored procedure for me, but I am not sure how to call stored procedures in Cobol on the iSeries. The passed data looks like: FIND_CLIENT ( IN LastName CHAR(35), IN...

    Dfe07225 pointsBadges:
  • EBCDIC Database File Problem

    My company received a file supposedly in EBCDIC format. We copied it to the shared network drive and attempted to FTP it several different times using several different types. The file transferred but when displaying it the records were all variable length and appears to have CR or EOL special...

    SKF75 pointsBadges:
  • RPG /Free Local Data Area definitions

    I am trying to define the LDA with an external definition in RPG /free. Any help?

    Rstinsonindy15 pointsBadges:
  • Need help with setvar for iSeries query manager using not in ()

    I have an issue with a Query Manager where I need help with the syntax for a list of entries in the Select not in ( ) portion. I have a command that will call an RPGLE module which will call the Query Manager. I know that the quotes have to be supplied by the calling program (found a lot of info in...

    VGP300 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