Insert with Select statement in Eazytrieve

gayathrinag · New User Joined: 16 Oct 2008 Posts: 37 Location: chennai

Hi

Can you please tell me how to write Insert with select statement in eazytrieve pgm?

Example:

Insert into S.STUDENT (Roll No,Mark1) select Roll No, Mark1 from M.MARK where Roll No in (1,2,3).

Thanks

dick scherrer · Posted: Tue Oct 12, 2010 9:53 am

Hello,

SQL syntax is the same in Easytrieve as it is elsewhere.

Have you tried something that works in cobol or spufi that doesnot work with Easytrieve?

gayathrinag · New User Joined: 16 Oct 2008 Posts: 37 Location: chennai

Hi Dick,

I tried as given below.

INSERT INTO S.STUDENT (Roll No, MARK1) +
SELECT ROLL,MARK1 from M.MARK +
WHERE ROLL NO IN (1,2,3)
Pls correct me if im wrong

dick scherrer · Posted: Tue Oct 12, 2010 9:59 am

Hello,

What happened?

gayathrinag · New User Joined: 16 Oct 2008 Posts: 37 Location: chennai

Sorry Dick, I missed "+" in my sql , now i fixed it and its working fine....thanks for your time....Have a good day.!!!

dick scherrer · Posted: Tue Oct 12, 2010 8:13 pm

You're welcome - thanks for letting us know it is working

d