Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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

What is the difference between a Physical File & a Logical?

28 Answers   Accenture, ACS, IBM,


what is *inzsr used for?

1 Answers   IBM,


during input operation which indicator position is seton if there is a record lock?

1 Answers   IBM,


PGM QSH CMD('/QOpenSys/bin/sftp -b/home/test/myfile.txt serverUserID@server') ENDPGM Can u plz tell me what the above code do exactly?

2 Answers  


i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.

0 Answers  


4 persons a, b , c , d have to go to concert which will held in 17 minutes. there is a bridge which only 2 persons at a time can cross. its night and they have only one flashlight with them. Flashlight cannot be thrown. one person should return with the flashlight all 4 person have different speed. a = crosses bridge in 1 min. b = crosses bridge in 2 min. c = crosses bridge in 5 min. d = crosses bridge in 10 min how can they all reach in time.?? Ex- suppose a and d crosses bridge which will take 10 mins and then d returns back with a flashlight which will make 20 mins and mission is failed.

1 Answers   Manhattan,


how can you execute a command from within an rpg program without calling a clp program?

1 Answers   IBM,


What are the two main attributes, which govern the execution of a job?

1 Answers  


how you get the relative record in a subfile in which cursor is located?

0 Answers   IBM,


what does exfmt does?

1 Answers   IBM,


What is the purpose of SFLNXTCHG keyword in a subfile?

1 Answers  


What is an Array Data Structure?

1 Answers  


Categories