• How to access all records in RPGILE

    hi all, suppose i have a report with input criteria 'machine code' and requirement it that if i input a perticular 'machine code' then it should COME only that , otherwise all records of all 'machine codes' should come , in clp i use %WLDCRD for that. but i need to do it in rpgile , is there any...

    Ambrish 82310 pointsBadges:
  • RUMBA macro to append data

    Hello, I am a new user to the RUMBA AS400 client. I am trying to make a macro that appends all the data that is copied. But i can not find an option for it. I have found copy all but i can not make the keystrokes to use the append data feature. If someone knows the answer i would greatly appreciate...

    Markmark10 pointsBadges:
  • Changing system request

    I wanted to change the system request option 5 from SNDMSG to a command line. So i created a new message file and changed the text in CPX2313 and then i used the command to CHGSYSLIBL to put my lib on top of the libl. But still when i take option 5 on system rqs i get the following error "Command...

    Arigekarthik20 pointsBadges:
  • Debug an AS/400 program called from Java

    Hi, Is there any way i can hold an AS400 job triggered from java. I need to debug a program which is interactively called from java.

    ARJEN85 pointsBadges:
  • Grouping the records in RPG

    How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??

    Shwesmile20 pointsBadges:
  • Decimal Value as a Date

    I have an AS/400 field called ADMIT_DATE that is typed DECIMAL(8,0). It contains values such as 20061031. (including the decimal point). I would like to convert that field to an AS/400 DATE field such that the resulting values look like 2006-10-31. Can someone provide an example using the AS/400...

    Nmolley5 pointsBadges:
  • How to display the SQL query results on SDA screen?

    I got an answer for how to embed the SQL statements in RPG program. Can you please help me with how to use these values in the program, or display them on the SDA screen??? Thank you. :)

    Shwesmile20 pointsBadges:
  • numeric operation is too small to hold the result (C G D F)

    HOW TO REMOVE THIS ERROR-"The target for a numeric operation is too small to hold the result (C G D F)"?

    0315 pointsBadges:
  • How to mirror two databases (PRD to DEV)?

    HI, I am trying to mirror my DEV box data lib with Production box. Currently i am creating a save file and then i FTP it to DEV box and restore lib. Any other way to do this? FTP takes a lot of time to transfer so, any suggestions on fast transfers would also be helpful. thanks

    Rockleadme385 pointsBadges:
  • AS/400 – OCL procedures

    How to compile an OCL Procedure and debug the same in AS/400

    Horro5 pointsBadges:
  • DML

    What is DML.How to use DML in AS400. What is the advantage of using it?

    rajeshece1,215 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