Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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?

Answers were Sorted based on User's Feedback



1.what are the builtin funtions in cl pgg?Explain with example 2.what is meant by left outer join..

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..

Answer / s.kumar

Hi,
Refer to Cl reference book.

http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/topic
/com.ibm.etools.iseries.langref2.doc/rbam6builtinfunc.html

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More IBM AS400 AllOther Interview Questions

Explain The Keywords Edtcde & Edtwrd?

0 Answers   IBM,


what is the difference between clear and reset opcodes and open and close opcodes?please tell me in real time senario with example please? And What is the use of SFLNXTCHG?Where we can use this?

4 Answers   IBM,


in which specification the report layout can be defined?

1 Answers   IBM,


does we use case stmt in cl

1 Answers  


what is the maximum number of subroutines allowed in rpg?

1 Answers   IBM,






What is GDA?

1 Answers  


Difference Between Ca & Cf?

0 Answers   IBM,


how you will find an error which is not in the first page of the subfile without using rolldown key?

0 Answers   IBM,


where exactly we can use OPNQRYF ?

3 Answers   TCS,


how do you read data area in an rpg program?

1 Answers   IBM,


how many types of display are available on as/400 for user interaction?

0 Answers   IBM,


what is a non-join logical file?

1 Answers   IBM,






Categories