aspirantcoder.com
object_name | Aspirant Coder
http://aspirantcoder.com/tag/object_name
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Tag Archives: object name. Sybase : How to check programmatically if index contains particular column? May 9, 2013. So you’d like to check if a certain column is included in an index created on a table, that’s easy:. Index max rows per page. Unless you want to do that in a programmatic way, because parsing sp helpindex. Let’s check by looking at the sp helpindex source code:. Returns th...
aspirantcoder.com
SQL | Aspirant Coder
http://aspirantcoder.com/tag/sql
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Sybase : How to select random number within a specific range? December 24, 2012. Let’s say, I need a random number within a specific range, how do I do that? Here’s the code that will do it:. How to trace user activity to a file in SAP Sybase ASE. December 8, 2012. This video is a part of the SAP D&T Academy. Definitely worth checking out.). 8221; (opens pdf file in new window). Obvious...
aspirantcoder.com
Sybase | Aspirant Coder
http://aspirantcoder.com/category/sybase
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Sybase : How to check programmatically if index contains particular column? May 9, 2013. So you’d like to check if a certain column is included in an index created on a table, that’s easy:. Index max rows per page. Unless you want to do that in a programmatic way, because parsing sp helpindex. Unfortunately, there is no name of the column included in this table:. Returns the name of the...
sybanva.wordpress.com
Essential DBA Unix | Sybase Blog -Anything About Sybase ASE,REP,IQ.
https://sybanva.wordpress.com/2011/09/12/essential-dba-unix
Skip to main content. Skip to primary sidebar. Skip to secondary sidebar. Sybase Blog -Anything About Sybase ASE,REP,IQ. Anything About Sybase ASE,REP,IQ. Larr; bcp copy in failed. ASE 15.7 for SAP Business Suite Released in Techwave! I am listing the command which we are frequently used in our DBA unix enviorment. I would lile to thnx Abhay for sharing this. Su : Acquiring super user status. Su – henery : Crearting Other users (henery) environment. Passwd : Changing Passowrd. Calender : display calender.
sybanva.wordpress.com
Free Consulting | Sybase Blog -Anything About Sybase ASE,REP,IQ.
https://sybanva.wordpress.com/consulting
Skip to main content. Skip to primary sidebar. Skip to secondary sidebar. Sybase Blog -Anything About Sybase ASE,REP,IQ. Anything About Sybase ASE,REP,IQ. Free Database Consulting and Troubleshooting. Database planning to maintenance , total end to end solution for all DB related works for. On all major platforms. These services includes the High availability , replication between same. And different flavors databases, P& T tweaks and Data warehousing solutions. Database Planning and suggestions. Share o...
sybanva.wordpress.com
ASE 15.7 for SAP® Business Suite Released in Techwave!!! | Sybase Blog -Anything About Sybase ASE,REP,IQ.
https://sybanva.wordpress.com/2011/09/14/ase-15-7-for-sap®-business-suite-released-in-techwave
Skip to main content. Skip to primary sidebar. Skip to secondary sidebar. Sybase Blog -Anything About Sybase ASE,REP,IQ. Anything About Sybase ASE,REP,IQ. Larr; Essential DBA Unix. 20K Visitors in sybaseblog.com! ASE 15.7 for SAP Business Suite Released in Techwave! Most Awaited Database ASE 15.7 has been released yday in Vegas Techwave:. Extremely good news for Sybase Users! Http:/ www.sybase.com/detail? Http:/ www.sybase.com/asebuiltforbusiness. ASE 15.7 key features include:. Makes it easier to manage...
sybanva.wordpress.com
Interview Ques | Sybase Blog -Anything About Sybase ASE,REP,IQ.
https://sybanva.wordpress.com/interviewquestions
Skip to main content. Skip to primary sidebar. Skip to secondary sidebar. Sybase Blog -Anything About Sybase ASE,REP,IQ. Anything About Sybase ASE,REP,IQ. Adaptive Server Enterprises :. Q1: Please let me know system db names, what is the purpose of sybsystemdb? Q2: Suppose our tempdb is filling up or filled up, you cant recycle the db server, then what would be your steps? Q4: Suppose our temdb is not recovered ,can we create new database? Q7: Which feature of ASE15.o most impressed you and why? Q14: Wha...
aspirantcoder.com
stored procedure | Aspirant Coder
http://aspirantcoder.com/tag/stored-procedure
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. Tag Archives: stored procedure. Sybase : How to disable return status when executing stored procedure? January 21, 2013. Let’s say I want to run a stored procedure in an isql session and then send the result set via mail:. Isql -S server -U username -P passwd 1 set nocount on 2 exec PSTEST 'F', 7 3 go x y - - - - - - - A 1 F 7 Z 9 (return status = 0). Set proc return status off. Sybase ...
aspirantcoder.com
statistics | Aspirant Coder
http://aspirantcoder.com/tag/statistics
Nothing to see here, move along, this is just a coding playground…. Skip to primary content. Skip to secondary content. How to trace user activity to a file in SAP Sybase ASE. December 8, 2012. Today, I’ve been checking if there are any videos on YouTube on Sybase ASE’s dbcc traceon usage and I’ve found this interesting video by Lester Leonares about a nice functionality to log user activity to a file:. This video is a part of the SAP D&T Academy. Definitely worth checking out.). Sybase : How to check pr...