| View previous topic :: View next topic |
| Author |
Message |
culturewyj
Beginner
Joined: 15 Jun 2006
Posts: 15
Topics: 10
|
 Posted: Thu Jul 06, 2006 8:21 am Post subject: automatic calculating column |
 |
|
| Code: | CREATE TABLE AUTHORS (AUTHORID INTEGER NOT NULL PRIMARY KEY, 00000100
LNAME VARCHAR(100), 00000200
FNAME VARCHAR(100), 00000300
FICTIONBOOKS INTEGER, 00000400
NONFICTIONBOOKS INTEGER, 00000500
TOTALBOOKS INTEGER GENERATED ALWAYS AS 00000600
(FICTIONBOOKS + NONFICTIONBOOKS) ) ; 00000700
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE
LEGAL ARE: LOCATOR SECURITY
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 502 0 0 -1 455 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'000001F6' X'00000000' X'00000000' X'FFFFFFFF'
X'000001C7' X'00000000' SQL DIAGNOSTIC INFORMATION |
Isn't supported by db2 7.0/8.0 for z/os? |
|
| Back to top |
|
 |
culturewyj
Beginner
Joined: 15 Jun 2006
Posts: 15
Topics: 10
|
| Posted: Thu Jul 06, 2006 9:04 am Post subject: |
|
|
and.
| Code: |
---------+---------+---------+---------+---------+---------+---------+---------+
CREATE TABLE T1 ( C1 INT NOT NULL PRIMARY KEY,CNAME CHAR(40)); 00000100
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+---------+
CREATE INDEX IND_T1_C1 ON T1(C1) INCLUDE( CNAME); 00000200
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE
LEGAL ARE: <INTEGER> <IDENTIFIER>
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 502 0 0 -1 41 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'000001F6' X'00000000' X'00000000' X'FFFFFFFF'
X'00000029' X'00000000' SQL DIAGNOSTIC INFORMATION
|
|
|
| Back to top |
|
|
culturewyj
Beginner
Joined: 15 Jun 2006
Posts: 15
Topics: 10
|
| Posted: Thu Jul 06, 2006 9:04 am Post subject: |
|
|
| Doesn't the include option in creating index support in db2 for z/os? |
|
| Back to top |
|
|
NASCAR9
Intermediate
Joined: 08 Oct 2004
Posts: 274
Topics: 52
Location: California
|
| Posted: Thu Jul 06, 2006 9:41 am Post subject: |
|
|
Do a search on Auto Calculating and you will see a post by me. The short answer is NO, not on Z/os.
_________________
Thanks,
NASCAR9 |
|
| Back to top |
|
|
culturewyj00
Beginner
Joined: 15 Jun 2006
Posts: 14
Topics: 7
|
| Posted: Thu Jul 06, 2006 8:37 pm Post subject: |
|
|
Thanks very much@!!!! |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
