Inserting data into a vargraphic data type field
Application software, Data center operations, Database Management Systems, DataCenter, DB2, DB2 administration, DB2 Everyplace, Development, Hardware, Help Desk, IT architecture, Migration, Modeling, Operating system platforms, Services, Tech support, Third-party services, UDB for iSeries/i5, Vendor support
How to insert data into a vargraphic data type field. I have done the following
CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20))
This is done succesfully
INSERT INTO TEST_TABLE VALUES('TEST')
This gives a SQL error
Please let me know how I can acheive it.
Software/Hardware used:
Software/Hardware used:
ASKED:
April 28, 2005 9:44 AM
UPDATED:
May 4, 2005 11:11 AM
Answer Wiki:
You'll need to use the vargraphic() function --
insert into test_table values (vargraphic('TEST', 4));
This should convert your text to something the vargraphic column can accept.
Next time report the error you receive, as it's impossible to read minds.
David Fitzjarrell
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
