C Example 1
Set characteristics for a select search:
BOOL fOK;
int iSession;
fOK = LceSetSelectOptions(iSession, "*BACKWARDS, *MAXREC25");
fOK = LceRequestSelect(iSession, "SURNAME, SALARY", "PSLMST", "", FALSE);
fOK = LceReceiveSelect(iSession, "PSLMST");
fOK = LceGetRecordCount(iSession, "PSLMST", &iRecords);
for (iCount=0; iCount < iRecords; i++)
{
fOK = LceGetSelect(iSession, "PSLMST", iCount, "SURNAME, SALARY");
}
C Example 2
Lock a record during a fetch:
BOOL fOK;
int iSession;
fOK = LceSetSelectOptions(iSession, "*LOCK");
fOK = LceSetFieldValue(iSession, "EMPNO", "12345");
fOK = LceFetch(iSession, "SURNAME, GIVENAME", "PSLMST", "EMPNO");
C Example 3
Use *RECEIVEIMMED to Select Records:
BOOL fOK;
int iSession;
long lFlags;
fOK = LceSetSelectOptions(iSession, "*RECEIVEIMMED");
fOK = LceRequestSelect(iSession, "SURNAME, SALARY", "PSLMST", "", FALSE);
fOK = LceReceiveNextX(iSession,"",0,NULL,0);
fOK = LceGetFieldValueX(iSession, "SURNAME", strSurname, lFlags);
fOK = LceGetFieldValueX(iSession, "SALARY", strSalary, lFlags);
C Example 4
Use blocking by key:
BOOL fOK;
int iSession;
fOK = LceSetSelectOptions(iSession, "*BLOCKBYKEY");
fOK = LceRequestSelect(iSession, "SURNAME, SALARY", "PSLMST", "", FALSE);
fOK = LceReceiveSelect(iSession, "PSLMST");
fOK = LceGetRecordCount(iSession, "PSLMST", &iRecords);
for (iCount=0; iCount < iRecords; i++)
{
fOK = LceGetSelect(iSession, "PSLMST", iCount, "SURNAME, SALARY");
}