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 |
What is the purpose of reorganizing the physical file i.e. , RGZPFM?
Why would you prefer OPNQRYF than logical file?
when are the unique constraints executed?
Define a Batch Job?
What is LEVEL CHECK?
what is primarykey?what is difference between primary key and forign key?
What are Triggers?
14 Answers Ordain Solutions, Seabus Solutions,
what is maximum number of arrays allowed in rpg?
how do you turn off indicators 50 through 59 in only one operation
in conjunction with what other keyword must ovrdta and ovrata be used?
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 do you set the keywords SFLSIZ and SFLPAG if you want the subfile to dynamically expand?