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
- 6739 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 |
what is the use of UNIQUEUE KEY WORD? what is the difference between PFILE AND REF?
how can you check for a records existence without causing and i/o (chain/read)?
what is subfile?
what is the command to know how many lf are related to a pf?
What is binder language ?
what is clile code get last digit in numarice value
what is the function of cpysplf command?
I am a fresher. I got project on AS 400. Can any body suggest the best book for learning of it.
how to toggle between single line and multi - line display of a particular record in a subfile?
writing an sql statement from selecting records from two files using single statement and nested select statement.
how to read database records without locking them?
what is a query can be run in which mode?
RPG400 
