SQL pgm

[MFritts253]

I am a serious new guy to rpg programming on an iSeries
all i really want to do is have a simple insert statement run in an sqlrpg le program. I am planning on moving SQL to a stored proc later but i just wanted to learn the basics first.

C/Exec SQL
C+ SELECT * FROM MYLIB/CUSTMST
C/END-EXEC

I have no idea how i should compile this thing either. I am basically clueless.

Sincerely,
Michael

 

[MdnghtPgmr]

MFritts253,

Below is the URL for a IBM Redbook that should be a "must read" for all RPG programmers. I don't do much with SQLRPG but the Redbook will help.

http://www.redbooks.ibm.com/abstracts/sg245402.html

HTH,
MdnghtPgmr

 

[Mercury2]

C/Exec SQL
C+ INSERT INTO MYLIB/CUSTMST (FileFld1, FileFld2, FileFld3, FileDate )
C+ VALUES( :Fld1, : Fld2, 'X', :MyDate )
C/END-EXEC

FileFld1, FileFLd2, FileFld3, FileDat are the fields pertaining to the CUSTMST file.

Fld1, Fld2, MyDate are fields declared somewhere in the program.

 

[Mercury2]

I find funny MdnghtPgmr, that we replied apparently both at the same minute )

 

[MdnghtPgmr]

Mercury2,

Yeah. But at least you had code to show! That and I'm pretty slow at getting back out here...

MdnghtPgmr