How can I query the member name instead member type name?

Nageeb

Member
This is the SELECT query i am using to get the DataStructureCode (SIMD), DataStructureName (SIDSTNM), SubFunctionName (SIFCTNM)

"SELECT A.SIMD, B.SIDSTNM, B.SIFCTNM FROM "
+ dbSystemId + ".F9860 A,"
+ dbSystemId + ".F9862 B WHERE B.SIOBNM ='"
+ sFunctionCode + "' AND B.SIOBNM = A.SIOBNM AND "
+ "A.SISY = '" + sModuleCode
+ "' AND A.SIFUNO = 'BSFN'";

and
This is the query for the datablob after getting the DataStructureName
"SELECT DTERBLOB FROM " + dbDevId + ".F98743 WHERE DTOBNM = '" + DataStructureName + "'";


Where can i find the full field names description?

Thanks
Nageeb
 
Back
Top