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
- 6850 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 CPYFRMQRYF?
what is RCLRSC?
what is command in SFTP which is equivalent to SDUP command in FTP?
how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.
what is the rpg and cl life cycle?Please tell me any body
a program variable coded in an embedded sql statement is referred to as?
how we lock a pf???? what are the parameters used in this command.how we understand whether an object is locked or not?? using command .....we have to use *PSSR? and trough *status..how??.if we give an eg to me???pls answer me anyone..
What are the different ways to input data into data area?
How can you identify End of file in CLP program?
what is the maximum number of record formats in dspf?
define a shared access path?
which of the following operations does not zero the field flda defined as 4,0?
RPG400 
