• How can I split job by determine no. of records ?

    I have a problem. My transaction file is about 20,000 records. This file is used as input/update file. It uses a long time when we run job in day end. I want to use less time. How can I split job to 4 job and each job run only 5000 records? How can I determine as follows ? job 1 process data only...

    Cookiekitty110 pointsBadges:
  • deal with microsoft access data base file from RPG program or clp

    hello, I need to made clp or RPG program to open microsoft access data base file from my PC then read and update special table from this file thanks best regards laila elsharkawy

    Lsharq0 pointsBadges:
  • OVRDBF in JAVA

    I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?

    Cganeshh0 pointsBadges:
  • OVRDBF in Java

    I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?

    Cganeshh0 pointsBadges:
  • To retrieve data from a remote system

    Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can't be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series either as...

    Helbert0 pointsBadges:
  • Using SQLRPG on a DDM File

    Hi, I need to access a DDM file via SQLRPG -since SQL does not directly support DDM -can it be done by first using OVRDBF on the DDM file to override it to a local file and then use SQLRPG ? Help would be much appreciated for a project I am currently working on. Thank you! Ruwan

    Ruwan7770 pointsBadges:
  • Updating a VSAM file

    Tim wrote in with this question recently: "I need to update a VSAM file on a mainframe connected to an AS/400 -- via TCP/IP. Ideally, I would like to add/delete/update a record on the AS/400 and have the database issue a call to a CICS program on the mainframe, pass data to the CICS program and...

    DebraTart0 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:
  • 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:
  • 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:
  • 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:

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