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
- 8563 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tuhina
select cityfldname from DBF where cityfld like '%cityname%'
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / chandrasekhar gangireddy
by using DSPPFM on file, type "city" on search fields then press enter u will get the city
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / vivek dwivedi
Using Var = %Scan('City' :1: length o the base string)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / paramesh
select cityfldname from DBF where cityfld = '%cityname%'
| Is This Answer Correct ? | 0 Yes | 3 No |
can any one tell me what is meant by PSSR? Kindly elaborate it...
Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?
Last statement of any rpg program is lr?
How to read a pf in reverse(from last record to first) using cl?
i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF
How many libraries can be there in a library list?
What is the batch job?
Which keyword is used both in subfile and subfile control record format of a DSPF?
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...
can we concate fileds in physical file? If yes how can we do?
what is exception and how many types of exception
how to eliminate the level check error
RPG400 
