• Issue with a sub procedure and its arguments.

    I'm trying to build a sub procedure to create a list for a combobox.  Basically, the db has sererate fields in the client table for first and last names and I want to create a combobox that lists each in one line. The real point of the question is whether or not I can build a sub procedure so I...

    McNitro255 pointsBadges:
  • Agents Are Not Included in Database Copy

    If I have a database that has agents with restricted access (set on the Agent Properties > Security tab) and I make a copy of the database for use as a template, the restricted agents are not included in the copy. When I make the copy, I choose the options for Database Design Only and Access...

    Brooklynegg3,845 pointsBadges:
  • foxpro 2.6 on windows 98

    I am developing a software in foxpro 2.6. on windows 98 When i run the project after every 16 trasactions it gives an error as follows :-      " DO NESTING IS TOO DEEP " there is no logical or syntax error in the project. But still it gives this error. Anybody can tell me the solution.  

    Pramodtenkale15 pointsBadges:
  • What is correct syntax for SQL for Maxrecords in OS400/DB2?

    What is correct syntax for SQL for Maxrecords in OS400/DB2? We have a process automatically generating SQL code. However, our iSeries doesn't recognise the code it generates for maxrecords. Here are the examples of what I mean. The DB2 database seems happy with SELECT I1PHON,I1ACC,I1ACC1, FROM...

    Peterax0 pointsBadges:
  • How to operating with Multiple Member PF in RPG ?

    I have a multiple member physical file and I want to operate(read/update/delete) with specific member in RPG. The member name for that PF need to be set at runtime depending upon from which program this rpg program is called. I am writing the sample code that I was trying, but it ends up with...

    Inlog10 pointsBadges:
  • rpg

    We just upgraded to an iSeries box with 5.3. We were running 4.6. My RPG programs function properly until I recompile the program. Then I get an compile error 7073 regarding the length of a key field not equal. The compile shows BIN2 (and sometimes multiples) after the other key fields and I can't...

    Kahenry0 pointsBadges:
  • Msg 102, level 15, State 1, Line 14

    Hi, I'm ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the 'ON' on the line "SET ANSI_NULLS ON". Could you please help me? I can't see what's wrong. Here's my code:  CREATE PROCEDURE InsertDBTables  AS  BEGIN  SET NOCOUNT...

    MasterK15 pointsBadges:
  • The IT Blog Top 10: Nov. 19, 2009

    10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for...

    Michael Morisy8,323 pointsBadges:
  • To trap the item name of more than one item selected in list control

    1)Is it possible to trap the item name of more than one item selected in the list control?Then how?I wish to trap the item name of more than one item selected in the list/combo control with/without the help of index numbers of the item selected. 2)And then use this item name to pick up data related...

    MBAinsystems5 pointsBadges:
  • inactive timeout different for one user

    can I set a different inactive timeout (logoff) for one user?

    oldpgmr75 pointsBadges:
  • Access SQL Server 2003 database from ISeries

    Hello everyone, I have searched the web for SQL Server/ISeries connectivity and have come across some interesting options: java, JDBC etc. But they have not been very clear. I understand that it is not a simple task, but has anyone successfully accessed an SQL Server database from ISeries using SQL...

    Orozcojoe0 pointsBadges:
  • Reading a file twice in CL

    I declared a file in CL. I read all the records, i.e End Of File has reached. Now again i want to read he file from beginning within the same program.I tried with OVRDBF and POSDBF.But could not succeed.Can any body help me?

    Kumari0 pointsBadges:
  • How do I retrieve the JOB/USER/NBR for a spoolfile generated by a GUI program?

    I have a GUI program which HAS to run interactively that generates a spoolfile. The HTTP job (Which is what I correctly retrieved using RTVJOBA & QUSRJOBI)is: Job: VOI User: QTMHHTTP Number: 303484 But the job that my spoolfile has is: Job: QPRTJOB User: <My user ID> Number: 303384 Does...

    Orelalaith0 pointsBadges:
  • Datasheet view sorting question

    Using the datasheet view, when sorting on a field with or without a dropdown menu, select a choice and then no data appears, even when there is data in the list.  This is a repeatable problem.  Has anyone else experienced this problem?

    Rozier5 pointsBadges:
  • Composite foreign Key in SQL Server

    I have a composite foreign key that has to be part of the primary key of the new table... but an error appears in SQL server... CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel, IDvta)...

    GabyCostilla5 pointsBadges:
  • 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:

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