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

    Durgesh813370 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,445 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...

    Durgesh813370 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,445 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:
  • Opcode in RPG that retrieves current date

    Which opcode in RPG can be used to retrieve current date along with century?

    Vids295 pointsBadges:
  • Current date in DB2/400

    IN DB2/400, is there a field level keyword for showing the current date?

    JIJUKALLIATH5 pointsBadges:
  • Calling programs information in RPG

    I have RPG program which consists around 7,000 lines. Is there any way to see the calling programs from the main program. One way is to manually searching the calling program name in main program. But it also taking so much time to know. So is there any way or command to get the all calling program...

    sivakesava280 pointsBadges:
  • Converting a character to numeric

    In WRKQRY environment, what is the function that can be used to convert a string or character to numeric? By Sulaiman "Sem" Salomon Bernat

    SEMSBERNAT5 pointsBadges:
  • Stop and Start AS/400 TCP/IP

    How can I stop/start TCP/IP??

    ZOS5 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