• RPG Program Files in Update Mode

    One RPG program P1 opens a file FILE1 in update mode and trailing program P2 opens the same file FILE1 again in update mode. Now P1 updates a particular record (say using CHAIN). Now P2 also want to update the same record (Say using CHAIN). will P2 recieve a new data or old data from File FILE1?

    Sangay635 pointsBadges:
  • Print MICR code on iSeries AS/400

    I have the micr code fonts resident on my AS400 V5R4 but I can't figure out how to print micr code fonts for bank checks using XOAE13. How do you call the font from a Printer file DDS and is there anything unusual about the RPG program used to print checks? I can't find any examples of either. Can...

    Chestnuttr10 pointsBadges:
  • Problem Running SQLRPGLE program in Batch: Works Fine Interactively

    Hello all, We currently have a program that runs in batch. Last night, we had the following error occur: RNQ0103: The target for a numeric operation is too small to hold the result. The program works perfectly when run interactively. When the program was originially written, I compensated for the...

    Dcantwell470 pointsBadges:
  • Updating an IFS member in iSeries with RPGLE

    Can an IFS member be updated thru an RPGLE program in the iseries?

    aderene180 pointsBadges:
  • What happened in the IBM RPG market?

    I was active in this market for 10 years, and attained a high degree of competency - cranking out business systems on behalf of mainly blue chip clients. But it all came to a stop in 2002. Was this a political matter, an outsourcing matter? Or a technology change matter (I am now open source...

    Jorjun110 pointsBadges:
  • Data sent to device DSP01 not valid. Negative response code is 10050122.

    Hello. My display file crashes as it can not display the hexadecimal values in my character field. Is there an easy way to replace these values (like scan) in my 79 character long field that has valid characters mixed with hexadecimal values? (Please no APIs) Thank you in advance. Regards Steven

    Cabero15 pointsBadges:
  • iSeries SQL function in a SQL procedure – error: Function Name “in *LIBL type *N not found.”

    A while back, Seeker1 posted this question.  Unfortuantely, he didn't provide enough information for Tom to help.  Well - I have the same problem so hopefully, this will be enough. This Select statement generates the error: SELECT UNUNIT, ITRVEHLOC(UNUNIT  , 'CITY ')  FROM Units Here are the...

    Craig Hatmaker1,760 pointsBadges:
  • I/O time

    What is faster a read write or a read update?

    ScubaDan25 pointsBadges:
  • Modify MS Access using iSeries RPGLE

    I have to intergrate a third party product that uses an MS Access database with my AS/400 machine and be able to both update the Access data as well as read data from the Access database to use on the 400. Does anyone know how I can do this?

    wkozerski20 pointsBadges:
  • lexmark printer on iSeries

    What are the specific settings to connect a Lexmark model 658 to an iSeries system using ip and crtdevprt.

    Mballai15 pointsBadges:
  • CPF5149 on Delete using SHARE(*YES)

    I am receiving a CPF5149 error when trying to perform a delete of a record in a file that is defined as update/add in the F spec. Unfortuneately, the software package my company uses requires SHARE(*YES) on all database files. I am fairly sure that the problem is caused by the file being opened at...

    Joy Stalnecker170 pointsBadges:
  • Does anyone know if Version 4.05 of BPCS is compatible with V5R3 of i5/OS?

    We upgraded out production machine to V5R3 of i5/OS and we are seeing an issue with BPCS programs not compiling that use to before. This includes errors with /COPY statements that were found but now showing the following errors * QRG2001 Severity: 30 Number: 11 Message . . . . : Form-Type entry...

    Lovemyi2,310 pointsBadges:
  • Convert character field in decimal field.

    hi, everybody i need a help for this: waval = 15A wnval = 15 2 i put in my source this eval wnval = %dec(waval:15:2) but when i run the program stop with error in this line. what i need to do, because i want this example: waval = 123456789012345 wnval = 123456789012345.00 but if i put this: waval =...

    BUG68235 pointsBadges:
  • Quarter calculation

    I have a fiscal calendar that runs from March to February. I need to be able to calculate the quarter number and determine the months that compose that quarter. Doing all of this with out prompting the user.

    AS400PCFileTransfer16115 pointsBadges:
  • random number

    Can anyone pos thet code in RPG 4 or logic to generate random number....?

    Harshaljg10 pointsBadges:
  • converting numeric field to a character field and show leading zeros

    I am using %char to convert a numeric 9 pos field to character for use in a larger out put field. My code looks basically like eval labelout - "4J'+lpart+%char(lexpire)+%char(lserl) Where lexpire and lserl are used in the labelout field, I need the leading zeros to show. Right now, they are being...

    Merts30 pointsBadges:
  • How to use embedded SQL in a RPG program used as a stored procedure

    When I use embedded SQL in a RPG program and call it from another program it works fine. But, when I try to use the program as a stored procedure it gives me a SQL error. I have worked with stored procedures and understand them, but have not been successful using embedded SQL with them. Any ideas...

    Warykat20 pointsBadges:
  • AS400 Cobol screen write hanging up

    I am an RPG programmer, but have a client with a cobol issue. When the program does a write to a screen it never returns to the read statement. No error is issued and we have to cancel the job. Any ideas or suggestions?

    400Man5 pointsBadges:
  • Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

    I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as...

    Warykat20 pointsBadges:
  • Data QUEUE – Remote location ….. for program device DDMDEVICE was not found

    When trying to use a remote DATA QUEUE the send and receive data queue commands failed giving : Service with protocol tcp not found. Cannot establish DDM connection with remote system. Operation on DDM data queue DTAQFIFO in TESTLIB failed. Remote location MYAS400 for program device DDMDEVICE was...

    SBCHenry30 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