• 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:
  • 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:
  • Erro in Subform in Ms Access Reports

    Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but not solution is there: NZ(), Val(),...

    Rahmedarain200510 pointsBadges:
  • Microsoft Access 2003 slow on Windows Server 2003 Enterprise

    Recently one of our servers was upgraded from Windows Server 2003 Standard edition to Enterprise. We run a MsAccess2003 system on the Servewr, both backend as well as front end. Performance on the Enterprise system becomes visibly slow when process larger volumes of data at speed! Has anyone had a...

    Linx5 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:
  • ODBC Request from iSeries to Excel

    I am trying to use an ODBC DSN I have created, that uses the iSeries Access for Windows Driver, to download data from a file in QUSRSYS, to Excel. I have to download from QUSRSYS because the file is IBM supplied. Note: QUSRSYS appears in QSYSLIBL system value. The problem I have is that unless I...

    PaulThomas0 pointsBadges:
  • How to use API to access DB2 file on iSeries

    Gredon would like to access (search, read, insert, update and delete) a DB2 file on the iSeries with an API. He said he's searched the IBM manual, but he couldn't find the APIs that he can use. Can you help him? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson435 pointsBadges:
  • Trouble Editing Data on iSeries from Web Application

    Hello. I'm having a problem editing data in a database file on my AS400. I have an application server set up on the same machine and I've created a data source to access the files in my library. The provider is "DB2 for OS400 V5R1 JDBC Provider", the database name is "*LOCAL" and the library name...

    Cmorre0 pointsBadges:
  • CUM PTF apply

    The last two times I applied a CUM, the IPL did not complete because of false hardware errors. I was told by IBM that the microcode must have "gotten confused". I had to manual IPL from the B side which worked fine, then reIPL unattended to actually get the PTFs to apply. There was never any...

    Pat470 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:
  • Join our ITKnowledgeExchange.com LinkedIn group

    We have created an ITKnowledgeExchange.com LinkedIn Group If you are a member of LinkedIn come and join the group. You will be able to continue the discussion or post questions that we will post onto the site. Thanks Sean Community Manager

    ITKE346,125 pointsBadges:
  • Cross-site scripting attacks

    I'm looking for advice on cross-site scripting. What can these attacks do and what can I do to protect Web sites/applications against them? Are there any resources you recommend? Thanks

    Kit1230 pointsBadges:
  • Looking for application vulnerability scanner

    My group is considering implementing an application vulnerability scanner to look for security holes in our Web sites. Can you recommend some products? Thanks

    Coder6270 pointsBadges:
  • The IT Blog Top 10: Nov. 12, 2009

    10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...

    Michael Morisy8,323 pointsBadges:
  • content of source physical

    hi all, can any one plese tell ,how can we see the content of any source physical

    Ambrish 82310 pointsBadges:
  • how to access any particular menber of any pf

    Hi, if i have a pf having 5 members..how can i access 3rd member of it through in rpgile.. regards Ambrish

    Ambrish 82310 pointsBadges:
  • Access Form Printing Problem

    I have designed a set of forms in Access.  One of the forms prints the form in total.  However tow of the forms will only print the header and footer and does not print the data input portion of the form.  What am I missiong in regards to why I can't get these two forms to print in total? Thanks

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

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