Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8019 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 |
Define interactive jobs and batch jobs
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?
what is the intractive job? what is the batch job ? how to change the batch job to interactive job?
What is open data path? And what is the difference between access path and open data path?
How to add a field to a PF and compile it without loss of data?
what is the difference between adding keys & constraints into a phisical file
What is the interactive job?
how to restrict upon adding the data for field reference file in DB400
what is use of self join and which cases you will use this join
I have a PF with out any data but the dependent LF is having data?
how to know total no of records in pf with out using sql??????
How to find the list of source physical files in a library?? Is there any way to get a list??
RPG400 
