Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6824 Views
- I also Faced
- E-Mail Answers
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
difference between view and index ?
the maximum number of subfiles that can defined in a rpg program for one display file is ___ .
what is the function of crtdupobj command?
what is scan and xlate?
what is a keyed physical file?
Difference between NOPASS & OMIT?
WHAT IS AS/400 SYNORIO?
what are indicators?
how many specifications are there in rpg/400? What are they?
hi guys i am new for sqlrpgle, please suggest me good websites and theory and coding. plz plz its very urgent.
what is a composite key?
What is file information data structure(infds) in as400?
what is xfoot opcode ?
some special characters I key in my html source members show different on my web pages. Why? How can I solve this?
what key word is used when screen is re-display?
