Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with DB2 Generated columns

Status
Not open for further replies.
ameliays

ameliays

Programmer
May 28, 2003
1
US
I read about the Generated Always As command on db2 documentation, but was wondering if it can be used to concatenate two columns that are varchars. The example they had was to add up to double columns. Any help would be great!

Thanks!
 
Sort by date Sort by votes
Why not simply use the CONCAT function or || operator to get one column out of the varchars?

T. Blom
Information analyst
tbl@shimano-eu.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
383
prashant_0701
P
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
296
tekpr00
tekpr00
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
243
mikrom
mikrom
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
300
walter.weinmann
walter.weinmann
Rohit K Gupta
  • Locked
  • Question
DB2 Equivalent of IGNORE_DUP_KEY
Replies
0
Views
132
Rohit K Gupta
Rohit K Gupta

Part and Inventory Search

Sponsor

Back
Top