executing Proc's PB6.5 -Stored Procedures 11.02 vs Stored Procedures 11.9.2

Hi all,
   I had Migrated the database from 11.0.2 to 11.9.2. Powerbuilder is
not executing certain procedures called from event. But when a code of
Sqlca.Autocommit = True
is added before calling the Procedure it works.Anybody has any idea

thanx to all
ram

0
ram
7/28/1999 1:46:52 PM
sybase.powerbuilder.database 9855 articles. 2 followers. Follow

3 Replies
729 Views

Similar Articles

[PageSpeed] 18

Could it be that the 2 databases are configured differently with respect
to chained mode, for example?

Do your sp's attempt to create temp tables or perform any other DDL?

steve
[TeamSybase]

ram wrote:
> 
> Hi all,
>    I had Migrated the database from 11.0.2 to 11.9.2. Powerbuilder is
> not executing certain procedures called from event. But when a code of
> Sqlca.Autocommit = True
> is added before calling the Procedure it works.Anybody has any idea
> 
> thanx to all
> ram
0
Steve
7/29/1999 7:27:08 PM
Steve didn't understand the problem correctly...


Once you load the database, generate DDL statements in old database (11.0.2)
and  drop all the procedures in the new
database (11.9.2) and reload from DDLs.



Steve Katz [TeamSybase] <katz_s@jpmorgan.com> wrote in message
news:37A0AB0C.6E956452@jpmorgan.com...
> Could it be that the 2 databases are configured differently with respect
> to chained mode, for example?
>
> Do your sp's attempt to create temp tables or perform any other DDL?
>
> steve
> [TeamSybase]
>
> ram wrote:
> >
> > Hi all,
> >    I had Migrated the database from 11.0.2 to 11.9.2. Powerbuilder is
> > not executing certain procedures called from event. But when a code of
> > Sqlca.Autocommit = True
> > is added before calling the Procedure it works.Anybody has any idea
> >
> > thanx to all
> > ram


0
Hari
8/11/1999 7:28:58 AM
What does your response have to do with trying to execute procedures
from an event?  I don't think the problem is loading the procedures into
the DB, I think the problem is related to execution of the procedures
from PB during runtime.

I guess Ram should clarify with a response.

steve
[TeamSybase]

Hari Minchala wrote:
> 
> Steve didn't understand the problem correctly...
> 
> Once you load the database, generate DDL statements in old database (11.0.2)
> and  drop all the procedures in the new
> database (11.9.2) and reload from DDLs.
> 
> Steve Katz [TeamSybase] <katz_s@jpmorgan.com> wrote in message
> news:37A0AB0C.6E956452@jpmorgan.com...
> > Could it be that the 2 databases are configured differently with respect
> > to chained mode, for example?
> >
> > Do your sp's attempt to create temp tables or perform any other DDL?
> >
> > steve
> > [TeamSybase]
> >
> > ram wrote:
> > >
> > > Hi all,
> > >    I had Migrated the database from 11.0.2 to 11.9.2. Powerbuilder is
> > > not executing certain procedures called from event. But when a code of
> > > Sqlca.Autocommit = True
> > > is added before calling the Procedure it works.Anybody has any idea
> > >
> > > thanx to all
> > > ram
0
Steve
8/11/1999 2:20:59 PM
Reply:

Similar Artilces:

replicate ASE 11.0.3 via R.S. 11.5 to ASE 11.9.2
Has any one successfully replicated from 11.0.3 using Rep Server 11.5 to ASE 11.9.2 using ltm's? We are running on solaris 2.6 using veritas filesystem and keep getting stack traces (this shuts down the connection). I would like to know if anyone else has replicated using these versions or something similar. Thanks. kboniface@worldres.com Yes, I have done this. No specific problems. HTH, Rob -- ---------------------------------------------------------------------- Rob Verschoor Certified Sybase ASE 11.5 Administrator (Professional) Certified DBA/Performance...

11.5.1 VS 11.9.2
Wich is better for intensive transactional work ? (about 40 users) TIA Bruno Franx wrote: > > Wich is better for intensive transactional work ? > (about 40 users) > TIA I would go with 11.9.2 as you get all of the 11.5 features and there are quite a few new features in addition to Row-level locking. Lance team sybase -- =============================================================================== Lance J. Andersen Email: lancea@sybase.com Sybase Product Support Engineering Phone:(781) 564-6336 77 South Bedford Street Fax: (781) 564-6148 Burlin...

Which is Better 11.5.1 Vs 11.9.2
Hello Gurus, I know this discussion keeps popping up all the time. It's my turn now. I have around 18 servers mostly running on 11.0.3 SWR 7312. I need to move them on to y2k Complaint sybase versions. The point is I suggested 11.9.2 considering all factors. But Now i am in a dilemma. Whether to Move to 11.9.2 or stay with 11.5.1. I need first hand experience before i decide. Since My setup is very complicated If we decie to move on a particular direction, rolling back is impossible. Kindly share your upgrade experiences, Some problems you faced and any other vital...

11.9.2 -> 11.9.2.5: errors from installdbccdb and instcomm
I recently upgraded from 11.9.2 to 11.9.2.5 using EBF9620. I unzipped the downloaded upgrade file and overwrote the files in the $SYBASE tree. I then proceeded to run the upgrade scripts as directed in the cover letter (scripts located in $SYBASE\scripts). The "instmstr.sql" and "instmsgs.ebf" scripts ran just fine, but the "installdbccdb" and "instcomm" scripts produced some errors about objects not being found. The server appears to be operating just fine, but I wanted to know if I should be concerned about these errors. "ins...

Load 11.9.2 backup's into 11.0.3
Hi, Is it possible to load 11.9.2 backup's into 11.0.3 dataserver ? Thanks, Andr� Hi Andre, Nope. You can only load database dumps into the same version or newer versions. I would suggest taking a look at SQL Remote (included with ASE 11.9.2) if you want to keep the data in sync. Note that for heavy replication, you should use Replication Server. j "Andr� Castanheira" <andre.castanheira@cariocaengenharia.com.br> wrote in message news:39ABF553.E93D793C@cariocaengenharia.com.br... > Hi, > > Is it possible to load 11.9.2 backup's ...

Generating catalyst 9.11 rpm's on openSUSE 11.2
since catalyst 9.10 now package generation is somehow broken (at least for me) but I got it to work (described 'here' (http://tinyurl.com/yfzv8le)) I refined the workaround and build a shell script which does all that automatically for you ( I don't see a file upload here, so I'll put the script in text): catalyst_911-suse112.sh Code: -------------------- #!/bin/bash sh ./ati-driver-installer-9-11-x86.x86_64.run --extract fglrx-install.11 pushd fglrx-install.11 patch -p1 < ../fglrx-install.11.diff if [ X`uname -m` = "Xx86...

Transferring database ASE 11.9.2 -> ASE 11.5
Hello, I need to transfer a database from a ASE 11.9.2 server to a ASE 11.5 server. (Servers have the same specs and run Windows NT 4.0). The database doesn't have many objects such as tables, users, Views, SP's etc. etc. It has a 400 MB device for data and 100 MB Device for the log, with standard segmentation. It's relatively small. I understand from this newsgroup that dumping on a newer release and loading on an older release is not an option. Now I figure I have to do the following: - Create a data and a log device with similar names and sizes on the ASE 11.5 se...

Query showplan is different in 11.0.3 and 11.9.2 for tne same procedure
Hi, I'm trying to improve performance of some of the stor procedures. They were migrated from Sybase 11.0.3 to ASE 11.9.2. Procedure's text is the same and number of rows in the tables that this procedure is working with is also the same, statistics is updated and procs are recompiled. But when I took a look at showplan output I found significant differences between generated showplans. For instance: <<<<<<<<<<<< in ASE 11.9.2 >>>>>>>>>>>>> QUERY PLAN FOR STATEMENT 1 (at line 1). STEP 1 ...

From 11.5 to 11.9.2
I�m installing ASE 11.9.2 in a new NT box. I will recreate all objects from another server. But i have a question about logins and users: Before i need to go from 11.0.1 to 11.5 and i just bcp'ed out the syslogins table to a text file, delete the first two rows and then, i bcp'ed in the new server, and all was fine. In one of the release bulletin it says something about the probe login, that its suid has been changed in the new version, someone has done this process successfully?, which guidelines could i follow? Another one, in the same new server i am going to recreate objects...

ASA 9.02 (3124)
Hello i have the problem, that a remote-proc. don't work in my PB.application - i defined it in my transaction object as SUBROUTINE..... the procedures from the database work fine. now i defined in the ASA-Database a function, that called the remote-procedure -> and the function i declared it in my transaction-object as FUNCTION ....... and it work's fine!!!! is there any problem or limitation the use remote-procedures in a PB-transaction-object???? thank's for explanation.... Michael M.Erlinger wrote: > Hello > > i have the problem, that ...

RFI
Hi, Is it worth going to 11.5.1 considering 11.9.2 is out? I'm looking for information about upgrading 11.0.3 to 11.5.1 or 11.9.2 on HP-UX. Looking for advice, tips & tricks, pitfalls, etc I'm also interested in other peoples exeriances with 11.5.1 and 11.9.2 with regaurds to performance, stability, bugs & problems. thanks in advance Andrew. -- The views expressed are those of the author, not necessarily of Innovus Limited. Andrew, When I took the "Powering-up for ASE 11.5" class from Syba...

Download Database from ASE 11.9.2 to ASE 11.0.2 ?
Dear All: We have a Sybase ASE11.9.2 on Window NT, and we already run some application on it about 6 months. Since the third party software we use cann't support ASE11.9.2, we must use ASE 11.0.2. Can we just backup the database of ASE11.9.2 then restore the backup database to ASE11.0.2 ? Has it any problem ? Or, We must do following procedure. 1) bcp out the data from ASE11.9.2 2) create the database on ASE11.0.2 3) bcp in the 1) data to ASE11.0.2 Can anyone tell me?? Teresa Young Teresa, The problem with dump and load is that the log format in 11.9.2 is much diff...

Upgrade from 11.0.3.3 SQL Server to 11.9.2 with RepServer 11.5
I am preparing to upgrade our production servers (11.0.3.3) using RepServer 11.5 with LTMs. My understanding is that the ASE 11.9.2 has RepAgents build in as Open Server applications. Are there any issues with upgrading that I need to be aware of? Where would I look? I would assume that I don't need to run LTMs anymore, but I need to ensure no loss of replication to the warm standby. Any advice? Take care. JCS ...

Upgrade 11.0.3.3 to ASE 11.9.2 with RepServer 11.5 and LTMs
I am preparing to upgrade our production servers (11.0.3.3) using RepServer 11.5 with LTMs. My understanding is that the ASE 11.9.2 has RepAgents build in as Open Server applications. Are there any issues with upgrading that I need to be aware of? Where would I look? I would assume that I don't need to run LTMs anymore, but I need to ensure no loss of replication to the warm standby. Any advice? Take care. JCS ASE 11.5+ has RepAgent built in as internal server threads (which has nothing to do with OpenServer). When upgrading, keep the LTM's and upgrade to RS 11.5 / ...

Update index stats on 12.5.0.3 consumes more procedure cache that 11.9.2 ??
Hi, Recently upgraded 11.9.2 (SWR 8939) to 12.5.0.3 ESD #4.(EBF 11442). Frequently getting "Procedure cache not enough" messages when running 'update index statistics' on some of the big tables (1.5 GB) size. I believe I have configured the procedure cache correctly in the new server (Memory used is even more than 1192). In 11.9.2 :- 1> sp_configure "procedure cache" 2> go Parameter Name Default Memory Used Config Value Run Value ------------------------------ ----------- ----------- ------------ -------...

Web resources about - executing Proc's PB6.5 -Stored Procedures 11.02 vs Stored Procedures 11.9.2 - sybase.powerbuilder.database

Resources last updated: 11/27/2015 3:25:04 PM