How to insert Hex values through SQL/400

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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    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')
    41,430 pointsBadges:
    report
  • TomLiotta
    You can insert hex values with SQL if the column allows the hex value. Otherwise the INSERT would fail. -- Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following