Cannot delete logical

[Dario Karlen]

Hi there
I have a problem to delete a logical. When I do a global "show logical" it displays the logical:
"lock_wal_tap_test " = "123", but when I do a "show logical lock_wal_tap_test*" it can't find anything, it says
%SHOW-S-NOTRAN, no translation for logical name LOCK_WAL_TAP_TEST*.
when I try to translate the logical in a program it works fine. but when I try to delete this logical with SYS$DELLNM it displays %SYSTEM-F-NOLOGNAM, no logical name match. the table name is the right one.
thanks, dario

[Joseph Huber_1 · Accepted solution]

Is it a typo ? You display the logical name in lower case with the wildcard "show logical". is it really lowercase ? If yes, the You have to include it in string quotes "lock_wal_tap_test " in all DCL commands using it:

$ show logical "lock_wal_tap_test "
$ write sys$output f$trnlnm("lock_wal_tap_test ")

[Kris Clippeleyr]

Dario,
Logical names & their equivalences are definitely case sensitive.
E.g.
DEFINE ME "me_UPPERcase"
DEFINE "me" "me_lowercase"
SHOW LOG me
"ME" = "me_UPPERcase"
SET PROCESS/CASE=SENS
SHOW LOG "me"
"me" = "me_lowercase"

Hope this helps,
Kris (aka Qkcl)

[Dario Karlen]

jup, this works, it was the fault with the string quotes and case sensitive.
thanks a lot guys....