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
- 6922 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
is there any way I can ease my rpg controls on numeric input fields? How about an input date field?
what is the sequence when using cursor?
how do you specify the number of records to roll in a subfile ?
what opcode will be used to test the zone of a character field?
What are the different opcodes used for file operation on a subfile in a rpg pgm?
what is the maximum number of fields under a record format of physical file?
What Does 'sr' In Columns 7-8 Of C Specs Mean?
how will you find a string using pdm?
the output from my cgi is correctly interpreted by ms internet explorer, whereas netscape navigator would display it as a plain text. What should I do to have also netscape interpreting the html output from my cgi?
how can you execute a command from within an rpg program without calling a clp program?
how to validate input values in display file ?
what is rpg ?
how will you display a particular page in subfile ?
which are the member types which seu supports?
what is xfoot opcode ?
