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
- 6072 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
using dfu, user will be able to ___________ from physical file?
Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?
what are the basic features of seu?
what is a primary file?
how to develop some simple graphs (bar charts) using just html?
what is the maximum number of files allowed in rpg?
what is procedure prototype and procedure interface.
what is overlay?
what does the ovrdbf command do?
why is as/400 called object oriented machine?
when would you use or not use this approach?
what are indicators?
what are the different types of variables available in cl?
Pose, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular name field. How can we do the above using search criteria other than using the if cond?
when do you explicitly open files and close files in an rpg program?
