HPE Community
Operating System - HP-UX
1757417 Members
2911 Online
108860 Solutions
New Discussion юеВ

select fields ?

 
Sergio Tancredi
Occasional Advisor

тАО05-21-2001 06:51 AM

тАО05-21-2001 06:51 AM

select fields ?

Hi all,

I need a sql command that allow me to see which
fields are locked on a specific table.

How can select?

Thanks in advance,
Sergio


0 Kudos
Reply
3 REPLIES 3
melvyn burnard
Honored Contributor

тАО05-21-2001 07:04 AM

тАО05-21-2001 07:04 AM

Re: select fields ?

I suggest you speak to your database/application provider for this one.
My house is the bank's, my money the wife's, But my opinions belong to me, not HP!
0 Kudos
Reply
Alexander M. Ermes
Honored Contributor

тАО05-21-2001 11:53 PM

тАО05-21-2001 11:53 PM

Re: select fields ?

Hi there.
What database is it ? If it is Oracle,
try 'desc tablename'. Or you can try to connect to that database with ODBC / MS-ACCESS
and link that table.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
0 Kudos
Reply
Sergio Tancredi
Occasional Advisor

тАО05-22-2001 03:06 AM

тАО05-22-2001 03:06 AM

Re: select fields ?

I've solved the problem with a reboot of Oracle DB.

I had an hanged transaction that blocked my system.

Thanks all,
Sergio
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.