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?
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 |
how many specifications are there in rpg/400? What are they?
How to position the cursor on a display file at a desired location.
what is join logical file?
where can you specify an indicator in lokup operation?
what are the various types of device files?
how can I start a page in a new window?
which are the member types which seu supports?
What is Multi-format logical file?
Difference Between Ca & Cf?
What is the default value for the number of increment for the physical file?
What is the difference between physical file and logical file?
what are the different types of arrays available in rpg ?