• MIMIX Replication Oddities

    What could explain why random objects have different object sizes on replicated system using MIMIX? Creation date/time and source are all identical? Any explanations for this?

    LBorders15 pointsBadges:
  • Barcodes on a order

    Is there a way to print a barcode on a form. It seems you need PSF/400. I'm on V4.5

    bobcourier35 pointsBadges:
  • SQL in DB2 for AS/400

    What I have an error when I try to execute the following SQL statement: UPDATE kfilasm/SCPF exception JOIN KFILasm/LDPF ON SCAB = JUBBN and SCAN = JUBNO and SCAS = JUSFX set SCRBA = SCRBA - JUHAMT, SCRBB = SCRBB - JUHAMT WHERE SCAB||SCAN||SCAS IN (SELECT JUBBN||JUBNO||JUSFX FROM QTEMP/JUPF2)

    Messam260 pointsBadges:
  • Quick way to delete x number of records from a file

    I just found a history file that has over 57 million records and is taking up a good share of disk space. This is a file that contains 1 field per record of mixed data. There is nothing that resembles a time stamp of any form in the record. I would like to at least delete the first 50 million...

    azohawk1,915 pointsBadges:
  • Access data on AS/400

    Hi all, I am auditing an AS/400 DB and I want to know what are the commands which allow users to access directly the DB of the AS/400? (like CHGFC, SQL queries and more..)

    dantlv5 pointsBadges:
  • DST & Qsecofr password Reset

    hi, anyone help how to reset the Qsecofr usrprf id & Dst Id if Disabled. thanks kingston

    kingstoniseries205 pointsBadges:
  • DIRE – add name for SMTP

    Is there a way to automate changing the DIRE to add Name for SMTP?

    LauraKS25 pointsBadges:
  • Modify hexa string value in CL

    I have a hexa string and I want to modify some value while running program through CL below is the hexa string. X'011F011F000000000F099999999FC9020160309FF0D5 404040F9F9F9E3000000000F40404040404040') In the above string I have a date 20160309. Now I want to change this date to current date.

    97834441841,465 pointsBadges:
  • Move record into database file via data structure

    How do I move a record into a database file via data structure?

    suryathiru5 pointsBadges:
  • Name string alignment in AS/400 printer file

    I have a customer name field of 240 length. There are four fields defined with 60 length in AS/400 printer file. I wanted to print the name in the printer file with character alignment(like not leaving a single letter in the end of the field). Is there any procedure/steps you can suggest me to do...

    Sureyz2,720 pointsBadges:
  • RPG tools that allow me to find programs that call a given program

    What tools are available that will allow me to find programs that call a given program. Also need to know all programs that use a given field in a file.

    SteveLane75 pointsBadges:
  • Convert a UTC time to GMT or BST

    How do I convert a UTC time to a UK time (GMT or BST) on the AS/400 using RPGLE? The time may be in the past.

    thompsa5 pointsBadges:
  • How does the job user identity get set for a job

    In AS/400, how does the job user identity get set for a job?

    28390015 pointsBadges:
  • call CICS/TS applications

    FatenEzzat5 pointsBadges:
  • RPGLE: Find the total cost for particular location

    Actually, now I'm doing a program in RPGLE and I have a file with 3 key fields so it is a list but the first key field is date, second one is company name that is 'CON' and third one is location. So their is a cost field also so I want the total for those same locations but data is ordered by date....

    Meghaa5 pointsBadges:
  • Stop Pur Req from entering PTF

    Hi, I am using MRP type where we have a PTF and PDT to procure material. The pur req enters the PTF and gets firmed. Is there any setting in MRP type/group/profile that I can set so that the Pur req does not enter the PTF and only enters inside when it is a Purchase Order?

    Omeigar5 pointsBadges:
  • Looking for AS/400 security journal entries related to certain commands

    Hi guys! I'm looking for journal entry type (JOENTT in type 5 journal entries) codes that are generated by the STRSBS, ENDSBS, all journal receivers commands such as CRTJRNRCV & DLTJRNRCV. The best for me would be to find a reference either on the Internet or in an IBM reference book to...

    dgaucher10 pointsBadges:
  • Why is CL the native language of AS/400?

    Why is CL (Control Language) the calling native language of AS/400? And why it is a driver program?

    Angelg5 pointsBadges:
  • How can I know how many job logs are generated in one day?

    Now our system only save one day job log. But it is different to check the job error after one day. So we want to change to seven days job log. But we afraid the DSPJOBTBL would touch the max. How can we know how many job log generated on one day? And how we can analysis the possible DSPJOBTBL...

    TOMJia105 pointsBadges:
  • New line in message formatting in CL program

    I want to insert a new line in message formatting in CL program. Like Name new line and details new line and rem details. How can insert a new line in message formatting?

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

Thanks! We'll email you when relevant content is added and updated.

Following