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 we can't update join logical files?

10 Answers  


Maximum how many fields we can create under a record format of PF?

5 Answers  


Q.1 how to implement the commitment control. 2.how to control commitment control from external program.

7 Answers   IBM,


What is open data path? And what is the difference between access path and open data path?

0 Answers  


Why we create the Physical File Member?

5 Answers  






In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

0 Answers   Nous,


I had created one physical file tell me command to enter data in to?

0 Answers  


Last statement of any RPG pgm is LR?

5 Answers  


1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?

2 Answers   IBM,


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?

4 Answers   IBM,


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,


How to find the list of source physical files in a library?? Is there any way to get a list??

4 Answers   Infosys,






Categories