Q:
Delete variable file in SQLRPG
How can I use any variable file in an instruction SQL of DELETE in SQLRPG?
ASKED:
Jun 4 2009 9:01 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
In SQL to delete a table or files use the 'drop table' command
Statement = 'Drop table ' + tableName
To delete a row -- if that's what you want build the statement
Statement = 'Delete from ' + tableName + ' where ' + rules
Either would be a dynamic SQL statement.
Here is an example:
http://www.partner400.com/SQLIntro+Embed.pdf
Phil
