Re: Table_name in views

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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