Look for help !
table : books
-------------------------------------
bookno char 10 (Primary key)
title char 80
author char 80
dtpub Numeric 8
subject char 80
isbn char 15
location char 6
......
Situation : Consult the books table using (1 to 6 search key)
Host language : ILE RPG for as/400
(using embedded SQL) to carry out the job
Search key(s) are input as shown below
Book No: ....
Title : .....
Author : ......
Publish Date : ....
Subject : ....
isbn : ....
eg. when author and publish date are entered
a sql statement : select bookno from books where author = :author and
dtpub = :dtpub
should be passed to SQL ....
is there a way to impliment this using embeded SQL
table : books
-------------------------------------
bookno char 10 (Primary key)
title char 80
author char 80
dtpub Numeric 8
subject char 80
isbn char 15
location char 6
......
Situation : Consult the books table using (1 to 6 search key)
Host language : ILE RPG for as/400
(using embedded SQL) to carry out the job
Search key(s) are input as shown below
Book No: ....
Title : .....
Author : ......
Publish Date : ....
Subject : ....
isbn : ....
eg. when author and publish date are entered
a sql statement : select bookno from books where author = :author and
dtpub = :dtpub
should be passed to SQL ....
is there a way to impliment this using embeded SQL