I need to convert a "check amount" to a "written out amount in english", for check printing.

Ex) $ 582.71 ---> Five hundred eighty two and 71 cents

Tanakorn.U

• Apr 25th, 2014

I have the Question About XML file. Q1.File Format. Q2.How to Open And Read XML File with Power BUilder.

Suresh Saxena, Sr.Sybase Developer

• Sep 1st, 2013

I am working on Sybase ASE 12.5.3. I think there is no system defined function to convert currency to word in ASE. For this purpose i have written stored procedure that will convert the same.If you want to convert please write stored procedure which will solve your problem.

Answer Question  Select Best Answer

How we can add a NotNull Column in a table by using alter command (without using default command)?

Tejas More

 Profile Answers by Tejas More Questions by Tejas More

• Jul 7th, 2011

You can add a NOT NULL column to a table. This means that a constant expression, and not a null value, is placed in the column when the column is added. This also ensures that, for all existing rows, ...

UncaAlby

 Profile Answers by UncaAlby Questions by UncaAlby

• Oct 20th, 2008

First add the column as NULL. Then populate the column with non-null data. Then modify the column to NOT NULL. You may need to set dboption "select into" to True.

Answer Question  Select Best Answer

GregMark

 Profile Answers by GregMark Questions by GregMark

• May 5th, 2007

Index are handled automatically by Sybase database to speed up the query and in short to optimize the query .But in certain scenarios and situation the user may need to force the index for handling th...

Answer Question  Select Best Answer

christia

 Profile Answers by christia Questions by christia

• May 5th, 2007

Clustered index and Nonclustered indexes are the two type’s index handled by Sybase. In the case of Clustered index the physical and logical order are maintained in the same order by the process...

Answer Question  Select Best Answer

Ganapathi Masilamani

• Jul 5th, 2007

Live table will be created using: 1. Create table ( column name datatype ) 2. Select * into from e-x: select * into new_emp from emp Temp Table will be created using: 1. Create table ...

Answer Question  Select Best Answer

anubhashjain

 Profile Answers by anubhashjain Questions by anubhashjain

• Jun 18th, 2010

Workspaces are special tables in dbccdb that store intermediate results of the dbcc checkstorage operation. Workspaces differ from worktables in that they: --  Are preallocated contiguously ...

Answer Question  Select Best Answer

lakshmi mandava

• May 16th, 2007

Reports on permissions for database objects, users, groups, or roles. 

Answer Question  Select Best Answer

shamimaziz

 Profile Answers by shamimaziz Questions by shamimaziz

• Jul 21st, 2007

Solaris 32-bitSolaris 64-bitHP-UX PA Risc 64-bitIBM AIX 64-bitLinux x86 32-bitWindows x86 32-bitLinux on Power 64-bitLinux Opteron 64-bitSol Opteron 64-bitHP-UX Itanium 64-bit Windows Opteron X64

Answer Question  Select Best Answer

Sushil Kumar

• Jun 23rd, 2007

The minimum table size is equal to 1 extent (that is equal to 8 pages).

Answer Question  Select Best Answer

Reemi

• Apr 10th, 2007

dump tran database to physical name will make of the transaction that have occured against your database since the last transaction log dumpwhen we use dump tran database with truncate_only ,no copy o...

Answer Question  Select Best Answer

JamesMike

 Profile Answers by JamesMike Questions by JamesMike

• May 5th, 2007

The data types supported by Sybase are integer, smallint, tinyint, float, real, double precision, smallmoney, money, decimal, char(n), varchar(n), text, image, datetime, timestamp, timestamp, varbinary(n), binary(n) and bit.

Answer Question  Select Best Answer

santosh

• Apr 25th, 2007

use gosp_helpgoORuse goselect name,type from sysobjectsgo

Answer Question  Select Best Answer

manish hoiyani

• Dec 8th, 2006

If a col of table already had one default,,,  we cannot put any other default  on the same column..... but if is banking system and all we can zero  in place of null.

Answer Question  Select Best Answer

StephenRaj

 Profile Answers by StephenRaj Questions by StephenRaj

• May 5th, 2007

The table in Sybase can be deleted by using the command drop table. The syntax of this command is as below:drop table Then the window waits for entering the table name where the table name to be delet...

Answer Question  Select Best Answer

ssukralia

 Profile Answers by ssukralia Questions by ssukralia

• Dec 3rd, 2007

JDBC is a Application programming Interface which helps Java Developers to interact with Database like Sybase via DML Statements (Insert, Update, Delete and so on).

Answer Question  Select Best Answer

shamimaziz

 Profile Answers by shamimaziz Questions by shamimaziz

• Jul 21st, 2007

Partition is a old technology helps to access data faster (not actually faster) in almost all the databases. Sybase ASE 15.0 opens up a new possiblity of this. Sybase ASE contains semantic Partioning ...

Answer Question  Select Best Answer

amodsv

 Profile Answers by amodsv Questions by amodsv

• Mar 26th, 2008

The numeric and decimal typesare identical in all respects but one: Only numeric types with a scale of 0can be used for the IDENTITY column.

Answer Question  Select Best Answer

Gary C

• Jul 12th, 2007

In pre sybase 15 all database options will take effect after a use database and checkpoint command is run.For Sybase 15 the option take effect immediately since all sp_dboption commands have an automatic checkpoint.

Answer Question  Select Best Answer

mikeob

 Profile Answers by mikeob Questions by mikeob

• Jun 17th, 2009

Although there are numerous differences, probably the most relevant was the introduction of data-only (pages, row level) locking for tables in 12.x. That was the biggest one that shook up the Sybase c...

Answer Question  Select Best Answer

samala_naresh

 Profile Answers by samala_naresh Questions by samala_naresh

• Aug 13th, 2008

When you install Adaptive Server, it has single default data cache, with a 2K memory pool, one cache partition and a single spinlock. To improve performance you can add data caches and bind databases...

Answer Question  Select Best Answer