Search results for query: *

Chopstik, thanks for you post: its gave me a few ideas how I can shape my future. Going off topic initially, there were no real major disadvantages living in Asia, however there were a few niggling points that being from the Western world, contributed to me leaving: my diet primarily was Thai...

Just wondering if there is anyone out there with some advice with regards to my career direction. I graduated with a degree in Software Engineering and immediately found a position in a medium sized company designing/developing both front (C++) and back end database (SQL) solutions for a number...

Try select * from sysaudits_02 where extrainfo like "%err%"

Hi, Well not sure on the question - but a user is local to the Database - so if you have more than one DB, you need to create a user on each separate DB. As for the hierarchy, the DB runs on the server and the user logs in to the DB. Pls could you clarify more?

Hi John, I've used ASA 5 DB for years with a ASA 6 so not sure what the problems is? However ASA 6.0 -> 6.2 was quite buggy to say the least. What problems are you having? However, the easiest way to "upgrade" an DB is to unload the ASA 5 one and reload it in ASA 6. You can do all this vis...

Have you tried the "output to" command? Tom.

Hi Paul, How about this: select if exists (select 1 from table) then 1 else 0 endif from sys.dummy Tom.

Have you tried this: http://texturizer.net/firebird/faq.html#q2.2 Tom.

hi paul Try: select property ( 'LicenseCount'); select property ( 'LicensedCompany'); select property ( 'LicensedUser'); select property ( 'LicenseType'); Tom.

Not sure what your asking for here: do you want to speed up DB performance or create SQL reports quickly? In the former case, I found this page extremely useful: http://www.bcarter.com/tip077.htm In the latter case, that's all down to DB design! However, creating views maybe useful in...

Opps, it seems the "locate" function is an ASA SQL vendor extension. Must take more notice of "standards"!!!

Hi This is probably a task better suited for your front end. For example using a mask in Powerbuilder. Tom.

Hi, Have you tried unloading/reloading the DB? Tom.

Hi John, To change the DBA password you need to create a new DBA account (eg "DBA2" - how original!). Log out off the original DBA account and change the pw from the new one. Tom.

Hi ScanX, I think this link should answer your query: http://archives.postgresql.org/pgsql-performance/2002-12/msg00185.php However, in my experience, it is best simply to experiment with both and see which one gives you the best result. Tom.

okay try this select username, acct, (select count(acct) from table1 b where b.username = a.username) as acct_cnt from table1 a order by acct_cnt desc Tom.

Hi Jennifer, You could do something like this: select right( Manager_Name, char_length( Manager_Name) - locate( Manager_Name, ' ', -1)), Manager_Name from table; Of course, this fails when the manger_name contains inconsistencies such as 'Jr', 'III' or 'Del Balso'. You could get round this...