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
- 6700 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
If i change any file through application after entering data , how to check which file is updated through applications . For call stack we takes esc 3 then we chose 11..But What is answer of below qtn..?
define subsystem?
what is the difference between seton lr and retrn?
If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...
What are the different opcodes used for file operation on a subfile in a rpg pgm?
WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?
the maximum number of subfiles that can defined in a rpg program for one display file is ___ .
what is the maximum number of fields under a record format of physical file?
how many maximum spaces could be given in o specs?
what are the two record formats a subfile contain ?
how can I automatically refresh a web page?
what is the purpose of data structure?
which are the figurative constants used in rpg?
records can be read/update/deleted with which file?
What Is Ddm ?
