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 ?

Answers were Sorted based on User's Feedback



How can i retrieve city while my i have one field address length 60 but i don't know what wher..

Answer / tuhina

select cityfldname from DBF where cityfld like '%cityname%'

Is This Answer Correct ?    2 Yes 1 No

How can i retrieve city while my i have one field address length 60 but i don't know what wher..

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

How can i retrieve city while my i have one field address length 60 but i don't know what wher..

Answer / vivek dwivedi

Using Var = %Scan('City' :1: length o the base string)

Is This Answer Correct ?    0 Yes 0 No

How can i retrieve city while my i have one field address length 60 but i don't know what wher..

Answer / paramesh

select cityfldname from DBF where cityfld = '%cityname%'

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More DB400 Interview Questions

What is the interactive job?

0 Answers  


When u create a PF and did not fill up Maint parameter, then by default which access path will the system take & why

2 Answers   HCL,


Last statement of any RPG pgm is LR?

5 Answers  


How to know the perticular record in pf with out reading?

2 Answers   Cap Gemini,


pls anyone explain about compile time array,pre run time array run time array

4 Answers  






Suppose 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?

0 Answers  


how to update physical file using logucal file with example

1 Answers   Wipro,


Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

0 Answers  


How to retrieve a physical file after deleting that ? what is keyword used for that....??

6 Answers  


what is dynslt and why we use that command when do we use command

2 Answers   Active Brains, UHG,


What is the interactive job? What is the batch job? How to change the batch job to interactive job?

0 Answers  


how to know total no of records in pf with out using sql??????

3 Answers  


Categories