Interested to Buy Any Domain ? << Click Here >> for more details...
1.what are the builtin funtions in cl pgg?Explain with
example
2.what is meant by left outer join?where we can use this?
- 2 Answers
- 6702 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / syam
A1. CL Provides 5 Built in functions.
%ADDRESS = to change the memory address stored in a CL
pointer variable
%BINARY = CL character variable as a signed binary integer
%OFFSET = to store or change the offset portion of a CL
pointer variable
%SUBSTRING = same as %SST
%SWITCH = compares one or more of eight switches with the
eight switch settings already established for the job.
A2. Using in SQL
A left outer join will return all the rows that an inner
join returns plus one row for each of the other rows in the
first table that did not have a match in the second table.
SELECT * FROM StudentInfo LEFT OUTER JOIN StudentDetail ON
StudentInfo.cStudentAdNo = StudentDetail.cStudentAdNo
| Is This Answer Correct ? | 2 Yes | 0 No |
What are the two main attributes, which govern the execution of a job?
How can you identify End of file in CLP program?
a multiple format logical file is also known as?
Logic cycle
What is the purpose of SFLFOLD and SFLDROP keywords?
what opcode could be used to test an alphanumeric field for all numeric values?
how to develop some simple graphs (bar charts) using just html?
HOW CAN WE ENTIRE OBJECTS& IT'S TYPE IN PGM?
what is the maximum number of subfiles that can specified in a display file ?
how can you detect and handle a record lock situation?
How can u create a temporary file in CLP @ how to access that temporary file in RPG program?
What is the use of E specification in RPG?
RPG400 
