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.
- 0 Answers
- 720 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
can we concate fileds in physical file? If yes how can we do?
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.
how to restrict upon adding the data for field reference file in DB400
How to read a PF in reverse(from last rec to first) using CL?
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...
When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?
How to add a field to a PF and compile it without loss of data?
How to insert more than one record to a pf at a time?(Bulk insert to a pf)
How to find the list of source physical files in a library?
how to update physical files using normal logical file
How many maximum record format a logical file have?
I have a PF with out any data but the dependent LF is having data?
RPG400 
