• SQLRPGLE – problem with the like while using the wild card

    Hi all, I need your help in the Wild card search in SQLRPGLE. I'm entering the %XAS% in the display file screen field  and now based on the scan if I come across the field is with Wild card, I will use the like :Searchname in the SQLRPGLE code.

    ravula755 pointsBadges:
  • See consolidation of program

    How can I see the consolidation of my program? Do I use RPG, RPG ILE or CL to do so?

    monivaz30 pointsBadges:
  • SQLRPGLE Cursors and Recursion

    I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms    b      dprintPrograms    PI      d...

    Dcantwell480 pointsBadges:
  • Cache Battery Replacement

    We have a 9406 Model 170 that has a failing cache batter pack. We no longer carry maintenance on this particular machine so I'm going to have to replace the part myself. Can anyone guide me to information on how to perform this procedure? I'm not even sure where the cache battery is located or if...

    Jimmer0 pointsBadges:
  • How to compile and debug a program in COBOL AS/400

    How do I compile and debug a program in COBOL AS/400?

    kekuchi20 pointsBadges:
  • Cant delete file from Windows 7 OS

    I can delete folder from mapping drive on AS/400 Server in Windows XP OS, but same folder I cant delete on Windows 7 OS.

    jeevance5 pointsBadges:
  • Where to find AS/400 RPG concepts

    I need practice questions to brush up my AS/400 RPG concepts. Can anyone help?

    karandeep5 pointsBadges:
  • Send SMS to phone from iSeries

    How to send a SMS to a mobile phone or a pager from iSeries?

    poojaary85 pointsBadges:
  • MIMIX easy checks

    How can I do easy checks to prove my data is being replicated without doing a switch?

    dazkeyte55 pointsBadges:
  • Mimix replication from source to target

    Can I setup Mimix to replication from Source to target to target2? Or replicate from Prod to HA1 to HA2? Any help? Thanks.

    SpeedCoach120 pointsBadges:
  • AS/400 spool files in FIN status

    Is there a way to remove spool files in FIN status without ending the job that created them. I do a WRKUSRJOB USER(&USRCOD) STATUS(*ALL) OUTPUT(*PRINT) and then copy it to a file and then delete it using DLTSPLF FILE(QPDSPSBJ) SPLNBR(*LAST). It leaves the QPDSPSBJ in FIN status out there and...

    Dcarney120 pointsBadges:
  • AS/400 query: Extract character between two characters

    Is there a way to extract the number of character between 2 chars? I need to extract email addresses that are between <....@...> in a field that is 228 bytes long.

    nsmartello5 pointsBadges:
  • AS/400: Display installed AHC Products

    How do you access Product Control on the command line so you are able to display Installed AHC products? Thank you

    pwsmith5 pointsBadges:
  • Accessing an old AS/400 machine

    Hello, we got an old AS/400 machine (type 9401) that has not been powered on in several years. I have no clue on where to start to access it. Any ideas?

    MikayCiv15 pointsBadges:
  • Logical File key not working

    I am creating a new logical over a physical file. Very basic. Just one key field. It is a character file as the key. R RUB04000 PFILE(RUB0400F) K TRALER. After I create the logical file successfully and check the records, the records are NOT in the sequence as defined in the logical file DDS. I...

    Philcards15 pointsBadges:
  • PASE for i already running in this job

    We have an RPGLE PGM that executes the following to establish a connection to another servers database and it works fine. DBcomm = JDBC_Connect(%TRIM(DriverName):%TRIM(ConnectionString):%TRIM(userid):%TRIM(Password) ); This statement starts running PASE. When the same user in the same job that just...

    Gman7325 pointsBadges:
  • How to detect who changed source code on AS/400 machine

    Hello, I have a small problem with Cobol ILE source code. I would like detect who changed source code on AS/400 machine (user). Do you have some experience? Best regards. M.

    Maxfx12315 pointsBadges:
  • Creating shortcut commands in AS/400

    Hi, I want to create a shortcut command for wrkmbrpdm command in my AS/400 platform. i have done like this: 1. wrkmbrpdm libraryname/member name 2. Shift F4 3. Created a user - defined function (as w1 for wrkmbrpdm) But an error throws w1 not found in *libl . Please somebody can help me out on...

    Sangay635 pointsBadges:
  • How to archive the old changes in Thenon

    Is there a way for me to archive the old changes in Thenon (IBM i change management software)?

    itfrng20 pointsBadges:
  • How are QSQSVCDMP reports read?

    Like most dumps the column with any pertinent data does not show any error that I can read.

    JeanDriscoll5 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