How can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?

4 Answers  

---

hi iam very new to as400. i had created one physical file can any one tell command to enter data in to that

9 Answers   Encore,

---

There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

0 Answers  

---

Why we create the Physical File Member?

5 Answers  

---

I want to change the attribute of field or want to add new field in existing PF but condition is format level identifier should not change, is it possible?

9 Answers   Mind Tree, TCS,

---

What is open data path?

0 Answers  

---

How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?

3 Answers  

---

Define interactive jobs and batch jobs

6 Answers  

---

How to retrieve a physical file after deleting that?

0 Answers  

---

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,

---

Where the QTEMP library will get created? if the the answer is QSYS, then howcome more than one job can create same library name(QTEMP) in QSYS? what is the uniqueness of QTEMP? For example, run the below command in different workstation WRKOBJ QSYS/QTEMP And take 8 in the option to check the description. both will have different info. so where(which LIB) exactly the QTEMP is stored?

2 Answers  

---

In how many ways we can create a logical file?`

5 Answers  

---