• Embedded SQL in RPG ILE

    I want to write a program that will retrieve any field(s)from any file on the iSeries. The only part I haven't figured out is how to code the fetch statement to populate variables that aren't known until execution time

    Jeffm125 pointsBadges:
  • FORMAT keyword in non-join logical files — what and how?

    How do I use FORMAT keyword in a non-join logical file? What is the main purpose of that keyword?

    AS400 - Ask the Expert485 pointsBadges:
  • SQL proceedure to join header and detail file

    I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = 'X' then updates this header record after selecting the detail records.

    AS400 - Ask the Expert485 pointsBadges:
  • Barcoding in RPG/400 DDS

    How can I code an EAN13 barcode in RPG 400 DDS

    Roddyredbelt25 pointsBadges:
  • Spool to Flat

    Can anyone please guide me on the following: 1) How can I convert Spool to Flat and vice cersa ? 2) If I already have a Flat file. Can I convert it back into spool ? using what utility ? 3) What are the archivers that convert Flat to Spool and vice versa ?

    SyedJR10 pointsBadges:
  • Can anybody give me an example for OPNQRYF and call program?

    Can anybody give me an example for OPNQRYF and call program with detail? ( i.e. how a call program is retrieving the data to the OPNQRYF program) Moderator note: This is a reader submitted question to our inbox.

    BrentSheets6,925 pointsBadges:
  • Modules in RPGLE

    Hi, Can anyone tell me what is module in RPGLE and how is it created? alos tell me how this can be called from rpgle?

    Mathi5 pointsBadges:
  • Journal receiver file

    Please can I delete or change content journal recever file ? Can I find reference or decument from IBM about that ?

    Anwaras30 pointsBadges:
  • Print a company logo using rpg

    How do you print a company logo using rpg on a laser printer?

    Alpfalpf25 pointsBadges:
  • Copy data from flat file to a flat file

    My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto 3mb. Can...

    Supriyob2165 pointsBadges:
  • New member creation through CL

    I need to create members dynamicaly once my file size is full through Cl.How can i do this?How can i set range to this new members?

    Supriyob2165 pointsBadges:
  • Menubar and pulldown menus

    I'm trying to get a menubar with pulldown menus to work in RPG. Coding the DDS was fairly easy just from reading the Application Display Programming book. Unfortunately, it doesn't give the supporting RPG code to make it work. Anyone know of a code example I can view that works?

    Floyd02320 pointsBadges:
  • Script to change As400 System Name

    I would like to write a script that a user could run that would change the system name or IP in Client Access? We are changing As400's and have over a 1,000 users that will need to change this setting manually! Does anyone know the file name in Client Access?

    Bwright0810 pointsBadges:
  • ODS400 & OMS400

    We have two 570 systems, which have a dedicated 1 Gb Ethernet link between the machines for replicating "Realtime" data as part of their HA solution. The replication software has a lag threshold setting currently set to 20 mins and warns when this is reached. Initially there was 1 queue setup to...

    Mandrax1005 pointsBadges:
  • Display File Reverse Image and Error Message Attribute

    I defined Reverse Image Attribute and ERROR MESSAGE Attribute to 2 diff display file fields with 2 diff indicator. When Reverse Image Indicator set "ON", the field will be highlighted. When i set "OFF" the reverse image indicator and set "ON" the ERROR MESSAGE indicator, both fields are...

    SIXHOLE5 pointsBadges:
  • Using Access Codes with iSeries

    We are using Access Codes to keep track of our color printing, but when we have that feature activated we cannot print from the AS400. Has anyone been able to print to AS400 and keep the Access Code feature activated?

    Rhurley465 pointsBadges:
  • AS/400 Daylight Savings Setting

    Where can i find out the setting on the as/400, on when it auto change for Daylight Savings? I am new to the as/400.

    Think15 pointsBadges:
  • Faxed reports get added blank lines

    When I look at a report in the QFFSND outq it looks fine and is two pages. When I get the faxed report it has added blank spaces and makes the report 4 pages long. Is there a way to find out why the extra spaces are being added?.

    Jakedorst5 pointsBadges:
  • Client Access Upgrade v5r3 – v5r4 XLS and Printer file issues

    We are upgrading OS to V5R4 from V5R3. We are leaving Client Access (iseries access) at present level of V5R3. Can anyone clarify expectations or issues that may be encountered. Was told XLS a little different; and may some print file issues.

    Gambitt7150 pointsBadges:
  • PC5250 License Error return code 9052 2751

    We added NetMotion to our network and have it acting as a type of "fire wall". Laptops running iSeries Access for Windows (v5r3) are getting this error periodically - around every 30 days. Much older versions of CAE do not present this error. We have found that by taking the user out of their...

    DPerry35 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