• 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:
  • 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:
  • single page subfile

    Hello friend, Currently i m learning as/400.i am confidence when i make load all subfile and expandable subfile...but when i go for single page subfile...i always stucked....i dont understand..page up and page down subroutine.....if anybody hv full progrm for single page subfile plzz mail me.... my...

    Swapniln35 pointsBadges:
  • how can we use ponter in function keys?

    usually we are using if *in03=*off like that instead of this i want to give directly IF EXIT like that I think some pointers are used to this i am not sure about that please replay me this question.

    It doubts85 pointsBadges:
  • How can i see the source code for COMMAND created in iseries system.

    I want to know how i can see the source code for the command created in system

    Harish.kuolkhere190 pointsBadges:
  • AS/400 what keyword is used on the RPG IV definition specification to rename a subfield in an externaly defined data structure

    what keyword is used on the RPG IV definition specification to rename a subfield in an externaly defined data structure

    Developin5 pointsBadges:
  • SQL multiple files

    On our iSeries I need to find out if fld01 or fld02 or fld03 in file "C" contains a value that is obtained from file "B" using a value from file "A". How would I do this using SQL?

    Floyd02320 pointsBadges:
  • Why do we use Fully procedural file (F) for some input Files defined in F-Specs

    Why do we use Fully procedural file (F) for some input Files defined in F-Specs...??

    Sidd30 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:

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