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

how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible

4 Answers   ocbc,


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

3 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 can we handle errors in RPG?

4 Answers  


what is multiple member pf

1 Answers   Active Brains,






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

3 Answers  


YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?

4 Answers  


what is open data path? and what is the diff b/w access path and open data path?

3 Answers   Cap Gemini,


Is it possible to create a logical file whose Physical file is not in same library?

6 Answers  


what is open data base command

1 Answers   Active Brains, CTS, Cognizant, CSC,


how can we write LF using flatfile.

9 Answers  


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  






Categories