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?
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
. How to know why the OPM job is in MSGWAIT state?..WHAT COULD BE THE REASON FOR it?
what is the use of sflend keyword?
Difference Between Interactive & Batch Job?
how to write code for singlepage in sqlrpgle with update ?
which type of object is used in db2/400?
how do u compile rpgle program?
What is diff between EVAL & MOVE?
what is the length of a variable in rpg?
how can you execute a command from within an rpg program without calling a clp program?
what is *iso date format?
how many levels are there in a physical file?
how you will find an error which is not in the first page of the subfile without using rolldown key?
what is a spool file?
What Is The Object Type Of Pf, Lf, Printer File & Display File?
define the purpose of the *bcat function?