how can you copy records present in a flat physical file to
a database file(physical file).please explain in rpg400 with
a simple example
Answer / guest
Declare a DS with same data types in PGM and move the
record into DS and write the structured file using the DS
Is This Answer Correct ? | 1 Yes | 0 No |
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
db2 restart logic ?
How to create backup table in db2?
Can we declare DB2 HOST variable in COBOL COPY book?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
What is with ur in db2?
What are common abends
What is db2 look?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2