Answer Posted / syam
This is 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.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
how can we run a batch job?
how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?
what is scan and xlate?
Hi,Can any body give the code for the below mentioned quetion.?Im trying to get coding in with easily inderstanding.Plese give me the coding for this? 1.How would you achieve this requirement with out using RPG/RPGLE pgm,but by using only CL?Read a database file and display file contents on the screen when enter key pressed the next record should be displayed on screen.When the last record is reached or when F3 key is pressed the program should exit if the file is empty,a message should be displayed indicate that there are no records to display. Database file Name=EMPDBF Fields in EMPDBF to be displayed on screen Employee Number- EMPNUM(5,0) Employee Name- EMPNAM(30,A) Employee Address-EMP ADDR(50 A)
what is externally described file ?
how many files, printer files you can describe in a rpg?
using dfu, user will be able to ___________ from physical file?
what are the basic features of seu?
How can we change the uppercase to Lowercase in RPG?
all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?
How do I remove a flag or check no. or name when a user opens too many sessions?
what is rpg ?
how to pick up the changed records every time in a subfile after the first change made ?
what key word is used when screen is re-display?
what is the disadvantage of using global variable?