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
- 6829 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 |
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?
how can you specify no duplicate key?
In AS/400 projects in Companies whats the meaning of production support team.what production support involves.also what work does development,maintenance involve what are the other teams or processes that are available for as400 project.
0 Answers Adverb Solutions, CSC,
What is the purpose of USROPN keyword?
what is a logical file?
What is the difference between crtdupobj and copyf?
What is the difference between array and a multiple occurrence data structure?
How to create a data queues?
What is difference between fully procedural file and primary file?
which type of object is used in db2/400?
how do we know batch job aborted after we submitting it
what does vldcmdkey means?
RPG400 
