ase

how to pass a comma separated list to a stored procedure?

So I have a Sybase stored proc that takes 1 parameter that's a comma separated list of strings and runs a query with in in an IN() clause: CREATE PROCEDURE getSomething @keyList varchar(4096) AS SELECT * FROM mytbl WHERE name IN (@keyList) How do I call my stored proc with more than 1 value in the list? So far I've tried exec getSom...

Case insensitive search on Sybase

I have been sick and tired Googling the solution for doing case-insensitive search on Sybase ASE (Sybase data/column names are case sensitive). The Sybase documentation proudly says that there is only one way to do such search which is using the Upper and Lower functions, but the adage goes, it has performance problems. And believe me th...

Is there any way to run Python on Android ?

I like the Android platform. Actually, with some friends, we even participate to the ADC with the Spoxt project. But Java is not my favourite language at all. We are working on a S60 version and this platform has a nice Python API. Of course there is nothing official about Python on Android, but since Jython exists, does anybody know a ...

Quality of Sybase ASE support in Delphi

I have Delphi Professional 2007 and 2009 and was thinking of upgrading either or both to Enterprise due to a new project that requires me to interface to a Sybase ASE database. I did some web research and it appears that 2007 Sybase driver leaked memory and it doesn't appear that this problem was fixed. Does anyone know if the Codegear...

How can I interact with the android scripting environment from an android app?

I'd like to use python scripts as plugins for an app I'm developing. This seems to be possible by interacting with android-scripting-environment (ASE), as is done by Locale, but I haven't found any documentation about this. How you execute ASE scripts from your own app? ...

Sybase 15 performance issue

I am working with Sybase 15 in my application and there is performance issue related with nested joins. I have stored procedure which selects 2 columns from 2 tables and compares equalities of over 10 columns between this 2 tables. But when I run this stor. proc., the result takes 40 minutes. I added "set merge-join off" statement to top...

Can I port my existing python apps on ASE?

I learned that the Android Scripting Environment (ASE) supports python code. Can I take my existing python programs and run them on android? Apart from the GUI, what else will I need to adapt? How can I find the list of supported python libraries for ASE? ...

Where can I get 64 bit OLEDB and/or ADO.Net drivers for Sybase ASE?

I'm new to Sybase and so far it's a monumental pain just to connect to it! Where in the world can I get 64 bit drivers for Sybase ASE 15 so that I can connect from my 64 bit SQL 2008? Our Sybase servers are 32 bit and there are no 64 bit drivers on the media :( ...

How to get a Device Specific UID using Python in ASE on Android?

I am working on am Android Scripting Environment (ASE) script in Python to replicate an iPhone app. I need a device UID of some sort. My thoughts where a salted MD5 hash of the MAC address or device phone number, but I can't figure out how to access either of those using the Python APIs within ASE. What can I do to create a UID in Pyth...

Feedback on using ASE on Android?

Has anyone made use of ASE (Android scripting enviroment) for anything other than proof of concept apps? What are the major limitations? Any feedback would be great. ...

Importing Python modules without installing - Sybase ASE

I need to use the Sybase Python module but our SA's won't install because it's not in the repo's. I've downloaded it and placed it on the box and would just like to 'import' or 'include' the module without installing it first. - Is this possible? From the looks of it (Sybase ASE) it needs some type of compilation before use. Is it possib...

Is it possible to use Android scripts created with ASE as typical application for Android (e.g. written in Java)?

Hi, I am very very new to Android. I was encouraged to take a closer look at Android when I heard about possbility to write applications on Android in scripting languages like Python. This sounds great and in fact works great. I did some experiments and everything looks very interesting. I have noticed that I can either write my script...

Terminating android ASE shell from within the script

I'm using android scripting environment with python (ASE), and I'd like to terminate the shell executing the script when the script terminates. Is there a good way to do this? I have tried executing on the last line: os.system( 'kill %d' % os.getppid() ) but to no avail. ...

To update sender's messaging folder when sms is sent through script using ASE

By using sendSms() method of Android Scripting Environment(ASE) we can send sms from one emulator to another but the Sender's messaging folder is not updated with sent sms.....is there any way to do that? ...

How to determine how much disc space a table is using in ASE

I have a table which I think might be better off if it uses different data types for many of the columns. I wish to design some tests to determine the pay off in disc space if these columns are switched to better data types. How can I determine how much disc space a table is taking up in ASE 15.0? ...

Can we use android scripting environment for functional test automation?

Hi, I want to automate some of my functional test cases on android , can I use Android scripting environment and use Python / Perl to automate my functional test cases? Thanks AD ...