Troubleshooting
Problem
This document explains how to insert a word that contains an apostrophe into a character field using SQL.
Resolving The Problem
How is a SQL statement coded to insert a character string that has an apostrophe in it?
The following shows how to insert an apostrophe using SQL:
INSERT INTO libname/filename VALUES('O''Hara')
This puts O'Hara in the first column in the file.
The following shows how to insert an apostrophe using SQL:
INSERT INTO libname/filename VALUES('O''Hara')
This puts O'Hara in the first column in the file.
[{"Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001i4eAAA","label":"IBM i Db2-\u003ESQL Examples \/ DB Examples \/ Misc how to"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Type":"MASTER"}]
Historical Number
11790458
Was this topic helpful?
Document Information
Modified date:
05 December 2024
UID
nas8N1018365