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

    sivakesava285 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:
  • Error while using STRSQL

    When I run the following command I get an error while using STRSQL. Is this a valid statement or am I losing my mind. select right(gmans, 5) from f0901 (This is the error I get) RIGHT in *LIBL type *N not found. If I use the "Left" command it works fine.

    Rontracie0 pointsBadges:
  • AS/400 overlay form problem

    Hello, I have had to change an overlay (specifically a phone number created) in Microsoft Word 2003. I have uploaded the .prn to the AS/400 and created the overlay. However when I run the program to print the overlay form the data has shifted out of alignment mainly down and to the left! Can...

    Aliw10 pointsBadges:
  • AS/400 Overlay Problem

    I need to change the wording in an overlay, how do I get the printer to recognize the new updated overlay?

    jdw20 pointsBadges:
  • How can I make sure all new and changed objects are being backed up when using the SAVCHGOBJ command?

    Our current backup procedures include a full system save once a week (SAT) and two daily save change object processes (M-F). Yesterday a new library added on Monday was deleted by accident. When trying to restore it from one of the daily tape backups which was done using the SAVCHGOBJ command it...

    Showme35 pointsBadges:
  • QMQRY!

    How can we run multiple select/update query via a single QMQRY?

    sgautam11110 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