• 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...

    MichelleDavidson485 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

    MichelleDavidson485 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,598 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

    MichelleDavidson485 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:
  • 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:
  • Getting SHRPOOL Pool to Work

    I have added SHRPOOL1 to the pool definitions for one of my subsystems. I also changed all the routing entries to use this memory pool as well. I've been watching the memory pool with WRKSHRPOOL for most of the day and it appears that nothing is running in that pool. Some jobs have been running in...

    Sully350 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:
  • inactive timeout different for one user

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

    oldpgmr75 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.

Following