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!

Create alias

Status
Not open for further replies.
Pekka

Pekka

Technical User
Mar 19, 2002
107
FI
Hi,
I have table name that exceeds 10 characters in iSeries. So I decided to create a alias for that table so it can be used by for example Query/400. The alias works great in strsql, query manager but in Query/400 I get a system message:'Cannot establish DDM connection with remote system'
So, can I use aliases only in Sql and make a view for that long table name so it can be used in other programs?
 
Status
Not open for further replies.

Similar threads

arkagopal
  • Locked
  • Question
How to create a function which will retrieve year, based on a certain logic
Replies
1
Views
148
mikrom
mikrom
Prince26
  • Locked
  • Question
I have created an event monitor for
Replies
0
Views
134
Prince26
Prince26
evr72
  • Locked
  • Question
select statement runs but if use create get error -104
Replies
3
Views
170
fredericofonseca
fredericofonseca
dbadmin2
  • Locked
  • Question
DB2: Extract definition of a global temp table created using “as select”
Replies
3
Views
151
fredericofonseca
fredericofonseca
gowster
  • Locked
  • Question
I am attempting to create a global
Replies
7
Views
120
MarcLodge
MarcLodge

Part and Inventory Search

Sponsor

Back
Top