× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi, Sudha

What is keeping you from using Table_Name? What message are you getting? If your table name has spaces in it, try surrounding it with quotation marks.

Now, to have a good system view name, make sure you keep the table name to 10 characters and that it have no spaces and that it does not start with a numeral. There are some other rules - basically make it like a standard AS/400 object name.

There must be something in the SQL Reference on naming with long names.

HTH
Vern

At 01:31 PM 5/13/2004, you wrote:
HI all,
I am trying to a jdbc java call to a view, a view that was created in
AS/400.  I am not able to use the Table_Name instead have to use the
System_View_name (from the sysviews), that is generated by IBM default
view definers.  I don't have any standard to these names. Is there
anyway I could use Table_Name or create my view with meaigful
System_view_names?
Thanks for your help,
Sudha

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.