Re: HELP with embedded SQL (pro*C)

Matthew J Carr (carr_at_ist.flinders.edu.au) wrote:
: What I want to do is query two tables to get the day and time of a given tutorial( in the tut_booking table) and the starting time from another(tutorial table)
 

: EXEC SQL create view time_ckeck as
: select distinct t_day,t_time,start_date
: from tut_booking,tutorial
: where stud_id = reg_num
: and tut_booking.tcode = tutorial.tcode; -- join condition

I could be wrong here, but I seem to recall that ALL DDL statements are off-limits in embedded SQL. If this is the case, it would be mentioned near the place in the manual where embedded SQL is first described (I don't have it in front of me). You should probably create the view prior to running the application, or use a more complex SQL select in your program.

• Robert Sechrest