• Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh48,375 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:
  • Running AS/400 query in Specific job queue

    Is there a way to restrict user(s) to submit their queries to a specific job queue instead of going into qbatch?

    Msatbh110 pointsBadges:
  • How does equal to operator work in RPGLE free format when v compare file field with constant value.

    I have a file field which has values 'X' or 'Y' and it is of 10 length. Chain f1:f2:f3 filename if %found filename if f4 = 'X' In free format RPGLE when I tried to compare it fails even though value of f4 is ' X' . Note: f4 is of 10length. Work around is trimming F4 before equating but I would...

    NicyChn135 pointsBadges:
  • Error message when compiling CL program: CPD085C 40 Graphic field not allowed for variable & OBJRTVUCS

    Graphic field not allowed for CPD085C 40 Graphic field not allowed for variable & OBJRTVUCS is the error message I get when compiling CL Program. I'm taking output to file of a Vision WRKDG command. This ouput file I declare in the CLP.  While compiling the CL, I'm getting error 40 with...

    JohnsonMumbai1,360 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