• AS400 to the Excel

    I need to split the city and state. I can do it once the results are in Excel but I would like to do it on the way from the AS400 to the Excel spreadsheet.

    Dbatank0 pointsBadges:
  • Printing Summary Information From The SAV command

    I am trying to print a summary report from the SAV command. Using OUTPUT(*PRINT) INFTYPE(*SUMMARY)creates a 500+ page report (which to me is not a summary). When I try using a stream file OUTPUT(FSAV), and then CPYFRMSTMF to an AS/400 file, I get mostly unreadable data in the AS/400 file. I am not...

    Bncboja0 pointsBadges:
  • as400 architecture/framework

    Can Somebody give me links to the reference material for v5r3 i series server framework or architecture as that of .net framework were we understand the entire process happening like compilation ,the assemblies etc.

    Peraj55 pointsBadges:
  • asp’s maintenance

    1) for example there is 2 asp's.ASP1 and ASP2. how to know these      particular files or objects belongs to ASP1 or ASP2. 2)can we copy a file or objets from ASP1 to ASP2? THANKS IN ADVANCE..

    Flakek60 pointsBadges:
  • Showcase Query 8.0 CDs or DVDs

    I did an upgrade to V6R1 before I did an update to our Showcase Query Suite.  I am looking for a copy of the Showcase Query CD or DVD for Showcase Query Suite 8.0 released after September 2008. If anyone has this and would be willing to send me a copy please let me know. SPSS cannot ship any media...

    MNBV15 pointsBadges:
  • content of source physical

    hi all, can any one plese tell ,how can we see the content of any source physical

    Ambrish 82310 pointsBadges:
  • how to access any particular menber of any pf

    Hi, if i have a pf having 5 members..how can i access 3rd member of it through in rpgile.. regards Ambrish

    Ambrish 82310 pointsBadges:
  • AS/400 Simulation

    Hi, I am trying to locate software that will allow us to simulate an AS/400 for training and demonstration. Do you know of anything that will fit the bill? Thanks in advance for your help. Regards PJ

    Mkdirect0 pointsBadges:
  • Automatic Data transfers from iseries

    I am quite ok with manual data transfers and menu options calling transfers, but does anyone know how to get a data transfer set up from the iseries to a mapped drive on our server to run automatically, e.g. at 04:30 am ? Also, is it possible to send data from the iseries to a server that is not on...

    KasMcc230 pointsBadges:
  • iSeries – Can I have a program that can read QSYSOPR msgq and execute a pgm?

    Hi there; If QSECOFR is disabled, and I get the corresponding CPF1393 (thanks PaulThomas) message id in QSYSOPR, then: - Is there a way to automatically re-enable it? - Maybe by a PGM? - I thought of a once a day to read QSYSOPR, search for CPF1393, if text contains QSECOFR, then reset it. Is this...

    Mutkey0 pointsBadges:
  • rpg

    I have five indexed files in rpg prog. Can I decleared common key field parameters for all five files? Is it possible in cobol ? If not how will solve this querry in cobol ? Explain with an ex.

    Mahesh115 pointsBadges:
  • Trigers

    Can anyone give me an example of using a trigger when a record is inserted into a file? I am using RPGLE.

    Hex29a0 pointsBadges:
  • Create aceess database(MDB) from iseries

    I need to create mdb's from iseries through RPG or CL program. Can somebody give me some information around this. TIA

    Manish1230 pointsBadges:
  • AS400 J1 Back Up Help

    Our AS400 usually does the day end routine automatically in the evening after the office is closed. We had an issue which we thought might me solved by setting off the back up manually. How long does this take? We set it off an hour ago and still cannot get back on. If we try opening a session it...

    Lyndsayloo5 pointsBadges:
  • How to find last RUN date of a Query on AS/400?

    My system currently has 2000+ queries defined. Not all are active. Is there a way to determine the LAST RUN DATE of a query as opposed to the LAST CHANGE date. Most of our queries are not resaved (ie 'changed') each time they are run. Thanks in advance for your help.

    LITTLELINDA0 pointsBadges:
  • Problems with Stored Procedures

    Hi, I have written a stored procedure in SQLRPGLE. I used option 15 to create a module, then CREATE PROCEDURE to define it. When I go into SQL to call it, it says External program SVLBR in V64BPCSUSR not found. This is where my module & stored procedure is located. Any ideas on what I missed?...

    Terriharteau0 pointsBadges:
  • Reading a file in AS/400

    I wanted to read a Physical file based on library. Eg: One master file is available in most of the libraries. I wanted to change some data in that file. So i wanted 2 read file in all the libraies. how to achieve this using program?  

    rajeshece1,230 pointsBadges:
  • iSeries navagator and Windows 7

    Hi Everyone we have some users that are now on windos 7 and when they try to use iseries navagator to drag splool files from the 400 to their desk top the file is unreadable and can not be saved. Has anyone else haveing this problem and is there a fix.

    Braz45 pointsBadges:
  • hey, I do COBOL on the iSeries, lol

    Where have all the COBOL programmers gone on the iSeries?? I have programmed in RPG (6+ years) but prefer COBOL any day of the week. Rarely see any questions and tips in the COBOL arena. Just curious and willing to teach anyone COBOL. Want to move to Florida?

    McSick50 pointsBadges:
  • how create a printer file in AS400

    HI, The message shows "Mistakes in the DDS not allowed with the specified GENLVL, one has not found the device of printer PRT01. File PRTF1 has not been created in the library HIPTSTMAP1"   Obviously use CRTPRTF. Probably another way exists to create the file of printer. THANKS.

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