Showing posts with label Display the long name from translate table and display it output in SQR. Show all posts
Showing posts with label Display the long name from translate table and display it output in SQR. Show all posts

Wednesday, May 5, 2010

To display the long name from translate table and display it output in SQR

To display the long name from translate table and display it output in SQR

To display the long name from translate table and display it output in SQR

BEGIN-SELECT
XLATLONGNAME (,132)
FROM
PSXLATITEM
WHERE
FIELDVALUE = &RELATION
AND FIELDNAME = 'RELATIONSHIP'
END-SELECT
(Note:Call it in a procedure)