There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql?
If we have around 100 values in string like this, each value should be displayed with initials as Shri.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB400 Interview Questions

How to index LF by relative record no (RRN)

0 Answers  


How many max. Record format a logical file have?

13 Answers   Systime,


Why journalling is compulsory before commitment control?

1 Answers  


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

4 Answers  


what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,






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,


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

1 Answers  


I have a pf, it contains 5 members, how to access particular member data from logical file?

0 Answers  


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...

6 Answers   ABC, TCS,


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

3 Answers  


If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.

2 Answers  


What is the primary file?

0 Answers  


Categories