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
- 6799 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 |
STRTCPFTP command is used to start FTP in CL Language (ILECL)....can u plz tell me which command is used to start SFTP in CL language(ILECL)?
Can anybody know difference between SNDUSRMSG AND SNDPGMMSG IN CL PROGRAMMING? IF DON'T KNOW MAIL ME @ gkarthik.as400@gmail.com
What are the mandatory keywords of sub file?
What Is The Error If We Don't Get Login Screen?
What are the types of data structure in as400?
what is the correct about QTEMP library(below mention)? a.it is Unique to a job b.it can be shared between different job c.it can only be deleted by QSECOFR d.Non Please give me the answer for this?
Define a Batch Job?
how do you read changed records backward in subfile?
Describe the function of SETGT operation in RPG language?
Which is better LF or OPNQRYF ? When should we use LF and when should we use OPNQRYF ?
I/o error detected,Record Out of sequence,Permanent I/o error occured....I mean give one eg for these errors...i understand only,update/delete operation without prior read oprn..give details of remaining
what are the types of errors available in rpg IV or 400.Like decimal data error,sessional error or device error etc...means important error occurings,ie to find out suddenly???pls give answ if u know?Pls give the answer 1,,,,,,,to 12.........ie how it will happened like...for eg if a file is not closiing ,,,like this error is happened... if sufficient data is not in a pf to write in a display file. or sfldsp is not "on"......sessional or device error occured...like this give details all 1 to 12 errors (syam..)....give details PLsssssssssss?
RPG400 
