GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Peoplesoft  >  PeopleTools
Go To First  |  Previous Question  |  Next Question 
 PeopleTools  |  Question 38 of 39    Print  
Can the output of a sql query be stored in a variable using peoplecode?if so how it be done?
i want to store the output of a query say

select EMPLID from Job;

the output of this column should be stored in a variable. how it can be done?



  
Total Answers and Comments: 1 Last Update: November 12, 2008     Asked by: ksllavanya 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: psft1017
 
You can use SQLExec to do the same.

SQLExec("SELECT EMPLID FROM JOB",&Emplid);

The value of EMPLID gets stored in the variable &Emplid.

Above answer was rated as good by the following members:
chini009
November 12, 2008 02:10:44   #1  
psft1017 Member Since: November 2008   Contribution: 1    

RE: Can the output of a sql query be stored in a variable using peoplecode?if so how it be done?
You can use SQLExec to do the same.

SQLExec("SELECT EMPLID FROM JOB" &Emplid);

The value of EMPLID gets stored in the variable &Emplid.

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    

 Related Questions

i want to store the output of a query say select EMPLID from Job;the output of this column should be stored in a variable. how it can be done? 
Latest Answer : You can use SQLExec to do the same.SQLExec("SELECT EMPLID FROM JOB",&Emplid);The value of EMPLID gets stored in the variable &Emplid. ...


 Sponsored Links

 
Related Articles

C++ Standard Input Output Stream

C Standard Input Output Stream In this C tutorial you will learn about standard input stream and standard output stream explained along with syntax and examples C programming language uses the concept of streams to perform input and output operations using the keyboard and to display information on
 

What is an Ad Hoc Query

An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools. This is in contrast to any query which
 

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
 

What happens when a variable is not initialized in main function?

When a variable is not initialized in main function it contains garbage value. This can be well seen from the example below main() { int x; printf(“%d”,x); z= sample() } sample() { printf(“Testing program”); } Output is   &n
 

What happens when a variable is not declared in function definition?

Generally in C program the function definition and calling takes the form as given below: main() { int x,y,z; z=sample(x,y); printf(“%d”,z); } sample(x1,y1) int x1,y1; { int z1; z1= x1 - y1; return(z1); } Here what happens is the values x, y gets passed to x1,y1
 

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
 

Variable, Constants and Data types in C++

Variable Constants and Data types in C In this C tutorial you will learn about variable constants and data types in C rules for defining variable name short int int long int float double long double char bool declaring variables and constants mosgoogle Variables A variable is the storage location in
 

How Data Is Stored Within a Data Warehouse

How Data Is Stored Within a Data Warehouse The data that is stored in the data warehouse is just as important as the data warehouse itself Having a fundamental understanding of how this data is stored can be useful in the successful implementation and utilization of a data warehouse One term that yo
 

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