• RPGLE Stored Proc to Reporting Services

    Have SQLRPGLE program set-up to use cursor to return result set, want to use this to return table to MS Reporting Services get error message "low-order nibble of byte array offset 2451 is not valid. Byte Value OO. What does this mean and why not data back to client?

    Oldmickey65 pointsBadges:
  • Falshing output screen!!

    Hi, When i try to call a compiled RPGLE program : *************** Beginning 001.00 /free 002.00 dsply 'hello'; 003.00 *inlr= *on; 004.00 /end-free No errors their but fast output screen appear to disply "hello" then goes . want it to stay until i click enter!! Can any body help in this issue? Thx

    NA35 pointsBadges:
  • AS400 Physical file conversion to xml file

    Hi, i need to write an RPGLE program to convert an as400 physical file to an xml file. Does anyone have a sample code for it? Thanks in advance.

    Siri55 pointsBadges:
  • 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,820 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:

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