1
  • iSeries database update via CL

    Hi! I have an iSeries database table that has a column name JOBQ. I want to update all records with JOBQ value QBATCH into 2 different jobq names for alternate records. I'm a CL programmer and looking for an example of updating a column via SQL that I can call from my CL in a loop.

    SundarNVS5 pointsBadges:
  • JOBQ and JOBD in AS/400

    What is the use of JOBQ and JOBD? What is the difference between JOBD and SBSD (Subsystem Description)? If we don't use the ADDJOBQE, where (in which subsystem) will the created JOBQ be stored?

    Sureyz2,420 pointsBadges:
  • Find the SBS allocated to the jobq when the sbs is inactive

    We had a situation where we have to find SBS allocated to the JOBQ when the system is restricted. What should we do?

    Dinnu360 pointsBadges:
  • Submitting the same Job from multiple users to a single threaded jobq. Output from one job going to another jobs printer?

    We have a Work Order Create program that gets invoked by multiple users multiple times throughout the day. The jobs are submitted to a jobq that is single threaded. Within the calling CL there is a SBMJOB of a secondary job that also gets submitted to the same single threaded jobq. The problem is...

    angelina22210 pointsBadges:
  • QSPRJOBQ

    I would like to use the QSPRJOBQ api to see if jobq QNIGHT is empty and on hold. Can I please see a CL example?

    mjntwnas40015 pointsBadges:
  • Listing profiles per jobq

    Hello, I would need to have a list of profiles with the same jobq, this is in order to balance the profiles with the same jobq. Is there any way to do that fast? Thanks Saludos/Best regards.

    Jfpuntel19635 pointsBadges:
  • How to retrieve the jobq in which my current job is running in CL?

    I have a CL program which will run as a SBMJOB. Now I want to see whether it is running in QBATCH jobq. If not in QBATCH, I have to resubmit it into QBATCH. How I can do it in CL?

    JustinA40 pointsBadges:
  • Is there a way to tell who held a job queue on the AS/400?

    Our night shift discovered a job queue on hold with a number of jobs that should have run earlier in the evening. Is there any way to determine when the queue was held and by whom?

    EileenNJ20 pointsBadges:
  • How can i know the Total Number jobs fired from Particular JOBQ in a day?

    I want to know the number of jobs released from particular JOBQ in specific time interval.

    Harish.kuolkhere190 pointsBadges:
  • Wrong job queue

    a job is going to the incorrect jobq, how to change this?

    Tess15 pointsBadges:
  • AS/400 compile options

    Hi team.. I forgot how to do this... Where do i change the outq so that when I compile a pgm, the compile report goes to a sepcific outq? right now it defaults to PRT01.

    Svocal120 pointsBadges:
  • Determine JOBQ from an active Batch Job

    How do you determine the JOBQ that an active batch job is running from? I have submitted a job to a specific jobq. This job will submitt other jobs. I want the other jobs to run from the same jobq that the main job was run from. I don't want to hard code the jobq name.

    SteveLOGAN10 pointsBadges:
  • jobq entries

    Is there a limit to the number of jobs set to run in a jobq? I have a program that reads a file of LT 1500 rcds and there is the potential that all of those records could be submitted to run in batch. Thinking about the future, I suppose there could be close to 3000 one day.

    Brenger170 pointsBadges:
1

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