• STRQMQRY not sum up the right total

    I try to use STRQMQRY to pass in a variable to run a query. It works great except the query suppose to have a grand total, for some reason, it doesn't add up right. When i run the query manually without using STRQMQRY, it works fine. Anyone know what do I have to do here? Thanks.

    Heidiltl0 pointsBadges:
  • DCLF in CL

    Hi! Can I open two database files in a CL program using DCLF? I've been trying to do it, but I receive an error related to OPNID. If you could send me an example, it would be greatly appreciated. Thanxs. Melissa

    MelissaG20 pointsBadges:
  • having trouble restoring a tape written by a Sys38

    the tape file is not created by a SAV*. We've been trying various combinations of CPYFRMTAP without any luck..... all three data file label say rec length =0 and block length = 16384. the dumped data looks like it might be a library.... with sources files. any ideas??

    Ccrinc0 pointsBadges:
  • CPYTOPCD command.

    Are any of you familiar with this command? Can this be used to copy something from the AS400 to a shared folder on a Windows system, or do any of you know how to accomplish this?

    Bkr0963c0 pointsBadges:
  • MMAIL

    Hello everyone, I recently downloaded the MMAIL Utility for Windows from http://www-922.ibm.com/mmailh/wmimemenu.htm I believe it installed successfully, but I get the following error for several functions like edit, display or open mime files. Error: "The value specified for one of the parameters...

    Orozcojoe0 pointsBadges:
  • OPNDBF

    This may sound stupid but I have not used OPNDBF command till now. I tried to use it thinking it will perform the same function as opening a database file in a COBOL program. I issued OPNDBF in a CL program and then tried to read records within a COBOL program without opening it in the COBOL...

    Pgsdeb20 pointsBadges:
  • RPGLE Build in function (BIF)

    It is imposable for me to set the length of Variable-Length Field D ServUser S 30A VARYING D IDLenth S 3i 0 C Eval %Len(ServUser) = IDLenth After this statement length of field ServUser still is 30 pos long. In Debug mode I get the message CPF7E2B: Type compatibility error occurred. Thank you for...

    Igor0010 pointsBadges:
  • Processing time used by a job

    Herman would like to know: How can one programmatically retrieve the total processing unit time (CPU time) used by a job? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson435 pointsBadges:
  • Access LDA for job waiting on a JOBQ

    Is there a way to access the LDA for a job that is waiting in the JOBQ? I want to write a program to monitor jobs in a JOBQ and move them to other JOBQs based on information that is in the LDA.

    DaveMi0 pointsBadges:
  • Need help using RUNRMTCMD

    Greg is experimenting with the RUNRMTCMD on the AS/400 from a command line. He writes, "Can I run a VRPG exe on my local PC from the AS/400? If so, how? I keep getting a message CPE3447 'A remote host did not respond within the timeout period'. First, where can I get my local PC name? Second, how...

    MichelleDavidson435 pointsBadges:
  • Triggers and commitment control

    We are having problems finding a way to get trigger programs included in the needed commitment control boundary. The process starts with a JDBC connection to the 400, and via Java executing processes (SQL) that make changes to the DB files. The files are triggered, and any of the files the trigger...

    BoomerSooner0 pointsBadges:
  • Automatic email notifications from iSeries

    Nagi needs to write a code on his iSeries 870 to send a notifications to his e-mail, such as server rebooting, jobs not started or need reply, etc. He's a Windows guy, and doesn't know where to start. Can someone help him with the code and possibly send him steps on how to write it and where and...

    MichelleDavidson435 pointsBadges:
  • Variable length fields in RPG IV

    Ed is wondering, "If you don't yet use free-format RPG, is there a way to utilize variable length fields in RPG IV?" What do you think? Is it possible? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson435 pointsBadges:
  • What is signature checking?

    Nirmala is trying to figure out what signature checking is and when to use it. Can you offer some advice? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson435 pointsBadges:
  • How to convert characters to numeric in CSV file?

    Roy wrote the editors of Search400.com recently, looking for help with a CSV file. He said: "I'm using CRTCSVF to create a csv file. My problem is that my customer number is alphanumeric, but they want it to be numeric (without the quotes) in the CSV file and with the leading zeros intact. "Is...

    MichelleDavidson435 pointsBadges:
  • rpg

    I have five indexed files in rpg prog. Can I decleared common key field parameters for all five files? Is it possible in cobol ? If not how will solve this querry in cobol ? Explain with an ex.

    Mahesh115 pointsBadges:
  • Trigers

    Can anyone give me an example of using a trigger when a record is inserted into a file? I am using RPGLE.

    Hex29a0 pointsBadges:
  • Problems with Stored Procedures

    Hi, I have written a stored procedure in SQLRPGLE. I used option 15 to create a module, then CREATE PROCEDURE to define it. When I go into SQL to call it, it says External program SVLBR in V64BPCSUSR not found. This is where my module & stored procedure is located. Any ideas on what I missed?...

    Terriharteau0 pointsBadges:
  • CHGPF command

    I am starting a project where I have to expand a field within a file and also add another field to the end of the same file. My question is this: I've never used the CHGPF command to change the file in the following situation. I've heard that you can use this command to create the new object and at...

    NJShoreBob0 pointsBadges:
  • Use of %Lookup BIF in Free form RPG – V5R3?

    Hi, I am having a problem when I try to use the %Lookup BIf in free form RPG. It doesn't seem to be functioning as it is supposed to. Is there something that I am missing (like PTFs) or is there a workaround to this problem if it is a previously known issue? Thanks for your help!!

    Adityavarma0 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