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
what is a spool file?
what is procedure prototype and procedure interface.
What is the difference between crtdupobj and copyf?
can a indexed file be accessed in arrival sequence in rpg program?
which of the following operations does not zero the field flda defined as 4,0?
what is meant by object lock requests,held locks and locks waiting to be applied(wrkobjlck) why should we apply for locks.Please explain sir.
how to write code for singlepage in sqlrpgle with update ?
list some of the commonly used commands for debugging?
what is the difference between seton lr and retrn?
a multiple format logical file is also known as?
Hello, I have created a CMD type object. In one of the fields in Display file , I would like to see All the Source files present by pass the name of Library. Tried using CHoice(Keyword) and Choicepgm on PARM , but doesn't seems to be working. Any help please..
explain the purpose of keep and assume keywords?
how to pick up the changed records every time in a subfile after the first change made ?
What is the default access path of a file?
what is the purpose of indicators in rpg?