Static embedding
You can introduce SQL statements into a program through static embedding or dynamic statements. The simpler and more common way is by static embedding, which means that the SQL statements are written as part of the code. The statements are static because they are a fixed part of the source text. For more information on static embedding, see Retrieve single rows and Retrieve multiple rows.