• Using SQL Connect Statement in SQLRPGLE

    I need to use the SQL CONNECT statement within a SQLRPGLE program to connect from one AS400 system to another. I need to get data from one file to another. Does anyone know how to do this? Can it be done within a program. I have no trouble when I do it on an SQL command line... I use CONNECT to...

    JCCPT5 pointsBadges:
  • converting ILE legacy code to a GUI based system

    We are trying to move out of the old "GREEN SCREEN" code. Our software company is heading towards a GUI interface, but we currently have approx 250 custom programs that would need to be converted. Just about all of our legacy code is written in RPLGE / CLLE. We have a few simple apps that were...

    ToddN200011,190 pointsBadges:
  • L Spec in RPG/RPGLE

    Hi, In our project we are using L-Spec in some of the program. Can any one explain the basics of L-Spec. Sabarish

    Sabarish60 pointsBadges:
  • How can we send error message at message line from RPGLE program.

    Hi All, I want to send one error message at AS/400 message line from my RPGLE program. for example i want to send one error message to the user saying that "ABC File is empty" if he excutes my program.

    Mohan K695 pointsBadges:
  • Add, change and delete Subfile records

    We currently have an order entry program that lists items on an order and you can position to an item via a field in the CTL area. My question is I need to be able to add items to an order by keying in items, qty, etc from the bottom of the screen. The order header info needs to be on top of the...

    filuphaze475 pointsBadges:
  • understanding and detecting sql performance situation with abnormal 400 shutdown

    Need help in understanding and detecting situation with logical files built for sql rpgle performance and abnormal shutdown. Our system went down due to ups failure. All of a sudden the rpgle sql program is a resource hog because it is not selecting the lf that was built specifically for...

    Modiyooch540 pointsBadges:
  • Day of Week in RPGLE

    Hi, I need to get the DAY for the given date in RPGLE program Is there any efficient method available to calculate this or any reliable APIs? Heard that CEEDYWK is very useful API to calculate the DAY OF WEEK. if any of you have the sample code, please share with me. Thanks in advance. -Deva

    frmdeva365 pointsBadges:
  • Exfmt opcode

    Hi in a display file i can have many record formats.But while using them for I/O operations in the RPG programs can i use multiple EXFMT operation at different places? And how to control it in loops.Give me an example. Also tell me sample code for F12-cancel to go to the previous screen of display...

    ten20081,150 pointsBadges:
  • What is command we can use for calculate difference between 2 times (like subdur)?

    we can use subdur for calculate the difference between 2 dates. and what's the function code that can use for difference between two times?

    Ccss10 pointsBadges:
  • RPG/400 CHAIN opcode

    Hi,anybody tell me how to find the end of file situation while reading through the CHAIN opcode on a file in RPG/400 and in RPGLE. I think RPGLE we have %found built in function.thanks

    ten20081,150 pointsBadges:
  • How to use XML in RPG

    Hi All, I want to know if its possible to FTP a file from RPG to any other systems using XML. More precisely, can we use XML to pull the data from RPG and feed it to other systems. If yes, appreciate if you can give some inputs or notes where I can find the complete process or code. Thanks.

    RPGPGM40 pointsBadges:
  • RPGLE pgm to determine the last day for a month

    does anyone have an rpgle pgm that will return the last day of the calendar month if given the month and year.

    Mtspudgun45 pointsBadges:
  • I want to read a pf and build a corresponding SQL statement and save the statemnet in text file.

    how can i read pf ?as pf is colomn speciffic have to read pf like it will have feilds and some constraint, key, record. how can i build a corresponding SQL statement ? i m new in AS/400 but i have to submit this utility to my manager this thursday.. can anybody help me in providing some code for...

    0 pointsBadges:
  • Synon/Cool:2E – internal/external func performance question

    I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external...

    Rituraj0 pointsBadges:
  • RPGLE %CHAR strips off leading zeros

    Chan we stop %CHAR from removing the leading zeros?

    Coder10 pointsBadges:
  • How to automate getting the .CSV file from IFS folder to local desktop

    I am working on tool which extract the data from physical files based on some condition and creates a .CSV file in IFS folder. I want to automate the process to get the CSV file to local Desktop and should save the file in specified location in local system. Is there any way to open the .CSV files...

    Richapd5 pointsBadges:
  • No Source Showing

    When I compile my RPGLE source I do it with the *source for dubugging. I just noticed this was happening. Now when I try to do a display object descrition i do not get where the source was compiled from. ANy Ideas why? I need this ASAP. Thanks Source file . . . . . . . . . . . . : Library . . . . ....

    RonKoontz1,780 pointsBadges:
  • IFS Get list of files in a directory in RPGLE

    Need to retrieve into a RPG program a list of all files in a folder on the IFS. Can this be done?

    Gcnpkn5 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:
  • RPGLE – Provide One-to-Many mapping

    hi, I want to provide one-to-many mapping . consider 1 example, i have one-to-one mapping in Agent and Depot. bt i want, one Agent & Many Depot mapping. Means we can have one Agent with many Depot. using RPGLE or SQLRPGLE. I have one subfile where we can retrieve Agent, Agent name, and Depot from...

    23425 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