• 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:
  • RTVQRYF (Back in time)

    Hi, I have recently joined a company which hasn't moved on since I was there last in 1990 !!! We still use RPG3 and Query (no ILE or SQL for us) Anyway my question. We need to create a utility which will find all queries that use or write to a file. I have downloaded the RTVQRYF cmd from the...

    Oldtimer45900 pointsBadges:
  • STRSEU a member and display a message while edit is starting.

    how can I run the command STRSEU and display a message to the user when the source is displayed. the message can be displayed in the TOP command line or anywhere else on the screen. thanks !

    GonenSho0 pointsBadges:
  • Utility to Print RPG Output Specs

    Does anyone recall or use a utility that was used in "the old days" to print a listing of the O-specs in RPG II. The utility would review an RPG source member. It would then print a listing of what the output heading and detail lines would look like. It used "X"s and "9"s to show lengths of fields...

    MikeBaker5 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:
  • STRSEU macro – how to run Repetitive tasks on source members

    I want to run few CHANGE commands on list of source members and add some logic to the CHANGE commands - e.g. if a source line contains 'AAA' then do CHANGE 'BBB' to 'CCC' I want to be able to run it in Foreground and Batch. For those of you who understand z/VM or Z/os - I am looking for something...

    GonenSho0 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:
  • Writing system errors to QPJOBLOG system file

    Ped wrote in with this question recently: "From an ILE-C program, how do I code to write 'system errors' to the QPJOBLOG system file?" Can you help him out? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson435 pointsBadges:
  • How to open file in different modes in RPG?

    Hi, There have been a lot of changes in RPG over the last few years and I've lost track of many of these changes, so I have a question about file opens in RPG :- Is it possible to open a file for either input only or update without using overrides (and preferably without multiple F-specs)? The idea...

    Gilly40023,730 pointsBadges:
  • DDS / RPG – cursor management

    My question is regarding cursor management. My application displays list of members (using RPG and DSPF). There is one input field per row, in which the user enteres the option he wishes to preform on the selected row. The RPG processes the selected row, by the given option. My question is: When...

    GonenSho0 pointsBadges:
  • RPG ILE Debugging

    How can I STRDBG for an interactive job that's already running executing an RPG ILE program. Program already compiled with #all debug view, but no way to predict when the production program is going to fail.

    RapidoContrater0 pointsBadges:
  • QSYSOPR not authorized to RTVUSRPRF

    I have a job that runs continually in it's own subsystem under the QSYSOPR profile. I need to retrieve print default values of the user that triggers the job to run. When I use the RTVUSRPRF command or QSYRUSRI API, I receive USER NOT AUTHORIZED message. I looked at the authorities for QSYSOPR and...

    anncyb80 pointsBadges:
  • Can anyone please tell me what is the basic difference between arrays and tables in RPG.

    Hi All, Can anyone please tell me what is the basic differance between arrays and tables in RPG and for which type of requirement we have to use arrays and tables. since there might be bit difference between both of them. Please explain me.

    Mohan K695 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:
  • data search using popup window

    Is there a sample RPG/CL/SQL code on how to create a popup window to search data from a PF?

    sarapsm5 pointsBadges:
  • Input or Update Primary files and (shudder) the RPG cycle …

    First, I'd like to say that obviously there are some very knowledgeable midrange people here ... lots of good tips to pick up ...  I've been programming RPG since the early 80's ... and I notice that   very few people ever use or even refer to the RPG cycle any more ...  nor do I ever see IP or...

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

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