• Record Lock after read

    We are facing a scenario where more than one person use the database. If a person read the record, I need to lock it exclusively for that user and other users are not allowed to access it. We can't grant whole file exclusively for one user as we need to allow more than one user access this file at...

    Babs312195 pointsBadges:
  • How to check disk and cache battery status in IBM AS/400?

    How do I check disk and cache battery status in IBM AS/400?

    Afzalas40035 pointsBadges:
  • AS/400 disk space command

    I need to know the command in the AS/400 that will show me the total disc space.

    Bunkin6920 pointsBadges:
  • Altering keyfields inside RPG Program

    Hi all, I have a  Physical file PF with 5 different logical files (LF). PF don't have any keys at all. In RPG program I need to perform a CHAIN on this file with 2 key-fields in which 1 of the key is defined as key field in some LF's. But the other is not. Now I was asked to perform CHAIN without...

    Sai4AS4001,420 pointsBadges:
  • Subfile control record overlaps subfile record

    Below is my code and i am not able to understand why this is giving me the overlap error . Please suggest !A DSPSIZ(24 80 *DS3) A R SFLREC SFL A 30 SFLNXTCHG A FLD002 1 B 6 4 A FLD003 4 O 6 9 A FLD005 10 O 6 20 A R SFLCTRL SFLCTL(SFLREC) ----- error CPD7812 A CF03(03 'EXIT') A CF12(12 'CANCEL') A...

    Abhi58395 pointsBadges:
  • AS/400 VB script to actual date

    Hi, I need to make a marco by VB code to put actual date in AS/400

    korupa20 pointsBadges:
  • What is the best way to execute SQL statements in a CL program.

    What is the best way to execute SQL statements in a CL program? We can run SQL statements in a RPG program. I want to delete some records from a file using the SQL delete statement then organize it.

    SHhand25 pointsBadges:
  • Convert spool file to physical file in AS/400

    How to convert result file to physical file?

    Ckishorekumarr25 pointsBadges:
  • Using AS/400 SQL to replace a variable string

    I need to do a scan and replace in a flat file. File has one field 80 characters long. Possibly one or more of the records in the file contain a specific value, such as '%ABC%' and I want to update the record replace ABC with XYZ. This value could be anywhere within the record. I do not want to...

    CharlieBrowne41,380 pointsBadges:
  • How to Test for Numerics in AS/400

    I need to test for Numeric. I have to check, If a variable contains Numeric values. I wanted to use TESTN opcode, but people are saying not to use it; as it does not work properly some times. Is there any other alternative to this? Has anybody done this before? Any help would be of great help....

    svankipu620 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • Sort file based on a key in another file

    Here is a scenario. I have a balance file which has account number and balance in it. I want to create a report out of it. The report should looks like this, it shows the Rank,(Rank 1 means account with highest Balance) Account number, and Balance order by Rank. There is another Account master file...

    RamvishakRamesh2,505 pointsBadges:
  • File is not moving in folder

    Hi, I want to move a file which has a invoice no and create a sub-folder in /hame folder using the invoice number as the folder name. for example: NAMEIN=/home/Indicium/20202021.pdf Nameout=/home/Intellichief/20202021/20202021.pdf PGM PARM(&NAMEIN &NAMEOUT) DCL VAR(&NAMEIN) TYPE(*CHAR)...

    97834441841,355 pointsBadges:
  • ‘convert as/400 dates ’0001-01-01′ to SQL Server 2000′

    How do I convert ISO dates of '0001-01-01' to SQL Server 2000 Datetime format?

    Jld10 pointsBadges:
  • ODBC connection to the SQL server from the iSeries

    Is there a way on the iSeries to establish an ODBC connection to the SQL server?

    a1maida150 pointsBadges:
  • AS/400 CL – PRTJOBRPT

    Hi, I'm trying to automate the PRTJOBRPT using CL. The printed report will be copy to PF and send email directly to audit team. I'm having problem with the member (*mgtcol). We all know that *mgtcol is created daily (auto-create), how can I get or retrieve the latest member of performance data? Is...

    iSeries40060 pointsBadges:
  • Help regarding RPG programs

    I want to do a project in RPG, here is my concept. I have a specific product which was containing some functionality and this product was used by some customers. I want to code a tool which will show the info like Full customer info (which functionality were used by customer). Functionality info...

    sivakesava280 pointsBadges:
  • Date validation RPGLE

    Hi, I try to validate the date field but the Indicator sets on for both valid and invalid. Please advice. D datevalid S 8A inz('20131225') D dateINVAlid S 8A inz('99999999') * /free test(DE) *ymd0 datevalid; if %error() ; dsply 'Error!' ; endif ; /end-free * C *YMD TEST(D) datevalid 44 C N44'valid'...

    as400dev480 pointsBadges:
  • Adding disk drive to AS/400 9406-520

    I'm looking for the requirements for adding 2 ,#4326, 35.1 GB disk units to my AS/400. I have the open slots and I need to know if I can user install these units. The unit is RAID 5 DASD.

    ken0611425 pointsBadges:
  • USRPRF disable often after enabling.

    What does this mean: USRPRF disable often after enabling.

    07091988ramya55 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