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

[Former Member]

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

[former_member204746]

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.

[Former Member]

Hi Eric,

TSP03D was clear to me. But I had in my mind that there was a second table ....

(??) wasn´t it ??

Unfortunately R/3 Release 4.5B has to opp. to export devices..

Cheers Jörg

[former_member204746]

I cannot say for 4.5b.

try my command on a sandbox and see if this works.

[Former Member]

Just tried to use this sql-statement.

Now all printers in SPAD have this flag , but it does not work.

It seems that print still queries (just the same behaviour if the flag was NOT set !)

So I really think that there must be second table...

Cheers Jörg

[former_member204746]

have you resync'ed buffers or restarted your SAP instance?

[Former Member]

Yep,

commit on SQL and $SYNC in R/3 ...

[former_member204746]

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.