• 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:
  • 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:
  • Setting a Network Printer to a Print Server, CRTDEVPRT

    Hi,I need to CRTDEVPRT a network printer in AS/400. This *LAN printer is connected to a Server and I don't wish to vary on the device all the time so I need to create a permanent on device everytime the AS/400 subsystem is up.I managed to create one device description but somehow everytime after I...

    Wxchoy0 pointsBadges:
  • QSH error “find: 001-2191 The ending ‘;’ character was not found.”.

    I have attempted to use two approaches (from postings on Search400) in order to clean up the IFS. Both of these use QSH. I have a problem in that both iSeries machines at my disposal ignore the ";" at the line end, and return the error "find: 001-2191 The ending ';' character was not found.". An...

    Clincha0 pointsBadges:
  • QSYS2/SYSCOLUMNS missing

    When using ACCESS or EXCEL queries via ODBC to AS400 files (V5R1) I get an error "SYSCOLUMNS is missing" How can I rebuild it? Thanks

    JPPLOU135 pointsBadges:
  • CPYSPLF with *FIRST option.

    Hi all, I am try to use the CPYSPLF command to send spoolfiles to a file, but there are 2 spoolfiles with the same name. The command can not use the *last option because the 1st file has the data I need. So I need a CPYSPLF command that has the spool number option of *first, or a way to change the...

    Kevin9990 pointsBadges:
  • startup program not autostarting when called in QCTL

    I have a fully re-written startup program placed in my library,and for some reason if i pwrdwn/IPL or after option21 backup startup program does not autostart but if i call the program it works,the system value is set to look at mystartpgm in mylib but doesn't work instead gives message...

    JediK45 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:
  • User Profile ownership

    We are currently cleaning up the security related objects on our iSeries and noticed that user profiles are owned by a variety of users. The question came up then - who should own the non-IBM user profiles? Has anyone else addressed this question and how did you decide who owns which profile?

    Wannabinoz0 pointsBadges:
  • Printing problem

    In Herb's shop they have an old program running in the 3600 OS. They are pushing that data output over to OS/400 on the same box. Their problem is a printing issue where the remote printer, available across a stable VPN, is not properly compressing the printing output to accommodate the size of the...

    MichelleDavidson515 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

    MichelleDavidson515 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,643 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:
  • PicklistStrings returning a blank view when on a local replica

    I have a button on a form that allows the user to select a document's values from a view. I used uiworkspace.pickliststrings to return a category of a view for selection. It works fine if using the database on the server. However, when using a local replica, the view returned is blank and I have to...

    Patagudo5 pointsBadges:
  • Add a user to the iSeries

    Vince wants to add a user to his iSeries, but he's not sure how to do it. Can you lend a hand? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson515 pointsBadges:
  • client access express “restore down” issue

    I have users running Windows 2000 with client access express where a particular AS400 session will not allow the option to "restore down". When they choose restore down, the window goes directly down to the task bar on bottom of screen. From there, the option to "restore" does not even respond. The...

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

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.

Thanks! We'll email you when relevant content is added and updated.