How to insert Hex values through SQL/400

color

10 pts.

Tags:

SQL Database

SQL Query

SQL/400

Hi,

I'm creating a table querying the data from 3 different tables through joins. I need to insert a Hex value ‘3F’ at the end of the last record in the Output file (Table) I create to know the end of file for another system reading the file.

I do not know whether this can be possible to insert a hex value into a table through SQL/400 query.

Thank You

Software/Hardware used:
SQL400

Asked: April 22, 2013 11:07 PM Last updated: April 23, 2013 12:17 PM

Answer Wiki

Discuss This Question: 3 Replies

TomLiotta Apr 23, 2013 0:47 AM GMT

It's not clear what is meant by "at the end of the last record". SQL has no useful concept of specific records except as specified in a WHERE clause. It doesn't even have a concept of a "record"; it really only knows groups of columns. . Maybe if you let us know something about the SQL that generates the output and how you get that into the streamfile format needed by the other system, we might have a better idea what to suggest. . Tom

125,585 pointsBadges:

report
CharlieBrowne Apr 23, 2013 3:22 PM GMT

If you are creating a table, you have predefined fields. So I do not understand how you would insert something after the last field in the file. If you want to insert a new record with a hex value, you can do that with SQL. INSERT INTO yourlib/yourfile VALUES(X'3F')

62,340 pointsBadges:

report
TomLiotta Apr 23, 2013 11:37 PM GMT

You can insert hex values with SQL if the column allows the hex value. Otherwise the INSERT would fail. -- Tom

125,585 pointsBadges:

report