Home > IT Answers > AS/400 > SQL/400 field editing
DanTheDane
2,540 pts.
 SQL/400 field editing
AS/400 SQL, SQL, SQL/400
What is the best (easiest!!) way to add editing to fields in an SQL-created table?

Software/Hardware used:
ASKED: April 20, 2009  9:27 PM
UPDATED: December 15, 2009  8:12 PM
RELATED QUESTIONS
Answer Wiki:
You can use the <a href="http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp">ALTER TABLE</a> SQL statement to add a check constraint. Or you could use the native <a href="http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp">ADDPFCST</a> (add physical file constraint) as well. Your constraint would need to follow SQL syntax. CWC **********************
Last Wiki Answer Submitted:  December 15, 2009  8:12 pm  by  Cwc   4,275 pts.
All Answer Wiki Contributors:  Cwc   4,275 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

“editing”?

You mean like edit words and edit codes? SQL TABLEs don’t have editing. Editing is a reporting function, not a column definition function.

I suppose you might be able to define a LF with editing over the table and reference the LF, though I’ve never tried (nor actually heard of anyone who has). I would expect that it wouldn’t do much good though, except in HLL programming that used native I/O. But that probably messes with the purpose of using SQL for the CREATEs in the first place.

Tom

TomLiotta
 108,055 pts.