1.what are the builtin funtions in cl pgg?Explain with
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
%BINARY = CL character variable as a signed binary integer
%OFFSET = to store or change the offset portion of a CL
%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|
Explain The Keywords Edtcde & Edtwrd?
what is the difference between clear and reset opcodes and open and close opcodes?please tell me in real time senario with example please? And What is the use of SFLNXTCHG?Where we can use this?
in which specification the report layout can be defined?
does we use case stmt in cl
what is the maximum number of subroutines allowed in rpg?
What is GDA?
Difference Between Ca & Cf?
how you will find an error which is not in the first page of the subfile without using rolldown key?
where exactly we can use OPNQRYF ?
how do you read data area in an rpg program?
how many types of display are available on as/400 for user interaction?
what is a non-join logical file?