Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.&SQL = CreateSQL("Select EFFORT_AMT from PS_
Posted: Sun Jun 11, 2023 3:56 pm
Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.&SQL = CreateSQL("Select EFFORT_AMT from PS_PSU_TASK_EFFORT whereTASK= :1", PSU_TASK_TBL.TASK);&Var1 = &SQL.Fetch(&Var2);Select the two correct statements. (Choose two.)
A. &Var2 specifies which row to fetch.
B. &Var2 specifies which field to fetch.
C. &Var1 is populated with TRUE if a row is fetched.
D. &Var1 is populated with the number of rows returned. E. &Var2 is populated with EFFORT_AMT from the row fetched. F. &Var1 is populated with EFFORT_AMT from the row fetched. G. &Var1 is populated with EFFORT_AMT from the first row returned.
A. &Var2 specifies which row to fetch.
B. &Var2 specifies which field to fetch.
C. &Var1 is populated with TRUE if a row is fetched.
D. &Var1 is populated with the number of rows returned. E. &Var2 is populated with EFFORT_AMT from the row fetched. F. &Var1 is populated with EFFORT_AMT from the row fetched. G. &Var1 is populated with EFFORT_AMT from the first row returned.