I have some code that was working fine but now it has quit functioning.

Store SQLConnect('webprddtx','sde','mypassword') To gnHandle1n
testthissd = "INSERT INTO drawmstrp(dm_drawing_number) Values('855459')"
= SQLSETPROP(gnHandle1n, 'Transactions', 2)
= SQLEXEC(gnHandle1n, testthissd)
= SQLCOMMIT(gnHandle1n)

=SQLDISCONNECT(gnHandle1n)
EndIf

SQLCommitt returns a 1 but the as400 table is not appended too.