Answer / sanjeet kumar

UDATE supports two-digit year.The format is *MDY (MMDDYY).
*DATE (system date) supports four digit year. The format is *MDYY (MMDDYYYY).

Answer / Dhruv Agarwal

"UPDATE (in SQL) is a command used to modify existing records in a database, while SYSDATE is a predefined function that returns the current system date and time. In IBM AS400 SQL, SYSDATE can be used as IND$"",SYSTIME or QTIMESTAMP."

Which command we can use to update a physical file using c.l pgm?

19 Answers   Ocwen,

---

what are the necessary keywords for the join logical file?

2 Answers   IBM,

---

which are control break logic indicators?

1 Answers   IBM,

---

how to get the particular field's records in CL without using OVRDBF,OPNQRY? tell me the concept?

2 Answers  

---

Define the purpose of Factor 1 the Operation Code and *IN15 in following code HI LO EQ C *YMD Test(D) yymmddDate 15

1 Answers  

---

What is the purpose of the following C/COPY QRPGSRC, ORDERR

1 Answers  

---

Please give me the code for A=A+1 in cl program?

2 Answers  

---

how can u check no of records in a file?

1 Answers   IBM,

---

What is the use of OVRPRTF ?

1 Answers  

---

what is primarykey?what is difference between primary key and forign key?

1 Answers  

---

Write a logic program for knowing the repeated number of a vowels in a given program?

1 Answers   Valtech,

---

What does SDA stands for ?

1 Answers  

---