GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Peoplesoft  >  SQR
Go To First  |  Previous Question  |  Next Question 
 SQR  |  Question 23 of 27    Print  
Can we call two Procedures in On-Break? If yes Then How?

  
Total Answers and Comments: 2 Last Update: September 23, 2009     Asked by: v.rajesh 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 26, 2007 06:40:12   #1  
freakydipu Member Since: December 2007   Contribution: 1    

RE: Can we call two Procedures in On-Break? If yes Then How?
By using both after and before option in on-break.

Ex. on-break print none before procedure 1(arg1 arg2 ....) after precedure2

 
Is this answer useful? Yes | No
September 23, 2009 13:50:01   #2  
shyampeoplesoft Member Since: September 2009   Contribution: 1    

RE: Can we call two Procedures in On-Break? If yes Then How?
I think this example may help you

begin-heading 4

print $current-date (1 1) Edit 'Mon-DD-YYYY'
print 'EMPLID' (3 1)
print 'COUNTRY' ( 10)
print 'STATE' ( 17)
print 'CITY' ( 26)
print '-' (4 1 9) fill
print '-' (4 11 80) fill

end-heading

begin-program

begin-select

EMPLID ( 1)
COUNTRY ( 10) ON-BREAK LEVEL 1 after a before aa
STATE ( 17) ON-BREAK LEVEL 2 after b before bb
CITY ( 26) ON-BREAK LEVEL 3 after c before cc

next-listing skiplines 1 need 4

from PS_ADDRESSES
end-select

end-program

begin-procedure a
print 'AFTER Procedure for COUNTRY LEVEL 1' (+1 40)
end-procedure
begin-procedure b
print 'AFTER Procedure STATE LEVEL 2' (+1 40)
end-procedure
begin-procedure c
print 'AFTER Procedure CITY LEVEL 3' (+1 40)
end-procedure
begin-procedure aa
print 'BEFORE Procedure COUNTRY LEVEL 1' (+1 40)
end-procedure
begin-procedure bb
print 'BEFORE Procedure STATE LEVEL 2' (+1 40)
end-procedure
begin-procedure cc
print 'BEFORE Procedure CITY LEVEL 3' (+1 40)
end-procedure



begin-footing 1
! print Page n of m in the footing
page-number (1 1) 'Page '
last-page () ' of '
end-footing

 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : Yes. It is similar to use function, procedure and packages in SQR. The only difference is - Use begin-Sql Begin procedure(param1,param2) End End-Sql ...

Latest Answer : I think this example may help youbegin-heading 4print $current-date (1,1) Edit 'Mon-DD-YYYY'print 'EMPLID' (3,1)print 'COUNTRY' (,10)print 'STATE' (,17)print 'CITY' (,26)print '-' (4,1,9) fillprint '-' (4,11,80) fillend-headingbegin-programbegin-selectEMPLID ...
Read Answers (2) | Asked by : v.rajesh


 Sponsored Links

 
Related Articles

What are the differences between stored procedures and triggers?

Stored procedures are compiled collection of programs or SQL statements that live in the database. A stored procedure can access and modify data present in many tables. Also a stored procedure is not associated with any particular database object. But triggers are event-driven special procedures whi
 

How does the function call within function get evaluated?

Whenever we have more than one function which is called for a finite number of times then such a function gets evaluated from inside out. Let us understand this concept with an example. For instance consider a function sample called within it 4 times as given in program below: main() { int a=50;
 

How to call C header that is not provided generally by system in C++?

Headers can be called by using extern C Syntax of extern C is: extern "C" <function declaration> for example to call C functions from C++ we can write extern "C" { <function declaration> <function declaration> ...
 

What is difference between call by value and call by reference in function?

The arguments passed to function can be of two types 1. Values passed 2. Address passed The first type refers to call by value and the second type refers to call by reference. For instance consider program1 main() { int x=50, y=70; interchange(x,y); printf(“x=%d y=%d”,x,
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While
 

HR Interview - Behavioral HR Interviews

Behavioral HR Interviews As the name implies a behavioral interview is an interview that is held by a human resources department to determine if an applicant has the behaviors that are appropriate for a job The company must know how an applicant will behave in a certain situations mosgoogle The logi
 

HR Interview - How To Prepare For Your HR Interview

How To Prepare For Your HR Interview Before you begin thinking about how you are going to dress for the interview it is important to do your research first You should learn everything you can about the company you wish to work for When you have detailed information about your employer you will conve
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape