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
"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