• Problem with the syntax of OPNQRY command

    Hi I have a problem with the syntax of OPNQRY command I am getting values from a display file using RCVF and then using the qryslt parameter in OPNQRY to select a few records;See the command below OPNQRYF FILE((*LIBL/APH *FIRST *ONLY)) + QRYSLT('APCMPY *EQ ''*CAT XPCMP *CAT''') Where XPCMP(numeric)...

    itanswers0 pointsBadges:
  • iSeries navigator error message

    I am having problem opening navigator. I have v5r3 service S128055 error cwbunnav.exe when opening. Any assistance is needed.

    Diego20 pointsBadges:
  • Record Locking using a COBOL program

    From a COBOL program I an reading a random access file and occasionally try to read a locked record. What can I do to speed up the read so I can just present a popup screen that tells the user he is trying to access a locked record. Right now it takes 60 secs to time out from the read attempt...

    Pbrown01080 pointsBadges:
  • Record Locking in RPGLE

    I'm using embedded SQL to delete (clear) all records in a file. I do not want more than 1 person in this file. So when the user executes the program it runs the SQL and clears the records in the file. Now I want to do some file/record checking logic to see if the file is locked to another job. Then...

    RonKoontz1,780 pointsBadges:
  • How to get the maximum access path size value in a program?

    Hi Friends, My requirement is to get the Maximum access Path size value in the program, I have the value asĀ 1TB and 4GB in 2 different PF in different machine by DSPFD command. But I could not get the details when I OUTFILE using DSPFD, Even I tried RTVOBJD, RTVMBRD, I could not find it or I may...

    as400dev590 pointsBadges:
  • SETLL

    Hi, I want to read a physical file sequentially. The physical file has no key. I use SETLL and READ. *LOVAL is not allowed when I use SETLL (because no key in the pf?) so I set a 1 in factor 1. 1 SETLL READ 90 *IN90 IFEQ *ON ... Is this ok? When I have a key in the file could I then use the...

    withcareandsoon5 pointsBadges:
  • NULL value in physical file

    I am a beginner in AS/400 and learning through some tutorials, I came with a problem of how to add a NULL value in physical file. The spaces can't do the work, as even spaces have a ASCII value. Please respond with possible solutions.

    Durgesh813375 pointsBadges:
  • AS/400-Array

    Hi, could someone tell me what are array related errors (most of problems are loaded file, etc,,,)?

    AS190 pointsBadges:
  • DB2 WebQuery for System i problem

    Hi! Our server has already installed with DB2 web query. I have checked the basic things in licensed programs like QWEBQRC77(*lib) , MRADMIN(*usrprf)...everything is there. But when I try to start web query, the command is not available and also in license programs the web query shown like...

    Sureyz2,825 pointsBadges:
  • Journal Size in AS/400

    Hi, I am looking for a command which can give the journal size (ie object type *JRN) in AS/400. Thanks!

    Atti123135 pointsBadges:
  • AS/400 to SAP change

    I have 3+ years of exp in AS/400 development. I want to change my technology to SAP. 1) Which module should I go for? 2) How hard is to sustain if change? 3) Planning for SAP training? Module? 4) Do I need to be SAP certified? Need your answer as quick as possible. Thanks!

    bhabani201310 pointsBadges:
  • FTP query definition to another AS/400 server

    I have a QRY in one of the system. but, I don't have this on other system where I wanted to populate the results using the QRY that runs on system1. Thought of FTP'ing QRYDFN to other AS/400...though we have QRY object in library on system1, while FTP'g says no such file found in library xyz.. How...

    IMisnothing130 pointsBadges:
  • OVRDBF example

    I have been asked to prepare a small project in which we use a display file and and physical files. Now, I have to create a COBOL/400 program in which the user enters that name of the physical file and according to the name I have to enter empid and empname in that particular physical file. Now for...

    Durgesh813375 pointsBadges:
  • Delete USRPRF in AS/400

    Hi all! What are the condition or things should be notified or should be made when deleting a user profile from AS/400? Our application using the USERNAME in master. But i think only its saving the USERNAME in the MASTER PF. If I delete a user profile will it affect somewhere? How can I check these...

    Sureyz2,825 pointsBadges:
  • Calculate Distance between cities using latitude and longitude

    We currently have a program that returns a locations latitude and longitude. Searching the web I've located an RPG program that calculates the distance between 2 locations however it gives me the miles using a straight line. When I search Google maps it shows me the distance in miles using the...

    filuphaze475 pointsBadges:
  • Using CVTPFXLS to convert a datafile

    Can anyone help here please. I am using the CVTPFXLS command to convert a datafile to xls but the negative packed fields are not getting translated correctly. The negative signs are dropping out. Cannot see any options on the command. Cheers!

    tjgm88995 pointsBadges:
  • STRSQL command

    Can you use the STRSQL command within an AS/400 CL program?

    Pb5410 pointsBadges:
  • STRSQL query

    I need to know how to get the record count for a particular year. the date field is in YYYYMMDD format. I tried the query select SUBSTR(PLGLDT,0,4) AS YEAR, COUNT(*) AS "RECORD COUNT" FROM BPCSF60/APL GROUP BY SUBSTR(PLGLDT,0,4) ORDER BY SUBSTR(PLGLDT,0,4) DESC. But I am getting error "Argument 2...

    vibgyor280 pointsBadges:
  • AS/400 query by date

    How can I search a iSeries query by date?

    STCA60 pointsBadges:
  • AS/400 query for logical file

    I have one join file and one logical file. It is possible to create logical file on join logical file?

    anupsshelke420 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