• CPYTOIMPF and multiple record formats

    I have four different files with four different record formats which need to be copied into one file with alternating record formats, (rec fmt #1, rec fmt#2, rec fmt#3 rec fmt #4 in that order). The file also has to be field delimited with pipes, and so I thought CPYTOIMPF would work, but I am...

    Mattheus55 pointsBadges:
  • copy pdf files from an E drive into an AS/400 data file

    Is there a way to copy pdf files directly into an AS/400 data file?

    MountHood5 pointsBadges:
  • How do I populate an SQL table created on the fly in RPGLE?

    I am writing a report program where I create a table that is then converted to an Excel spreadsheet using SQL2JXL. I am able to dynamically create a table with Execute Immediate but I have been unable to populate it. The problem is the table name is stored in a variable within the program and I...

    SteveFletcher80 pointsBadges:
  • Need a 3rd party AS/400 utility for converting to .CSV files

    Hello there, I’m hoping somebody can point me in the right direction. I need a 3rd party software which will be able to integrate with the AS400 to download 4 files & then convert them into .CSV files. This software will then need to save the exported data files to a server on our network. The...

    Smeakin5 pointsBadges:
  • clearing multple members in a physical file

    Does anyone know of a way (or utility) to clear multiple members in a physical file ? i create multiple members for the file on the fly based upon date/time in a cl program. the file is a weekly archive of data from a transaction processor, and i want to clear it and start over on a weekly basis. i...

    Lacag100 pointsBadges:
  • AS/400 inactive ethernet interface

    I recently brought an AS/400 back on line and the ethernet interface is shown as inactive. I have tried to start it to no avail. Nothing has changed on the software and it was working.

    Sharp as40015 pointsBadges:
  • Constraint Recovery

    Asked on behalf of TimSki37: Is it possible to recover or restore database constraints in a schema/library that has been cleared and restored from a different schema/library? We have a library that was cleared of all physical files and tables were restored from a different library. In doing so,...

    Margaret Rouse3,150 pointsBadges:
  • last field needs a terminator character

    adding FLDDLM character between fields but I need terminator at end of last field, how can I do It ??

    Pasqua5 pointsBadges:
  • Delete Expired SAVF

    Using BRMS for backup on AS/400, the savf will be generated in the brms system library (q* in qbrms and can show by WRKSAVFBRM). I would like to know how the expired savf be deleted if no backup job with same control group execute SAVSAVFBRM? Moreover, will those not successfully saved to tape...

    Magkids10 pointsBadges:
  • How to secure a printer and spooled files

    We need to secure our payroll printer and it's spooled files. Right now anyone is able to view, print or delete reports on this prnter's outq. The payroll person & anyone with SECOFR authority should be the only users with access. How do I set up this type of security? Thank you.

    Patxlb15 pointsBadges:
  • Auto download a .CSV file from network drive

    to a AS/400 physical file through a cl program? how can I do this?

    UARTJ105 pointsBadges:
  • Writing Programmes

    Hi I am currently learning AS400 and trying to write a programme. I want to list users under a subsystem, but there are four different sets of users, and we normally use a set of menu's to get these list's, I want to look at the command behind the menu option so that I can add it to my programme....

    JackieCrossan0 pointsBadges:
  • How to see both SNDPGMMSG of two programs

    i have created two programs. say CALL1 and CALL2. CALL1 Program... PGM CALL PGM(MYLIB/CALL2) SNDPGMMSG MSG('SHANMUKMHA') ENDPGM CALL2 Program SNDPGMMSG MSG('hi how r u') So how can i get the output as 'hi how r u shanmukha'...? can anyone help me out............ by Shanmukha

    Shanmukha5 pointsBadges:
  • Check expiry date of tape (using iSeries and BRMS)

    I am chasing a simple CL program to check if the currently loaded tape has the data as *expired so it can be written to under BRMS. It shouldn't be that hard but I've searched for literally days and can't find anyone to help.

    GarryS15 pointsBadges:
  • Customize Epson 9 pin with TRANSFORM(*NO)

    Greetings, is it possible to customize a Epson 9 pin connected to a PC with iSeries Access V5R4 with the TRANSFORM(*NO.)? I'm trying using a customization object (WSCST) and haven't had any positive results.

    AS400 - Ask the Expert485 pointsBadges:
  • How to use embedded SQL in a RPG program used as a stored procedure

    When I use embedded SQL in a RPG program and call it from another program it works fine. But, when I try to use the program as a stored procedure it gives me a SQL error. I have worked with stored procedures and understand them, but have not been successful using embedded SQL with them. Any ideas...

    Warykat20 pointsBadges:
  • Compare physical file data

    Hi, I am trying to compare data from two different physical files. Both the files are in the same format but from two different systems. I need a report or a file which compares the data in both the files and report the differences in a report or a physical file. Any toughts on this. I already...

    Reachme15 pointsBadges:
  • AS/400 CL Auto Reply to “Load Next Tape messages”

    Would like to auto reply to this message without amending the system reply list entries, rather just from within the Backup CLP itself.

    Techman965 pointsBadges:
  • iNavigator hangs on SMTP properties

    We have an iSeries running v5r2 and the latest release of client access. I need to change the binding of SMTP and this appears to only be available by Navigator. However Navigator hangs when I click the properties on SMTP. Any other way that I can change this binding to a new ip address?

    FrankStacey105 pointsBadges:
  • Installing old tape 7208 and new Iseries HW

    How can I install a 7208 to a 9407 M15 ?? or how can I read 8mm 7 GB tapes with a 9407-M15 ??

    Cramirez685 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