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
- 6846 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 difference between a Physical File & a Logical?
28 Answers Accenture, ACS, IBM,
what is *inzsr used for?
during input operation which indicator position is seton if there is a record lock?
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?
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.
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.
how can you execute a command from within an rpg program without calling a clp program?
What are the two main attributes, which govern the execution of a job?
how you get the relative record in a subfile in which cursor is located?
what does exfmt does?
What is the purpose of SFLNXTCHG keyword in a subfile?
What is an Array Data Structure?
RPG400 
