• AS/400, RPG, ILE, DB2/400

    Hi Group, Please let me know.... How to analyze the DUMP of RPG in AS/400? What are the steps involved? Thanks & Regards, M

    mvrkrishna525 pointsBadges:
  • How to use column values in a array

    Hi, I have a file has some column as abc1,abc2,abc3,abc4.....abc40 Now I want to use this column values in a 2 length array with 40 element. Is it possible to achieve this? Thanks

    97834441841,355 pointsBadges:
  • Email IFS File

    Does anyone have code to email an IFS file. The SNDDST only works with files in qdls

    mblackit5 pointsBadges:
  • IS WRKSYSVAL SYSVAL (QMAXSIGN) COMMAND USER SPECIFIC OR GLOBAL

    Actually I need one commen user id to have mutiple attempts for sign on I had tried with below command but it updates globally and not for one user IS WRKSYSVAL SYSVAL (QMAXSIGN) COMMAND USER SPECIFIC OR GLOBAL pls help

    Manojcgupta25 pointsBadges:
  • Pre run time array

    In my PF, one record is there with 40 fields and each field length is 2. Now I declared one array like this: D ARR      S  2  DIM(40) Now I want to move all the 40 fields data into array in a single statement. Can anyone help with this?

    421380 pointsBadges:
  • AS/400 opcode

    Hi, How to retrieve a specific string in a flat file (copied from spooled file) aside from using %SUBSTRING (%SST) function?

    iSeries40060 pointsBadges:
  • Run time array

    fzscl01    if   e           k disk d gvk             s              2    DIM(40) d wsname1         S             10 D SDS            SDS D  USER                 254    263 /FREE wsname1= USER; DSPLY...

    421380 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:
  • How to detect duplicate IP addresses

    How is it possible to detect/locate/discover a duplicate IP address in a network? If this network has a router, does this method of discovery still work?

    NetworkingATE1,545 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...

    CharlieBrowne39,815 pointsBadges:
  • Getting I/O error CPF5004

    Hi, I am trying to write 10000 records from pf to printer file but after writing 200 or 300 records into the printer file, I'm getting the I/O error CPF5004. I know I'm getting this error because the page overflow indicator is not set it. But I'm doing programming in RPGLE. I don't know how to...

    Mohan K695 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....

    svankipu560 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,410 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