DB2 SQL

420 pts.
Tags:
AS/400 SQL
Hello Sir,
            I am creating a table through SQL in AS/400.
CREATE TABLE ANUP41/EMPL4 (NAME CHARACTER ( 10) NOT NULL, ADDRESS CHARACTER ( 25) NOT NULL, PROFILE CHARACTER ( 10) NOT NULL, UNIQUE (NAME))                                                           
But after enter i get this message, 
Table EMPL4 in ANUP41 created but could not be journaled.
What it means?
It is an error and how to resolved it?


Software/Hardware used:
software

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: 1  Reply

 
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 isn't an error with CREATE TABLE. It is a design flaw with the schema that you created the table in. It isn't an actual schema; it's a library that is only being used like a schema. A true schema will be created with a journal. You are using a library that hasn't been prepared for SQL. If you use CREATE SCHEMA to create a schema first, then use that schema to create your tables in, you won't get the message. Since you don't have a real schema, there are two ways you can make the library work more like a schema for this message. First, you can create a journal named QSQJRN in the library. If you create your table then, it will start automatic journaling. Second, you can create a journal with a name different from QSQJRN in your library. Then create a data area named QDFTJRN in your library. Follow the rules in Automatically starting journaling to define it. 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