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
- 6071 Views
- I also Faced
- E-Mail Answers
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 |
An rpg program is processing an openquery file.The file is declared in update mode in F spec.Can we update this file? Please explain?
what is a logical file?
What is the difference between regular logical file and join logical file?
For AS/400 Freshers good website is
How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz
What is the difference between physical file and logical file?
what is the difference between seton lr and retrn?
What is an Array Data Structure?
What is the exact difference between Service Program and Binding Directory?
What is the Select and Omit criteria in logical file?
What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?
how can database records be read without lock ?
RPG400 
