• Join between two tables in SQL/400

    ** Table 1 ** fld1 is 2A, fld2 is 3,0 & fld3 is 2A... ** Table2 ** fld1 is 7A and which is a combined result of fld1, fld2, fld3 from Table 1..... My requirement is, I would like to join the above tables using any join method and would like to list the records from table1 where all fields in...

    Varun123190 pointsBadges:
  • Improving performance using OPNQRYF

    I have a requirement that, in a country related code file. (CntryCode, Name, AccessNo) if these are three fields... and I would like to pass the respective country code and get only the required country values. But this is also taking time when using OPNQRYF with QRYSLT country code. Is there any...

    Varun123190 pointsBadges:
  • SELF JOIN

    Can anyone explain me SELF JOIN with example?

    Lsivabe85 pointsBadges:
  • How to vary on DSP01 when system is in Restricted state.

    The system is in restricted state and the operator who was trying to login into console DSP01 had disabled the DSP01 display device by giving incorrect password...how to login into the system? How can we vary on the DSP01? Significantly, these systems are connected to HMC. Is there an option to...

    IMisnothing130 pointsBadges:
  • F8 key in AS/400

    iSeries Access for Windows was recently installed on my PC. Would it be possible to customize the F8 key whereby when the F8 key is held down, it goes through the records continuously?!

    DIAS400Newbie40 pointsBadges:
  • IBM Linked server will not do inserts

    I've spent close to 2 days looking for an answer and only got a headache. We have our IBM DB2 linked server defined as IBM DB2 UDB for iSeries OLE DB Provider. We can run select, update and deletes we just cannot do an insert. Here are our sample statements. SELECT * FROM OPENQUERY(OUR_DB2,'SELECT...

    ToddN200011,100 pointsBadges:
  • Subfile, AS/400 and expanding subfile

    Why is SFLSIZ always 1 greater than SFLPAG in expanding subfile load method?

    Durgesh813370 pointsBadges:
  • RPG

    How to read distinct record through RPG?

    dwivediviv70 pointsBadges:
  • iSeries navigator 5.4 files

    We are using Windows 7 Pro now and the drives mapped thru the iSeries Navigator have files on them that are very slow to open. Is there a change I need to make to Windows 7 so these files open quicker.

    Quincy185 pointsBadges:
  • TN5250 Mochasoft on mobile devices

    Hi, Which is the cheapest mobile available on which we can use MS office with editing feature and download it from mail and after updating Word, Excel, PPTs etc. Send through email...it should also support TN5250 free Mochasoft for connecting to AS/400. Thanks

    6r1,520 pointsBadges:
  • Color problem in AS/400 Display File

    Hi.. I'm having problem in the display file. In display when I define any fields with Turquoise or Yellow its showing the field with underline. What will be the problem? I'm using IBM i Access for Windows Emulator and the Version is 6.0

    Sureyz2,410 pointsBadges:
  • Will vista and Windows 7 be compatible with old Client Access?

    My questions is from the time machine. We have an AS/400 installed in the last century(1999)  for Y2K software upgrade. The hardware and os400 is unbeatable. The ERP application is still very good. We have a lot of archival data and 7 users so there is little upgrade reasoning. My question is a...

    Shs65 pointsBadges:
  • AS/400 compatibility with Windows

    I want to know if AS/400 is compatible with any software like Windows Vista or earlier version of Windows.

    Ingridmirandanederbiel5 pointsBadges:
  • Flat file in an RPGLE program

    I am loading a flat file in an RPGLE program. The file will be downloaded to a server and converted to .txt and .dbf. The recipient, a benefits provider, states in the file specifications that their must be a carriage return/linefeed at the end of each record. Can you provide some direction on how...

    Crickett0 pointsBadges:
  • AS/400 menu that could be user specific

    Is there any way in which I can create a menu where the options can be user specific. Say in total there are 99 option present in the menu but I want the system to display particular 10 options to a particular user based on some criteria. Can this be handled though a menu in AS/400. And Can this be...

    Pgsdeb20 pointsBadges:
  • Seperate menu for user profile in AS/400

    How to create seperate menu for user profile in AS/400?

    Smile45 pointsBadges:
  • Stored procedure error in RPGLE program

    I've to use stored procedure in RPGLE program. My code is CallP     OESP_PORD_001(IPAT#:OPNXT#:PRJUK) I get error name or indicator not defined...I checked the library, parameters and everything are in place....Am I calling the SP with the right syntax? I tried to then change this whole using...

    Nutangujar895 pointsBadges:
  • Stored procedure from PRGLEV program

    Hi, I'm calling a stored procedure from RPGLEV program. I'm getting error pointer not set for location referenced. the SP has 3 parameters, numeric, numeric, Character my call stmt is CallP  SP_Prototype(num1:num2:Char1) The program crashes....any thoughts? thanks, NG

    Nutangujar895 pointsBadges:
  • Special instructions for PTF installation

    I am about to install PTF C719850(SF99530). The problem is it is my first PTF installation since we've got the system so we're very late. I want to know if there are special instructions that I should consider. Any help will be greatly appreciated. Thanks in advance.

    Mariel5 pointsBadges:
  • Install PTF separately on each LPAR

    Suppose my system contains 3 LPARS. I need to install PTF's on the server. So do I have to install PTF's separately on each lPAR or is primary enough

    itanswers0 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