• 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

    ITKE344,995 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:
  • How do I fetch synonym names with the SQLTables function in ODBC API?

    Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Way to speed up first invocation of stored procedure?

    Can you help? An iSeries user recently wrote the editors of Search400.com with this question: "One of our stored procedure takes approximately 1 minute for the first invocation when I do a call using RUNSQLSTM. If the same procedure is called repeatedly with different parameters, the results come...

    MichelleDavidson435 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:
  • Owner ship change

    When would an ownership change appear? I know If you transfer owner ship authorities to other user . Is there any other way to change ownership.

    IVANRAO0 pointsBadges:
  • Database Splitting

    What other alternative do I have to split a lotus note database beside writing a code to copy  document to newly created database?

    mariolos5 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