• Duplicate entries on the printed report

    I have a written a query and do get results however when it populates the information it duplicates each entry X4.

    63bunnies10 pointsBadges:
  • RUNRMTCMD will not run SQLCMD

    Is there a workaround for running SQLCMD from the iSeries using RUNRMTCMD?

    beaz25 pointsBadges:
  • Looking for Old PTF’s

    I have V3R7 Box and am in desperate need of the last Cum PTF Cd's.. Anybody got some I could use or buy or whatever

    bartmanbch5 pointsBadges:
  • AS400 DB2 Server User Access Audit

    Is there any way to track "User Account" information on a DB2 server specifically when a users account is locked?

    bsatl10 pointsBadges:
  • Read the data from PF between dates

    I want to read the all the record from the pf which are between some dates Eg: A PF has one year data let say 2011 year data, I want to read all the records from that pf which are from 01/03/2011 to 05/06/2011 dates. the PF fields are DATE,NAME,ADDRESS,P_no. Can anyone help me how to do this in...

    vzvzxvcx160 pointsBadges:
  • QDBSRV04/05 reorg running for 31 hours and still going…

    During monthly maintenance we submitted a reorg of a file: -RGZPFM FILE(MM410LIB/INVAUD) ALWCANCEL(*YES) LOCK(*SHRUPD) The reorg was canceled after running 15 hours. Now the PF and first logical file are being reindexed under the QDBSRC04/05 jobs (there are a total of 8 logicals). When executing...

    Christieth20 pointsBadges:
  • how do I cause a field to be null, using DFU?

    how do I cause a field to be null, using DFU to update/insert a record?

    tegarvey35 pointsBadges:
  • Career change RPG/ILE to ASP.net

    After almost 30 years of RPG (from the old RPG I days) I am making the change to .Net. I felt that ASP.net would offer more of a challenge and reflect more of today's business needs. I am still working for the same company so no real risk in the move. My question is what do you think will be the...

    ToddN200012,815 pointsBadges:
  • AS400

    If i have a pf (pf1) R Rec account 10p00 name 10a dept 1a salary 5p00 k account After Updating, I given dept- A, S, D different account, different salary. NOW I AM TRYING TO ADD SALARY ON DEPT WISE {FOR EXAMPLE- IN SQL, SELECT SUM(SALARY) FROM PF1 WHERE DEPT='A'} BUT I AM TRYING IN RPGLE .. IT IS...

    anupsshelke420 pointsBadges:
  • CL PGM for full system save from the HMC

    System info: OS/6.1, 9117-MMB-770. Can you run a full system save from the HMC in a CL pgm? here is my code so far: PGM DCL VAR(&DATE) TYPE(*CHAR) LEN(6) DCL VAR(&TAPE) TYPE(*CHAR) VALUE(TAP02) CHGJOB RUNPTY(19) JOBQ(QSYS/QCTL) LOG(0 00 *SECLVL) + LOGCLPGM(*YES) BRKMSG(*NOTIFY) +...

    HMSSL2K3,175 pointsBadges:
  • poll a file on a remote FTP server and then transfer it

    I have a customer who will put a text file many times a day in a pc directory, I need to open an FTP connection to this PC server (no problem), I need to poll the directory every few seconds check to see if the file exists ( can't ask the customer to do more than put the file in a directory) and...

    KarenL20 pointsBadges:
  • Multiple display file in CL program

    I need to have one screen where a user can enter some information, lets say customer number then when they press enter that information will be shown in text on the second screen. So lets say the user enters 321 for customer number and then the second screen needs say "The customer number processed...

    mike178035 pointsBadges:
  • How to add Mulitple DNS Suffix

    I need to add more than one DNS suffix in (CFGTCP+12) Domain name filed...but it looks,i can only add one suffix...does anybody has any idea in overcoming this limit? Thanks

    qmaster1,675 pointsBadges:
  • BRMS Entire System Backup using 2 tapes.

    Message . . . . : Volume PB00XX cannot be used at this time. Cause . . . . . : The volume PB00XX was mounted for output but media management indicates that the volume contains active data ++++++++++++++++++++++++++++++++++++++++++++  I have tried Inintialize by using BRMS and native INZTAP before...

    Tape20 pointsBadges:
  • This issue happens after upgrading the OS/400 from V5R4 to V6R1

    I faced a problem and I need your help/advice This issue happens after upgrading the OS/400 from V5R4 to V6R1, this issue related to FTP files contains Arabic character from AS/400 to AIX server The order of record fields is reversed after sending the file from AS/400 to AIX below example: The...

    mohammadhirbawi15 pointsBadges:
  • AS/400

    Can we read a record in reverse order using READP otherwise what is the use of READP and READPE ?

    Sureyz2,460 pointsBadges:
  • Title changing

    Hi Group, As per the new assignment i need to change the title from "MQM Application Business" to "ABC". I have identified the list of Programs and files where I need to change. The list includes RPG, CLP, CBL, CBLLE, CLLE, RPGLE, PRTF, DSPF & DDS files. I have question: 1. What are the factors...

    mvrkrishna555 pointsBadges:
  • PQT3073 – Error detected while processing spooled file.

    We use IPDS printer on iseries which converts spool file into PDF send an email. But it is not working. By checking the job log we got the below error. Please advise me to resolve this issue. Message ID . . . . . . : PQT4143       Severity . . . . . . . :   40 Message type . . . . . :...

    IPDSprinter110 pointsBadges:
  • AS/400

    When and Where do we need to use a load all Subfile, load on equal Subfile?

    Sureyz2,460 pointsBadges:
  • Display a subform on clicked button – LOTUS NOTES 6.5

    I'm new in programming in Lotus and I have a 'problem'. I would appreciate if you would help me. : - ) So, I create a button on a form ( called Form3 ), the button name is Click. All I want to do is when I click the button a subform will appear. I created the subform and I called it Subform3. I...

    fcdinadn90 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