1
  • AS/400: Check where output file is used as an Input

    We have a few important queries whose outputs form the basis of several (even hundreds) of other queries and reports. If we wanted to make a change in one of these main ones, is there a simple way to tell which other queries use it for an input? For example: Query: ABCD2014 Library: Lexample1...

    AmyBVOz15 pointsBadges:
  • How to write multiple SQLRPGLE records into a printer file

    C/EXEC SQL C+ SELECT DISTINCT(CTP),COUNT(*) INTO :$Ctp,:#Ctotl FROM CUSTPF C+ GROUP BY CTP C/END-EXEC CTP is CustomerType in Customer File. Here actually I am getting 3 records as output. But I don't know how to write those 3 records into a printer file. Can anybody explain me how to write the...

    Sasikumarr195 pointsBadges:
  • Printing Access Rights to an Outqueu

    I need to have a list of users that may access an outque. Alos, I need to know what privilidge does each user has to the outque.

    Mtimani5 pointsBadges:
  • Detaching spool file with AS/400 command

    Hi i want to detach job from a spool file . I tried CHGJOB SPLFACN(*DETACH) command but it detaches all the spool files for a specific job . My requirement is to detach a particular spool file from job . Please help

    munduuu435 pointsBadges:
  • Reconciliation of Input and Output file with same primary key but different values

    We do a recocciliation of input and processed output file. There is always instances where we have same primary key with 2 same different values in the output and input file. When i do amatching query, it returns 4 variances instead of just showing 2 variances of zero amounts. It shows extra 2...

    Lakeside19005 pointsBadges:
  • AS400 Query Output Font

    Here is the screen that I am working with: Define the Query Query . . . . . . : REFUND1.00 Option . . . . . : CHANGE Library . . . . : QS36F CCSID . . . . . . : 65535 Type options, press Enter. Press F21 to select all. 1=Select Opt Query Definition Option > Specify file selections > Define...

    lorit365 pointsBadges:
  • InfoPrint – Spool File to PDF mapping object

    have got spool file to pdf working using infoprint, stored in IFS and sent as email. Does anyone have example of mapping object so change directory path and name of pdf file when stored in ifs? System uses job name etc. which will be variable. Thanks

    annehill55 pointsBadges:
  • iseries as400 – Output Queue

    In iseries an output queue has a parameter to pick the printer Manufacturer type and model by pressing F4. This will have a list of lla the printers driver.Can anyone please tell me how or were to locate the physical file.

    SCDCJG20 pointsBadges:
  • Automatic transfer of AS400 output file to PC folder

    Is there a way to automatically transfer an output file to PC folder in an Excel form? My boss want me to create a CL program that every time the output file was created, it automatically convert that output file to Excel(numeric values in comma seperated) in a PC folder. I usually do this...

    Radycal45 pointsBadges:
  • How to remove printed spooled file from output que list

    We had several files that printed remain in either 'PND', 'WTR', or 'PRT' status. I ended the writer and was able to delete the ones in PND and WTR status. The file with PRT status remains. It does not affect printing other files. Tried vary off/on, stop/start writer, cleared printer buffer, turned...

    Kamari25 pointsBadges:
  • Moving output queues from QUSRSYS

    I am trying to move output queues from QUSRSYS, to Test and Production libraries, so that jobs that use these output queues can be separated. When there is a device description associated with the output queue, I am not able to move the object. The system says that I must delete the device...

    Mattheus55 pointsBadges:
  • How to see records in ALL Files to an OutFile

    I have a programmer that wants to see all Files in a specific library that have 0 records. I know I can do a dspfd on all files in a specific library but I can't display it to an outfile. I wanted to run a query over the outfile. Can someone offer any suggestions on which command or program I could...

    Alison88380 pointsBadges:
  • Identifying output files in query definitions

    How can one identify all/only output files in a list of query definitions (the list has over 1000 queries in it)? Executing in batch RUNQRY with parameter PRTDFN(*YES), in a loop for each query, then scanning the collective result, might theoretically do the job but doesn't work for queries in...

    22190165 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