Thread: Help with Embedded SQL

Can someone help me understand what is happening in this code. I am confused about what is being done in the structure INTFC_LKUP which I posted below the code. Thanks.

Code:

   1042     EXEC SQL SELECT remote_host, ftp_cmd, src_dir, dest_dir,
   1043         xfer_dir, notify_flag
   1044     INTO :intfc_lkup.remote_host, :intfc_lkup.ftp_cmd, :intfc_lkup.src_dir,
   1045         :intfc_lkup.dest_dir, :intfc_lkup.xfer_dir,
   1046         :intfc_lkup.notify_flag
   1047     FROM intfc_lkup
   1048     WHERE intfc_nm = :intfc_lkup.intfc_nm;



typedef  struct {
    char    intfc_nm[26];
    char    remote_host[26];
    char    ftp_cmd[7];
    char    src_dir[151];
    char    dest_dir[151];
    char    xfer_dir[151];
    char    notify_flag[2];
    char    ftp_username[26];
    char    ftp_password[26];
  } INTFC_LKUP;

Thanks. I still am a little confused but looking online for more information. Please correct me if I am wrong. Which I am sure I am wrong. The SELECT grabs records from the db and INTO places these db records into my structure WHERE intfc_nm = :intfc_lkup.intfc_nm;? I am not a programmer yet but I am trying to learn 2 things at once (db and c programming) on my own so thanks for any patience you may have.

-Carl

Your help is greatly appreciated. Thanks for taking time to answer my questions. It at least makes some sense now and I can apply what you just spelled out for me to other code I am running into.

-Carl