I think this is going to require more detail than you have provided. Are you sure the DoSelect is returning data? Also, iis the Active Checkbox for the section checked?

Thank you oddsnends ...

DoSelect is returning data and Active checkbox is checked.

My question is how can we skip an entire section (section A in the above note), based on some condition in PeopleCode action within Section A.

Supppose the code in Section A: PeopleCode action is:

If &Num = 999 Then
Proceed to the next row in the doselect in Section Main, withoout executing the SQL action in the Section A.
End-if;

Hope this makes the query simpler! Pls help...

I'm a bit new to the App Engine

Could you try using the built-In exit()

If &Num = 999 Then
exit (1); /*Proceed to the next row in the doselect in Section Main, withoout executing the SQL action in the Section A.*/
End-if;

Let us know if that works.

Why don't you have the SQL action as a separate section (section B) and if the condition is ok in your peoplecode then call section B from within your code, if not, then don't call section B ( section B will be the one containing your SQL)

Thanks All.

If &Num = 999 Then
Return 1;
End-if;

And also we will check the On Return property of PeopleCode Section to - Break.

As per PeopleBook, On Return property of PeopleCode Section will be activated only on encoutering Return 1 or exit 1 in the peoplecode. The program exits the current step and section, and control returns to the calling step.

Thanks oddsnends again for your help.

And Lepa, I would prefer some peopleCode techniques, rather than changing the AE program structure, since it is OOB AE. Thanks...

I will apply this and let you know the outcome!

just curious to know, what is OOB AE? may be this is a stupid question.. but i really dont know what it is..

OOB means Out of the Box. OOB Application Engine is something that is PeopleSoft delivered AE.

in which Product Suite?
HR? Financials?

It may not be restricted to any product suit!

And friends, my issue is resolved!.
1. Changed the Peoplecode action - On Return property to BREAK.

2. People code is
If &Num = 999 Then
Exit(1);
End-if;

Now everyhting works as expected.

Thank you so much for your responses!!!

Dear Manku,
Your answers were really very beneficial, not only did they solve my problem( the same one actually) but i could understand the logic too.. A note of thanks....