• Haversine formula in RPG or SQL

    I need to put the haversine formula in an sql or rpg function on the as400 to calc the distance between to zip codes. I do not have much experience with sql. can anyone give me some help?

    Brenger170 pointsBadges:
  • Prevent Update in DB2 SQL External Trigger Program

    I have a 3rd party application that maintains a customer master file (update, insert, delete) and I cannot alter their programs. I would like to put a trigger on the database file to fire an external program on insert and determine if the insert should be performed. If not, I would like to send a...

    Djswtd25 pointsBadges:
  • Error: method or datamember not found

    i want to get data (liftno,model)etc in a subform by selecting a combo in main form .the subform data is from another table and in the main form cc field is from other table LiftNo.RecordSource = "SELECT Proj_d.LiftNo, Proj_d.Model, Proj_d.Capacity, Proj_d.Capacity, Proj_d.Speed, Proj_d.Stops FROM...

    1234a10 pointsBadges:
  • I5 private Authorities

    Ok after speaking with some of the IBM support people. I was told that we need to create user groups to minimize the Private Authorities issue we have. 1. How are groups created? 2. How will this help(how are authorities distributed among the users of said group)?

    Johnwhitew20 pointsBadges:
  • optical

    How to create docfoler in spyview?

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

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