• READE & SETLL

    File: exam .................. No . name .................. 2 chow 2 siva 3 mical 4 swami 4 radha 2 lord .................. I need only equal records: 2-chow,2-siva,2-lord but I got the wrong output:2-chow, 2-siva,2-lord, 2-lord. it's reading the last rec 2 times. Please correct the below code. And...

    chowas400585 pointsBadges:
  • Microsoft Office & AS/400 Database

    I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.

    Lshipley515 pointsBadges:
  • Adding and updating physical file

    I have a physical file with no key. I want to add new record to it and if record is added if I want to update it. How can I do it without a key?

    supreet8515 pointsBadges:
  • PF in Cobol program

    I am currently working on a Cobol program, on a AS/400, where I had to revise the PF layout and made adjustments to the source program and compiled it. Problem is, the program is still picking up the 'old' PF layout instead of the newly revised layout? Any thoughts or suggestions that I missed? I...

    Bigdogg5 pointsBadges:
  • Libraries and Journals

    1) Can you have more than one instance running on a system at a time? 2) Can a library be defined in multiple Data Groups? 3) Can a Data Group be attached to more than one journal? 4) Can a journal be defined to more than one Data Group? 5) Do you have to switch all Data Groups at one time? 6)...

    jmurfitt45 pointsBadges:
  • Run six CL programs

    Hello, I want to run 6 CL programs in a manner that when first two (Say A and B) successfully completed then C&D should start and once C&D is completed E&F should start processing.

    CLUSER20 pointsBadges:
  • User Exit Point Programs

    Hi I developed a user exit program, but, it only works when I do FTP from an AS/400 green screen. If I run FTP from my PC, I can log in as any user. (Not even sure if my exit program gets executed from a PC. It is in library QGPL. Thanks for your assistance! Sincerely Nick

    Piano520 pointsBadges:
  • What are the main functionalities of ovrdbf?

    What are the main functionalities of ovrdbf?

    Zilan85 pointsBadges:
  • Auto Refresh page with server time counting in RPGLE program

    I successfully completed auto refresh page with server time counting in RPGLE program. While run my program, some times i got the below error... I/O error CPF4737 was detected in file AUTODSP (C G D F). i share my display coding and rpgle coding below Display file coding..  A              ...

    pdsathishkumar3,790 pointsBadges:
  • Telnet CL program on AS/400

    Does anyone know if it is possible to write a CL or RPG program that will automate a telnet session to a second device to change data? I have a multiple fuel controllers that I need to telnet into daily and change the current fuel price. I would like to automate this. Does any onw know how to do it...

    wkozerski20 pointsBadges:
  • Make text in ZPL label bold or underlined?

    Due to a new EU law every food packaging label has to outline possible allergy-causing ingredients by either styling them bold or underlined in the ingredients list. Currently I'm printing my labels via ZPL to zebra printers. I checked the ZPL manual 1 & 2 and didn't find way how to print...

    blind4x25 pointsBadges:
  • CL Program: Assing select to the variable

    Hi, I have some trouble with my CL Program. Please help me. I have a table like: System name User name Job name tstname1c TOMCATTOMT TOMCATTOM1 ....................... ....................... ....................... tstname1a BOBCATBOBB BOBCATBOB2 ....................... ..........................

    Motorbreath40 pointsBadges:
  • SUBFILE – To read only the UNCHANGED RECORD

    Hi, please help me with the logic how can I read the subfile when the record is not changed. (The user did not touch or crossed the subfile of particular record). How can I deal with that? After searching, I came to know we can achieve only with SFLNXTCHG keyword. But I don't how to proceed with...

    srivijay1190 pointsBadges:
  • Calling API program in RPG

    Hi all, We are about to celebrate silver jubilee of our RPG code, although I am with it since last one year. My question is, in one of our code file there is a call to a program with several parameters. In comments it is written "API call". Where I can find this API. I have tried a lot but couldn't...

    hunshabbir72,485 pointsBadges:
  • Stop AS/400 job purge program

    I have a requirement where i have to submit a PGM in batch. This program is a SQLRPGLE program that deletes record from a file. I have scheduled it at 8pm and I want to stop its purging at 10pm. This means this job will run for 2 hours every day after which it should be stopped. How can I achieve...

    Supriyoas400180 pointsBadges:
  • AS/400 batch jobs

    In a PF, if we delete a record then how to insert a new record at the same place in that PF? Any logic or code? A batch job is taking a lot of time to run,found that it is going into loop and wrapping up so how to skip that loop and process the job without changing the code? In which scenario C D I...

    chowas400585 pointsBadges:
  • In RPGLE, how to fetch the particular record in 1 lakh record without a key

    Hi, I have some 1 lakh record. I need to fetch from 250th record with no key in it. What is the possible optimed way we can achieve it.

    KirManoj15 pointsBadges:
  • DB2/400-AS/400

    File:Student ................. SID     . Sname . ................. 1       .  Chow . 2       .  Ratna. ................. I want to update sname= Rotna(2nd position a=o) using substring? Please help the query or correct the below query: UPDATE STUDENT SET SNAME=SUBSTR(SNAME, 2,1)...

    chowas400585 pointsBadges:
  • Increase TCP/IP buffer size for AS/400

    I want to increase TCP send and receive buffer size in AS/400. How can I do that?

    Maltaf65 pointsBadges:
  • Remove library from all library lists

    We've stopped using a vendor's product that has been here since we first became a 400 shop 12+ years ago. The vendor's libraries have found their way into hundreds of job descriptions across the system. Is there an easy way to remove the entries for these libraries from all the job descriptions?...

    ERICPELL5 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