Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.&SQL = CreateSQL("Select EFFORT_AMT from PS_

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.&SQL = CreateSQL("Select EFFORT_AMT from PS_

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply