• Unicode on AS/400 RPGLE

    We are upgrading to 9.0 JD Edwards where the unicode tables have CCSID = 13488; I still need them to work with legacy files, CCSID = 37. How can I get these 2 types of tables to interact within RPGLE (V6R1M0).

    Normap2275 pointsBadges:
  • AS/400, Mac running Parallels & Windows 7, PC5250 Emulator iseries access PCSWS037 error

    I have a Mac Air running Parallels 7 and Windows 7 with PC5250 to access AS/400. I get a PCSWS037 error (Initialization of the keyboard table failed) when I connect. And also get the PCSKBD110 error (The system keyboard is not supported) when I start my session. Any help fixing this would be...

    solomonmark10 pointsBadges:
  • Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh48,405 pointsBadges:
  • CCSID 935 to CCSID 13488

    I have a file that is ccsid 935 containing some records with Chinese characters. I need to convert that file to its upgraded version that is ccsid 13488. (These are vendor files, therefore I have no control over their definitions.)  It is possible to simply copy the older file into the upgraded...

    Ckelly0120 pointsBadges:
  • Update causing reade to read the same record in RPGLE

    Hi Team, I have a critical issue. In RPGLE program, I have read a file then based on some condition I am updating the file if condition is not satisfied I am not updating that file. I am doing it in a do while loop. The issue I am facing is the record that has been updated is being read again....

    soundariya20 pointsBadges:
  • AS/400 print files stuck at RDY

    I am managing, but very unfamiliar with AS/400. I have a user who does not receive the printouts for her job. It looks as though the printouts are all stuck in RDY status on the Output Queue. If I look at our printers, there is a printer of the same name as the Output Queue. That printer is in END...

    HeyLeonardo5 pointsBadges:
  • User is unable to connect to AS/400.

    A user is trying to connect to AS/400 but keeps getting an error that he is unable to establish a connection with the server. Unable to connect to TCP/IP server.Winsock error 10061

    Shabari10 pointsBadges:
  • AS/400 Administration Training

    Can I download AS/400 to learn it? Is there a specific training I could use?

    JuliusWWalker5 pointsBadges:
  • Create user profile other than QSYS library

    Can we create user profile other than QSYS library or QSYS is default library for creating user profile?

    anand12345610 pointsBadges:
  • How to lock FTP user out of the rest of the IFS

    I have an FTP user that will upload files onto our box. When they connect they start in their /home/ folder. I want to make sure they can't get back to root '/' or anywhere else in the IFS. Preferably without creating a massive security maintenance workload as this expands.

    GregManzo95 pointsBadges:
  • iSeries mapped drive security

    I would like to set up a number of drives where user A can access folder A and User B can access folder B. Neither user can access the other users folder. I have tried making the folder authority specific to a user with public exclude. This has made not prevented access. I assume this is the...

    Fignon5 pointsBadges:
  • How to get AS/400 macro to pull data from Excel

    Hello I’m trying to create a macro on the AS/400 that will pull data from an Excel sheet and input data to the screen. I know how to create a macro to run the menu option by using the record macro button but not sure how to get it to access the excel file so it will run through the list.

    dluy688035 pointsBadges:
  • iSeries SQL0904 Resource limit exceeded

    I have written RPG/ILE stored procedures to validate and write data to various physical files with data extracted from MSSQL tables using SSIS and MS Visual Studio 2013 and utilizing the Native OLE DB\IBM DB2 for i IBMDA400 OLE DB Provider.  My problem the extract job fails when trying to import...

    JustJamesG5 pointsBadges:
  • Logical files in mimix are in *HLDERR

    How to troubleshoot and resolve, if the logical files are *HLDERR status.

    Praveen195 pointsBadges:
  • LPAR creation date in AS/400

    How to know the creation date and time of LPAR in AS/400?

    rupesh19945 pointsBadges:
  • How to see output for an AS/400 stored procedure

    I have created a CL which calls an RPG program. Now I have to create a stored procedure which calls the CL! As RPG normally sends back the output to CL! How should I send back the output to SP? Will SP normally pick it or is there any command to send back the output to stored procedure (SP). I have...

    bharathtata25 pointsBadges:
  • How to capture screen continuously for Rumba AS/400?

    I can capture each screen by clicking on option -> capture screen. Can I capture all displays or assign a short-cut key to capture the current screen?

    Wchang7215 pointsBadges:
  • Job Dependency across LPARS

    J1 scheduled to run in lpar - lets say L1 J2 scheduled to run in lpar - lets say L2 Here my requirement is J2 should start run after completion of J1. Can we make this dependency across the LPARS? I am using CA ESP tool to schedule the jobs.

    Manoranjani5 pointsBadges:
  • Difference between source physical file and physical file on AS/400

    What is AS/400? Difference between source physical file and physical file?

    AS400 - Ask the Expert485 pointsBadges:
  • IBM DB2 Rows-Records Limits

    IBM DB2 allows up to a maximum of 4.2 Billon rows or records in a table. (In AS/400, iSeries). MS SQL, Sybase SQL, Oracle, MySQL all allow way more. We know that with clusters IBM can handle more, but this doesn’t solve the problem in many cases (Requires Embedded SQL)… DB2/400 was supposed to...

    Florenjm180 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