Re: How to pass qmark style parameters from python to MaxDB

2005-12-02 Thread Eduards Mihelovics
Thank you very much, that solves my problem. Eduard On 12/2/05, Stephan Herrlinger <[EMAIL PROTECTED]> wrote: > > Hi, > > try this > > > cursor = session.sql("select * from messages where msgno > 0") > for row in cursor: > value_1 = row[0] > value_2 = row[1] > > > or > > statement

How to pass qmark style parameters from python to MaxDB

2005-12-02 Thread Eduards Mihelovics
Hi, I am using MaxDB 7.6 with python. I expect that it should be possible to pass parameters to SQL queries like this: cursor = session.cursor () cursor.execute ('select * from messages where msgno > ?', [0]) However, my sapdb session does not have cursor() method. Anyone can tell me, what method

Timestamps without leading zeros

2005-12-02 Thread Jan Lendholt
Hi Folks, we finally migrated from SAP DB 7.4 to MaxDB 7.6 and its performance is just amazing. We stillt got a problem with our Timestamps. We have a Table called event where the colums DAY, MONTH and YEAR are saved. The Days / Months are being saved witout leading zeros. If we now perform

database instance creation via CLI doesn't work

2005-12-02 Thread Orlando Andico
following the SAP Library, i've tried creating a database instance following the script below. i installed all the relevant files via RPM install. # ./dbmcli -s db_create ig ig,ig (from UNIX prompt) # ./dbmcli -d ig -u ig,ig -i dbcreate.sh (from UNIX prompt) param_startsession param_init OLTP para

Re: Is there a Data Dictionary or MetaData for SAP databases & tables?

2005-12-02 Thread Robert Klemme
Am 02.12.05 schrieb Nahpets Naizonava <[EMAIL PROTECTED]>: > Hello, this message is posted in both English, and mein schlechtes Deutch: > > ***In English*** > Hello, > My wife is an SAP DB Administrator, and she's desparately trying to find > some good documentation on a Data Dictionary or MetaData