Search results for query: *

Well I hope this isn't too late getting to you. But, just in case anyone searches and needs this info too, you can find info about Syabse Drivers in my FAQ posted here. http://www.tek-tips.com/faqs.cfm?fid=3736 Thanks. -=-=-=-=-=-=-=-=- For ease of reading, any posted CODE should be wrapped...

Hi It's up to you which OS you want to us. ASE works on both of them. If you DO use Linux, read this page some things you'll have to prepare before you can get it fully working. http://www.mbay.net/~mpeppler/Linux-ASE-FAQ.html -=-=-=-=-=-=-=-=- For ease of reading, any posted CODE should be...

Hi Well we've, from time to time, wondered how strong Sybase is in the market and if they have the ability to fight back. Aside from thinking that the Sybase marketing and sales guys needed to get their act together I have been a BIG fan of Sybase for many years. They have had 'decent', albeit...

sp_helptext "object" Will dump the DDL of any create dobject in Sybase. Hope this helps. -=-=-=-=-=-=-=-=- For ease of reading, any posted CODE should be wrapped by and tags. Ex: [COLOR=purple]SELECT 1 from sysobjects[COLOR=black]

Hi In 12.5.0.3 or up you have a new function called newid() This generates a 16 bytes globally unique identifier. These are in the format of (varchar(32) or varchar(36)) Passing a non-zero value as a parameter 'switches' it from 32 chas to 36 by adding 'dashes' through the GUID. These...

You can get lots of information in the Sybase Performance and Tunig book which is downloadable from their website. Just follow the 'support' and documentaton links. -=-=-=-=-=-=-=-=- For ease of reading, any posted CODE should be wrapped by and tags. Ex: [COLOR=purple]SELECT 1 from...

The values reported by sp_spaceused are only as 'fresh' as your last update statistics. So update, then check the sp_spaceused if you require accurate values. (Or as accurate as sp_spaceused can be). -=-=-=-=-=-=-=-=- For ease of reading, any posted CODE should be wrapped by and tags. Ex...

You should look at how the UPDATE statement works again. You can do relations in T-SQL and avoid all those 'sub' selects. Ex: UPDATE User_file SET address1 = UF2.address1, address2 = UF2.address2, address3 = UF2.address3, address4 = UF2.address4, Postcode = UF2.Postcode...

If you ned to ignore the trailing blanks you can use varchar instead of char. varchar strips the trailing spaces automatically. There is no way to make it ignore the spaces via a configuration setting. Your query should not be "THAT" much longer when it runs as trim is run inline...

Use the various 'trim' functions like "ltrim() and rtrim()" -=-=-=-=-=-=-=-=- For ease of reading, any posted CODE should be wrapped by and tags. Ex: [COLOR=purple]SELECT 1 from sysobjects[COLOR=black]

Hi Try using the various "SET statistics" commands to ON like: SET STATISTICS TIME ON SET STATISTICS IO ON [COLOR=black] -=-=-=-=-=-=-=-=- For ease of reading, any posted CODE should be wrapped by [COLOR] and tags. Ex: [COLOR=purple]SELECT 1 from sysobjects[COLOR=black]

I am at a loss to suggest a solution. I even tried doing something with a variable as a 'text' datatype but you can't define them in a procedure.. how much of a pain is that. :/ I will ask my co-workers and see if one of them has any ideas, they are quite good at fixing these kind of quirky...

Why thank you very much!! Glad to be of help. -=-=-=-=-=-=-=-=- For ease of reading, any posted CODE should be wrapped by and tags. Ex: [COLOR=purple]SELECT 1 from sysobjects[COLOR=black]

My question to you. Why not explain WHY you want to omit columns dynamically and maybe I can suggest an alternative. Thanks. -=-=-=-=-=-=-=-=- For ease of reading, any posted CODE should be wrapped by and tags. Ex: [COLOR=purple]SELECT 1 from sysobjects[COLOR=black]

Hi This is definately a problem for the exact reason you mention. There is a limit to the length of the string (limited by the pagesize setting in your server) It can be as big as 16k now if you are using 12ASE .5, but you STILL have a limit. I do not know how you would accomplish this...

Running the command with no parameters will show you the syntax. Using the below example you can tell it which 'object' to print by specify it after the 'out <database>' piece of your command, So just add the <owner>.<object> ex: dbo.sp_youWanttoPrint to the end of your command. $ defncopy...

If you are using ASE then just use the LOAD DATABASE command. You can specify the filenames of the backup and file extension is really inconsequential. -=-=-=-=-=-=-=-=- For ease of reading, any posted CODE should be wrapped by and tags. Ex: [COLOR=purple]SELECT 1 from sysobjects[COLOR=black]

Hi Two ways you can do this. Specify the column list instead of *, this works assuming the columns are the same name in the source (From table) and destination (into table). Or, look at your solution in reverse and use the following: INSERT INTO Table1 VALUES (col1, col2, col3) SELECT...

Hi You should be able to use either, to make it work all ou have to do it put the .jar file in your classpath. http://www.sybase.com/detail?id=1009753 -=-=-=-=-=-=-=-=- For ease of reading, any posted CODE should be wrapped by and tags. Ex: [COLOR=purple]SELECT 1 from sysobjects[COLOR=black]

Hmmm I don't know Tivoli so I can't help you there. Can you copy/paste the input file here. May not be the problem but I notice that you don't have a linefeed after your command and your 'go' statement. Not ALWAYS the case but I have had problems with this on different flavours of the Unix...