• Modify the result after a division with multiples of 10

    I have an expression like this Total = Quantity/10**decimal. If I have value 000080906140000 in quantity and decimal has 6, my result is 0000000080906.13. But I want it as 0000000080906.14. Is it possible?

    RamvishakRamesh2,505 pointsBadges:
  • Identifying Source Mbr Names Conditionally

    I would like to find a way to conditionally print source file member names that contain a trailing $ sign. Is there a way?

    Tom196035 pointsBadges:
  • Compare creation date of file to system date

    Hi, I need help in figuring out the begaining of my CL program. I would like for the CL to act accordinly. Check a file creation date and compare that date to the system date, then if a match (do something), if not a match (send message and end job). Thank you

    lotofbad205 pointsBadges:
  • Strengthen QSECURITY level 30

    Hi, Any tips and tricks on how could i strengthen QSECURITY 30 to patch the loophole in this level (without going to QSECURITY 40)? Thank you

    iNewbie215 pointsBadges:
  • Blank line Input capable page at a time subfile

    Hi - I am a bit rusty subfile-wise and was hoping to find an example of a page at a time subfile that provides position to and blank line input capability on the user's request to add records to the file. I'm particularly curious about the paging concerns involved. What can I say...It's been a...

    MiamiAl15 pointsBadges:
  • Special Authorities

    You have a group profile (ABC) with special authorities of *ALLOBJ. You have a group of users with user class *PGMR with special authorities of *JOBCTL and *SPLCTL. They also have limited capabilities set to *NO and they are part of the Group Profile ABC. With command line access and having...

    Skinh5 pointsBadges:
  • MKS implementer issue

    We use the product MKS implementer to manage our implemention of file and program changes from a test environment to production. Whenever we make a file structure change to the physical file, such as increasing a field size in our test environment and then implement the change, the logicals...

    TLloyd180 pointsBadges:
  • How to create a Spool file

    I queried on a file it gives me hundreds of records. Is it possible to create a spool file with these record? If yes then please tell me how?

    ankit2002770 pointsBadges:
  • Websphere MQ 7.1 uninstalltion in IBM i server 6.1

    I have installed MQ7.1 in my IBMi server 6.1 but its in evaluation period so we planning to re-install it. Please can you tell me the uninstalling steps?

    IBMiserver35 pointsBadges:
  • Printer files in AS400

    Hi.. In our AS400 server many printer files are there. when we use WRKACTJOB to see the status, some printer files(QSPL)are always in RUN status and its taking too much CPU %. what will be the problem ?

    Sureyz2,475 pointsBadges:
  • How to create an EXCEL

    I queried on file and fetch nearly 10000 records.I want these recrods in the excel,however I dont want to copy and paste.It will take a lot of time. Is there any method or command in AS400 which can do this task,

    ankit2002770 pointsBadges:
  • scheduled job

    how to check the user that changed a scheduled job from held to release?? because we have a backup job in WRKJOBSCDE that is in held and being submitted daily manually. but what happen is that it run it self in QBATCH and we are also submitting the job again. so it create a duplicate backup on the...

    joverparas380 pointsBadges:
  • result of CHAIN with a bad key

    Rather than proving it out myself, it's so much easier to ask if anyone has run into this before. While researching a bug, I found a program that chains to a file using a 3-field key list. BUT - the 2nd and 3rd fields are "wrong" (defined as alpha in the key list but numeric in the file). Seems...

    aceofdelts2,005 pointsBadges:
  • Please help with SQL query

    I have a file which has 6 different account numbers. For each of this account number, I need to check in File1 which has account number, security and Quantity. I need to sum up the qty field for a combination of Acc num and security. Once I get the security, I need to search in another file say...

    RamvishakRamesh2,505 pointsBadges:
  • System i Navigator Run SQL Script block CL commands

    Hello. The run sql script in System i Navigator allows me to run CL commands. How can i block this? Thx in advance.

    MelGranja20 pointsBadges:
  • Message file within message subfile

    I have created a message file and now i want to link my message file to the DDS. Please suggest any way....

    sonaliray10 pointsBadges:
  • File read

    I have a file1 with a field account number. Accnum A B C I have another file2 with field Accnum, Security and Qty AccNum Security Qty A X 1 A X 3 A Y 2 A Y 3 Now I need to generate a summary file like this by summing up the quantity for those records with same account number and Qty A X 4 A Y 6 B X...

    RamvishakRamesh2,505 pointsBadges:
  • List of objects

    Hi.. I got to create a pf which will have list of objects present in all the user libraries availabe. When i use DSPOBJD, the server gets struck. DSPOBJD works fine when a specified library is specified. But in order to get all the objects, is there anyother options?

    Archnav01270 pointsBadges:
  • How to capture decimal value of numeric fld

    I need a way to capture the decimal value of a numeric field (i.e. 5.78). Need a way to be able to break the decimal value away to do computations on it. How do I achieve this using RPG III coding techniques?

    Tom196035 pointsBadges:
  • Error Message Display

    We have written an RPG program that runs on a Hand Held RF Scanner running a 5250 emulation program. We defined the screen to display error messages on line 12 o fhte display. When we run the program on the scanner or a standard display screen, the error message always displays on line 24. Any idea...

    SteveLane662855 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.