Can you use a Variable in (Library/File) in this format

[Rounak]

If my 1) Lib IS A FIELD NAME AND THAT FIELD CONTAIN LIBRARY LIST
2) Fil IS A FIELD NAME AND THAT FIELD CONTAIN FILE NAME LIST
Then hOw can I use this in SQLRPGLE code

CNT = VARIABLE
ORD IS FIELD NAME IN PHYSICAL FILE
ORDERNO IS NAME OF INPUT FIELD ON DISPLAY FILE


C/EXEC SQL
C+ SELECT COUNT(*) INTO :CNT FROM LIB/FIL
C+ WHERE ORD= :ORDERNO
C/END-EXEC

PROBLEM= I WANT THE VARIABLE INSIDE OF LIB AND FIL TO SELECT BUT IT IS SELECTING LIB AND FIL

PLEASE HEPL ME TO SOLVE THIS PROBLEM

 

[Summer_Moon]

You need to setup a SQL prepared statement and have your statement be in a character string.

IBM Dynamic SQL