• Writing Information to the JobLog

    I've seen a number of snippets here and there on the internet regarding the ability to write specific information to the job log in order to figure out exact problems, based on the conditions placed within. I've seen reference being made to some API, but have been unable to actually find useful...

    Eric Witham690 pointsBadges:
  • What causes space offset error in RPGLE?

    Can anyone tell me what this means? I'm getting this on a CHAIN to an externally described file in a called RPGLE program. Space offset X'00000000' or X'000000000020A0AA' is outside current limit for object JOBNAME USERID 123456. Internal failure in compiler or subroutine.

    baumgardnd50 pointsBadges:
  • Using Query/400 to create SQL-style GROUP BY

    Greetings and salutations, I'm trying to put together a query for one of my users to track sales numbers and it is starting to give me a headache. I've put together a query using Query/400 with a break at each invoice to sum the dollar amount for each one. The issue is that on many of our invoices,...

    Kyoojin0 pointsBadges:
  • SQL/400 field editing

    What is the best (easiest!!) way to add editing to fields in an SQL-created table?

    DanTheDane2,555 pointsBadges:
  • Running the API (QUSLSPL) List Spool FIles

    I have downloaded an RPG example program where the program creates a user space with the API (QUSCRTUS) and then calls the API (QUSLSPL) to list spool files. This program runs fine I run it for *CURRENT as the user parm. I want to run it for *ALL users to get a list of all spool files on our system...

    ISERIESTECH135 pointsBadges:
  • PDF Mapping Program Email Activity Log in iSeries

    Using PDF Mapping program as the PDF User Program in a PSFCFG object. Modified program to write a log when an email with PDF attachment is created. Program is called from within PSFCFG twice each time - but I only need one record, anyone have any suggestions or has anyone resolved this problem in...

    Kdbwheels180 pointsBadges:
  • Track total batch jobs per jobq daily

    Is there a function to track the total number of Batch jobs run per jobq on a daily basis? I don't see anything in collection services and we do not have PM.

    Whatis235,665 pointsBadges:
  • Subfile with CL/400

    How can I declare a file in the CL/400?

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

    chowas400615 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:
  • 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:
  • 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:
  • 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,775 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...

    Supriyoas400190 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