managment librairies list for librairies product with SQL *SYS Convention Name

When you use a select in SQL without qualification and SQL naming *SYS, you use the library list possibilities

with a litle different *PRDLIB

i have a command

CMD PROMPT('test mycmd') PRDLIB(MYLIB)

a program associate to thic command

pgm

call qcmd

strsql

call qcmd

endpgm

==> dsplibl

QSYS SYS

QSYS2 SYS

QHLPSYS SYS

QUSRSYS SYS

MYLIB PRD <====

environnement SQL namming *SYS

STRSQL

==>select * from myfile

MYFILE de type *FILE dans *LIBL non trouvé.

environnement IBMI

==> dsppfm mylib/myfile

Membre de fichier physique

Fichier . . . . : MYFILE Bibliothèque . . : MYLIB

Membre . . . . . : MYFILE Enregistrement . : 1

Contrôle . . . . . Colonne . . . . : 1

Recherche . . . .

*...+....1....+....2....+....3...

Test 1 ███

Test 2 ███

****** FIN DES DONNEES ******

Comclusion :

sql ignore library type prod in a *LIBL

my request is to have the same result in SQL AS a ibmi command