Questions tagged [native-sql]
77 questions
-1
votes
1 answer
REGEXP in java code
This is the query which is running properly in sql . But when i am ruuning it with java code. Showing query syntax exception
SELECT * FROM faq WHERE question REGEXP 'general'
My java code
List results =…
A.G
- 489
- 1
- 6
- 17
-1
votes
1 answer
Please explain what the sentence REPLACE(tablecolumn,CHR(13),'') really mean in db2 (Native SQL)
Please help me in understanding what does the below code really mean?
CASE WHEN REPLACE(tablename.columnname,CHR(13),'') <> ''
THEN
REPLACE(tablename.columnname,CHR(13), '')
ELSE
REPLACE(tablename.columnname,CHR(13),'')
For your reference:…
rosemoh
- 1