Skip to Content
author's profile photo
Former Member

OSDB Migration: How to set the flag "Do not query host spooler for output..

Hello,

we are migrating a large DB with about 1000 printers which have access method "L".

Does anybody know how to set the flag "Do not query host spooler for output status" for every printer in a short time and not manually for each printer in transaction "spad" in the target environment ??

(e.g. short SQL-script on os-level ??)

cheers,

Joerg

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on Aug 21, 2007 at 12:56 PM

    table is TSP03D

    fieldname is PANOQUERY

    sql:

    update sapr3.tsp03d set PANOQUERY='X';

    commit;

    better re-sync buffers or restart SAP (/$SYNC)

    or you can export printer definitions:

    SPAD -> Utilies -> for output deive -> export device

    export in to a file, edit file and do a search and replace on:

    source: PANOQUERY = ""

    destination: PANOQUERY = "X"

    save file, and re-import.

    hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • well, I would change back one printer to the previous value, then, start an SQL trace on your user and change this back to X.

      then investigate SQL commands. I cannot do this on my system as it is not running on 4.5b.