• AS/400 – DB2/400 PF and LF have different identifiers for Synon

    Hi, AS/400 -DB2/400--> PF and LF have different identifiers for files generated in Synon. But for the Manually created files PF and LF have same file level identifiers. Please let me know why it goes like this. Any idea? Looking answer for this. Thanks P.Amutha

    As400pgmmer305 pointsBadges:
  • PDF send through the mail, cannot be open

    I have created a PDF file in IFS folder from PF, using the command CPYTOIMPF FROMFILE(QTEMP/PRT01) TOSTMF(&STMF) + MBROPT(*REPLACE) STMFCODPAG(*PCASCII) + RCDDLM(*CRLF) STRDLM(*NONE) FLDDLM(' ') ******************** SNDDST TYPE(*DOC) TOINTNET((&EMAIL)) DSTD(&DSTD) + MSG(*NONE)...

    manias4005 pointsBadges:
  • How to manage SQL queries on iSeries

    We have users who are using SQL to perform queries on our iSeries. As such, we need a way to manage these queries so that, if a runaway, poorly written, etc. causes issues for CPU and/or DASD we can either be notified, end the job, or some other parameter. Is there such an animal? Thanks!

    StarTaylor15 pointsBadges:
  • 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

    mvrkrishna555 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...

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

    svankipu560 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