NULL value in physical file

370 pts.
Tags:
AS/400
ASCII
Physical File
I am a beginner in AS/400 and learning through some tutorials, I came with a problem of how to add a NULL value in physical file. The spaces can't do the work, as even spaces have a ASCII value. Please respond with possible solutions.

Software/Hardware used:
as400
ASKED: June 18, 2013  5:27 AM
UPDATED: June 18, 2013  11:35 AM

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
    Was the column created with null capability? . Tom
    125,585 pointsBadges:
    report
  • Durgesh813
    yess
    370 pointsBadges:
    report
  • TomLiotta
    Here is a sample statement that sets a column to a NULL value: . == > UPDATE MYLIB/MYNULL SET COL2 = NULL WHERE COL1 = 'ABC' . The statement looks for every row where the COL1 column contains the value 'ABC'. In every matching row it finds, it sets the COL2 column to the null value. "NULL" does not equal spaces nor does it equal any other value. NULL has no value and it doesn't match anything else. . NULL means that the column does not have a value. . When an employee is hired, the Employee record might have a column for HireDate and another column for TerminationDate. But while the employee is working, there is no value for TerminationDate. The standard representation is the null value. . 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