• Date Function AS400

    I need the Date function of DB2. Actually I want to subtract the Date however I have used the follwoing: select current date -1 from sysibm.sysdummay1; But It occures an error. Is there any way to subtract the date in the query. I am using iSeries DB2 AS400

    Mr. SEA130 pointsBadges:
  • iSeries PF Calendar File

    I am looking for some code which will create a calendar file with the following fields date 010108 day of week monday and week number based on 4 week cycle. Thanks for any help!

    JAC260 pointsBadges:
  • EVAL Math Problem

    Bruce, can you figure out this piece of code? I don't understand the result I get. Before code is executed: XXAVAL = 0, LTSTHQ = 30, LTCUSQ = 30, LTPICQ = 0, XPQTY = 30, OLOLQT = 30 EVAL XXAVAL= LTSTHQ-(LTCUSQ+LTPICQ+XPQTY)+OLOLQT After code is executed: XXAVAL = 0. I figured XXAVAL should be 60?

    kevleemor605 pointsBadges:
  • How do I find out how many lines of source code are on the system?

    Hello. I'm trying to write a program that will tell me how many lines of source code reside on our system. I figured out the first couple of steps, but it just gets more and more confusing along the way, and I really think there's gotta be a better way to get the information i need. So far, this is...

    Eric Witham690 pointsBadges:
  • iseries – Display file – Unicode

    How to make iseries display file display multilanguage characters.

    Buvana6620025 pointsBadges:
  • Find # days between 2 dates in Query 400

    I have never used this function but it looks like the startdate and enddate must be alpha expressions for this to work. Is that correct?

    Abbey120 pointsBadges:
  • How to connect to an AS/400 database from a remote PHP script

    Hello. I have a requirement to use a PHP script running under Windows to access a remote DB2/400 on an iSeries. Can anyone please assist in what PHP coding would be needed, thank you! Regards Paul

    PaulTaylor15 pointsBadges:
  • Call Java program in war file using RPGILE

    We have a Java program running on web sphere on Linux. The java program is zipped as jar and deployed in an IFS directory and we use RPGILE to call the java program. Would it be possible to deploy war file instead of jar file in IFS directory and call the Java program in the war file using RPGILE?

    Uiiuo50 pointsBadges:
  • Learning Java on iSeries

    Can anyone suggest me the link to learn Java on iSeries? I am an experienced AS/400 programmer with knowledge on Java.

    ten20081,150 pointsBadges:
  • How to pause execution of a macro to allow user input of variable data in iSeries

    I am exploring the possibilities to speed up input when testing by taking advantage of macros. The problem is when variable data has to be keyed into a field in the middle of the sequence. Reading the help-topics on WAIT I thought I could use the WaitForCursor-option, but it does not change the...

    Jb26655 pointsBadges:
  • Transform DB2 to XML from AS/400

    I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client's web server. I have looked at IBM's XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something...

    LBurkett99830 pointsBadges:
  • simple code

    Hi friends, Can you give the solution for the below mention simple code.and explain.what is output D CHR1 S 4A INZ('PEN') D CHR2 S 10A INZ('MYGET') D CHR3 S 8A INZ('GOOD') D CHR4 S 22A INZ C MOVEL CHR1 CHR4 C MOVE CHR2 CHR4 C EVAL CHR4=CHR3 C MOVE CHR1 CHR4

    I6195 pointsBadges:
  • finding source files

    I have been given the job of findind all source physical files on out AS400 In the pass there wre no standards for naming them. Have to locate all of these source physical file on our AS400 and them creat a spreensheet of all menbers trying to locate and drop the duplicate source code. Any help on...

    Cjfarms5 pointsBadges:
  • CLP to CLLE

    How can I conver a CLP progra to a CLLE program

    Sarit5 pointsBadges:
  • Word document/PDF used as Help text

    I am wondering if anyone knows of a simple way to solve my problem. We are creating help text documents in word/PDF and want to use those as the help text when the user presses CMD-Help on the RPGILE programs. i.e. when user presses cmd1 for help they will get a nice documented helptext with...

    JAC260 pointsBadges:
  • RPG vs Java vs Others

    Hi, With the possibilities of using all sorts of C and Java type functions now available in RPG and bearing in mind that (in my experience) Java is difficult to tune to perform reasonably on the i-Series is there any benefit for an RPG programmer to learn Java? Or would some other language be a...

    Gilly40023,730 pointsBadges:
  • Synon/2E – No member source genned

    I created a file in the model and it did not generate a source member.

    Jeanmcjax5 pointsBadges:
  • Program utility required

    I have had a request from a developer for the following: Utility program required so that a PF file and library can be specifed with starting date / time and ending date / time. This utility will then extract all the current journal records for that file, including the journal fields e.g. user,...

    Rob66065 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:
  • WEB / iSeries

    Where do you foresee browser-based iSeries access applications going, with regard to development portals, user interface methodologies, etc. ?

    Tsmith7155315 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