Hi,
Which is better using functions to execute SQL statements or Embedded SQL...??? I'm currently doing Embedded SQL in C in an AIX environment.
Functions e.g.
PreparedStatement ps = con.prepareStatement("SELECT img FROM images WHERE imgname=?"
ps.setString(1, "myimage.gif"
ResultSet rs = ps.executeQuery();
or
Embedded SQL e.g. "EXEC SQL SELECT img FROM images
WHERE imgname=......"
Thanks.
Which is better using functions to execute SQL statements or Embedded SQL...??? I'm currently doing Embedded SQL in C in an AIX environment.
Functions e.g.
PreparedStatement ps = con.prepareStatement("SELECT img FROM images WHERE imgname=?"
ps.setString(1, "myimage.gif"
ResultSet rs = ps.executeQuery();
or
Embedded SQL e.g. "EXEC SQL SELECT img FROM images
WHERE imgname=......"
Thanks.