MySQL Forums - Sybase

I NEED YOUR HELP PLEASE (no replies)

Gabby Takash — Sat, 21 Nov 2009 14:38:56 +0000

Dear Database Support Professional,

I am Database Administrator and I am writing to ask for your help in responding to a 10-12 minute survey for a degree requirement on relational database support professionals in the USA. Please note that the respondent is completely anonymous. If I don’t get this portion of my degree completed by the end of this semester, then I would have to wait for another year which entails additional costs and time on me. By completing the survey, you will be contributing to research in our field and also there is the satisfaction of having helped a fellow professional and a fellow human being attain his goals. I believe a good turn always bring another in some way in our lives. I therefore kindly beg for your help to a fellow database professional by completing this survey. The link to the survey is provided below. If possible please forward to other database professionals or groups:
http://www.surveymonkey.com/s.aspx?sm=a1JqU7GVt1g6rCkIPyL23w_3d_3d

Thank you earnestly for your kindness.
Gabriel

Data truncated while loading (no replies)

Harirpiya Vedula — Tue, 10 Nov 2009 07:44:44 +0000

hi,

I have exported tables data from sybse to CSV file. and run the laod command LOAD DATA LOCAL INFILE './path.INTO TABLE table name FIELDS TERMINATED BY '|' ENCLOSED BY '' LINES TERMINATED BY '\r\n'(columns);

for some of the tables it worked fine.but for some tables where column data is more, it came to three lines. so it has taken second line as another record.

for example:

3 | 194 | 1 | Need Quote | per Rich's specifications in phone msg of 9/20/2001. Lump at 23, in between payments and retirment payments, 3 options using $240,000 per child | 2001-09-25 00:00:00.0 | N/A | Yes | null | null | 1 | Normal | null

i want this to be inserted in one single row.

thanks in advance....

How To get the Number of rows scan less when we take difference between the dates (no replies)

Amit Tripathi — Thu, 01 Oct 2009 05:32:26 +0000

Migration toolkit custom datatype (no replies)

Mike WALDMAN — Thu, 20 Aug 2009 14:06:28 +0000

Hello,

I'm trying to migrate a sybase ASE DB to MySQL.
I have a custom datatype in sybase, which cause the migration to fail. I know that mysql doesn't support custom datatype, how can I tell the toolkit that the custom datatype should be replaced by the corresponding type?

Thanks for the help!

Mike

Getting updated rowcount in Powerbuilder (4 replies)

Shawn Pleska — Tue, 29 Sep 2009 20:45:42 +0000

I'm issuing an embedded update in my code and I need to be sure the proper number of rows have been updated. Using the transaction management variable SQLNRows, when updating to Sybase ASE I used to be able to check this value for the update rowcount. For instance, if 1 row was updated, the value would be 1. If no rows were updated, the value would be zero. In my transition to MySQL, I've noticed that the same result is not being returned. For instance, in my testing I've learned that when the embedded update causes no rows to be updated, the value in SQLNRows is 1 when my code expects the value to be zero. That of course causes BIG problems. It seems to me like a success/failure code is being returned in SQLNRows rather than an update rowcount.

Is there a configuration setting or a database parameter that would make the value returned to Powerbuilder from MySQL in the SQLNRows transaction variable be the number of rows updated?

Thanks,
Shawn

ODBC Remotely (no replies)

Mariam Adel — Thu, 02 Jul 2009 15:03:29 +0000

Please I would like to know how to fill the ODBC form to connect on the database I created on mysql on my domain on yahoo .

Thanks in advance .

database consistency check command in mysql (no replies)

Muslim Abdul KADER — Fri, 24 Apr 2009 21:40:02 +0000

Like in Sybase's "dbcc checktable(table_name)" which gives the logical pagesize and data pages of a table, how do i find the logical pagesize and data pages of a MySQL table.

SELECT statement that should not return the "XXX rows affected line" (1 reply)

Muslim Abdul KADER — Sat, 25 Apr 2009 16:43:17 +0000

I need to write a select statement, that should produce just the output and should not show up the "no of rows affected" in its output.
for example

1> select * from Tester

TesterId TestCompId TestprovId -----------
0 0 0
2280638 2280638 1000
2280639 2280639 1000
2280640 2280640 1000
2280641 2280641 1000
2280642 2280642 2000
2280643 2280643 2000
2280644 10270970 1000
2280645 2280645 2000
2280646 2280646 2000
5300522 5300522 2000
5300523 5300523 2000
5300524 5300524 2000
5309074 5309074 2000
5573907 5573907 2000
5909156 5909156 1000
5915339 5915339 1000
6879589 6879589 1000
8155084 8155092 2000
10270973 10270973 1000
12746835 12746837 1000
14197273 14197273 1000

(22 rows affected)

I do not want the (22 rows affected) line. What do i need to add in the select statement to eliminate this?

set nocount equivalent (1 reply)

Muslim Abdul KADER — Wed, 06 May 2009 15:57:53 +0000

In my existing application that uses sybase, i have "set nocount on" to disable the count of rows displayed out of a select statement.

Now, that we are migrating to MySQL and i cannot use "set nocount on", is there a way that i can implement on MySQL that provides the same functionality as "set nocount on". ?

Line Brek Problem while migrating. (no replies)

Noah Selva Raj — Wed, 18 Feb 2009 10:52:12 +0000

After we'd sucessfully migrated from Sybase ASA, but after that we found instead of Link Break here its added with x0dx0a. Please anybody advice us how to avoid this while migrating

voice broadcasting (1 reply)

sara palin — Wed, 10 Jun 2009 07:54:24 +0000

If you are looking Quaity and Economical solution for your Voice Broadcasting needs.

Contact me. I offer the LOWEST Rate in market with guarantee!

Remember you can get Pay As you Go as well as One time solution too.

You can contact me by email on: vb@gittl.co.uk

Capture Live Web Data (no replies)

Snow Man — Thu, 27 Nov 2008 01:34:11 +0000

Is there a method for capturing live data from a foreign web site similar to this method in SyBase?

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.stf.help.mb/mb000000150.html

Alternate Suggestions or Reading?

Thanks!

Where is the storage place in sybase? (1 reply)

Mathan K — Mon, 11 May 2009 04:43:12 +0000

Hi Friends,
This is Mathan. I am new to Sybase and this Forum.
I have some questions related sybase ct_lib API's.

Example:
Database.exec()
Database.bind()
Database.next()
Database.get_result()

when doing the above proceture, the query is sending to sybase via cl_lib. Sybase will fetch the records based on the query by user. Suppose here we have 10000 fetched records by sybase.
Now we can use get_result() method to get all the fetched records.

My question is:
1) Are fetched records stored in sybase end?
If yes, the ct_next() will call for every already fetched record and forward to application???
2) or ct_lib is maintaining any space to store all the fetched records.
If yes, can we get the all fetched records to application, when sybase is unavailable ?????

Please can anyone help me on this

/MaK

Sybase ASE to MySQL Migration Guide (no replies)

Rey Wang — Tue, 02 Sep 2008 03:21:08 +0000

Sybase web site has this, MySQL to Sybase ASE Migration Guide

http://www.sybase.com/detail?id=1051522

Any migration guide for ASE to MySQL, topics on dbcc, raw devices, sp_helpdb, engine configuration, shared memory configuration.

Thanks

Converting Sybase Anywhere Studio 8.0.3 to MySQL 5.0 (1 reply)

Guenther Beike — Sat, 25 Oct 2008 02:02:33 +0000

Hi,

I got the job to transfer a Sybase database to mysql. For test purposes I installed Sybase Anywhere 8.0.3 on a Windows 2000 computer with the default database asademo from Sybase (user ID: DBA, password: SQL). Also on the same machine the migration tool. As hostname I use either the IP-address of the machine or localhost; port adress is 2638). Nothing will help to make a valid connection to the server. I allways get the following error messages.

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class Sybase JDBC Driver
Opening connection ...
Connection jdbc:jtds:sybase://144.6.1.8:2638/asademo;user=DBA;password=SQL;charset=utf-8
The list of schema names could not be retrieved (error: 0).

ReverseEngineeringSybase.getSchemata :Login failed

Details:
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
net.sourceforge.jtds.jdbc.TdsCore.tdsLoginAckToken(TdsCore.java:2917)
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2230)
net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:599)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:331)
net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)
net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141)
com.mysql.grt.modules.ReverseEngineeringSybase.getSchemata(ReverseEngineeringSybase.java:87)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

Is there anyone who has an idea what's going wrong?

Thanks,

Guenther

if statement (no replies)

juan Perez — Wed, 26 Sep 2007 18:23:55 +0000

Hi everyone !!!

I need help con this...
I have in sybase this sentence

if (exists(select column1 from tabla1 where column1=value1))
begin
update tabla2 set column2=value2 where column3=value3
update tabla3 set column4=value4 where column5=value5
end

How I can do it in mysql?

Thanks...

API for C linking problems (no replies)

Mario Rossi — Fri, 14 Sep 2007 13:58:40 +0000

Hi,
I'm trying to make a client application in C, connecting to a mySQL database. Platform is: Windows, LCC-32. In the source code I have declarations:

#include
#include "resource.h"
#include
#include
#include

and test code:

MYSQL * mysql;
mysql = mysql_init(NULL);

using the linker to take the library file:

mysqlclient.lib

And I have an output like this:

Wedit output window build: Fri Sep 14 15:55:14 2007
.data section assumed
...
.data section assumed
File c:\lcc\lib\mysqlclient.lib contains unknown section .sxdata.
.data section assumed
...
.data section assumed
File c:\lcc\lib\mysqlclient.lib contains unknown section .text$yc.
.text section assumed
File c:\lcc\lib\mysqlclient.lib contains unknown section .CRT$XCU.
.data section assumed
...
.data section assumed
File c:\lcc\lib\mysqlclient.lib contains unknown section .sxdata.
File c:\lcc\lib\mysqlclient.lib contains unknown section .text$yc.
.text section assumed
File c:\lcc\lib\mysqlclient.lib contains unknown section .CRT$XCU.
.data section assumed
...
.data section assumed
.data: undefined reference to '??_7type_info@@6B@'
.rdata: undefined reference to '__purecall'
Error c:\lcc\lib\mysqlclient.lib: Undefined (*UND*). Symbol ??_EMessage@yaSSL@@UAEPAXI@Z
c:\lcc\bin\make.exe
Compilation + link time:0.2 sec, Return code: 1

What is happened? How I can resolve this problem?
Thanks

Calling a stored procedure from select (2 replies)

UDAYA YARASI — Wed, 12 Mar 2008 20:51:56 +0000

Hi,

Can anyone let me know if it possible to call a stored procedure in a select statement

For example

SELECT Account_ID, Account_Number, Currency, (Exexute the stored procedure passing to it the Account_ID) AS Current_Amount FROM Accounts

Thanks!

Help dividing two values from different tables. (no replies)

angelo antonio — Sat, 14 Jul 2007 12:56:12 +0000

Hi, I am completly new in ASP , but, due the necessity of the production in the company I work, I need
urgently to learn do deal with scripts and SQL.

I did a script that shows on the production screen the consume tax of the gas instantly on time and it

worked. Now I have to do a table formed by the DIVISION of a valor V from one table by the valor V in

another table, mas the values must be taken at the same time do give me the gas consumed by ton produced.

Explaining in details:

I have two tabels:

1 - PDE#HD#Consumption#RP_Consumption_Gas
2 - PDE#HD#SpeedCurves#Productivity

Inside each of these tables, there are two columms with the same name for both -> V, T. The V columm of the

table PDE#HD#Consumption#RP_Consumption_Gas gives me the cas consumed and the V table of

PDE#HD#SpeedCurves#Productivity the productivity. The V1/V2 graph must be ploted in a 24 hours period. What

happens is that if I do it for 24 houres, I mean, 1 day, the graph is ploted completly wrong in time! If I

do the same thing, but using only one columm, not the division by another, it works! Why this is happening ?

What is wrong with the following script ?? I need to know the answer for this as fast as possible! If you

need more details, I will give.

The script:

DayForm = Request.Form("D1")

Dim hoje
Dim dia

If DayForm = "" OR DayForm = 0 Then hoje = true

If hoje Then _
Set rs = conn.Execute("SELECT

convert(varchar,PDE#HD#Consumption#RP_Consumption_Gas.T,108),(PDE#HD#Consumption
#RP_Consumption_Gas.V/PDE#HD#SpeedCurves#Productivity.V) As Consumo FROM

PDE#HD#Consumption#RP_Consumption_Gas INNER JOIN PDE#HD#SpeedCurves#Productivity ON

PDE#HD#Consumption#RP_Consumption_Gas.T = PDE#HD#SpeedCurves#Productivity.T WHERE

PDE#HD#Consumption#RP_Consumption_Gas.T > DATEADD(dd, -1, GetDate()) ORDER BY

PDE#HD#Consumption#RP_Consumption_Gas.T") _
Else _
Set rs = conn.Execute("SELECT

convert(varchar,PDE#HD#Consumption#RP_Consumption_Gas.T,108),(PDE#HD#Consumption
#RP_Consumption_Gas.V/PDE#HD#SpeedCurves#Productivity.V) As Consumo FROM

PDE#HD#Consumption#RP_Consumption_Gas INNER JOIN PDE#HD#SpeedCurves#Productivity ON

PDE#HD#Consumption#RP_Consumption_Gas.T = PDE#HD#SpeedCurves#Productivity.T WHERE

PDE#HD#Consumption#RP_Consumption_Gas.T > convert(date, DATEADD(dd, " & DayForm & ", GetDate())) AND

PDE#HD#Consumption#RP_Consumption_Gas.T < convert(date, DATEADD(dd, " & DayForm+1 & ", GetDate())) ORDER BY

PDE#HD#Consumption#RP_Consumption_Gas.T ")

Too many key parts specified (1 reply)

Aldo Herrera — Tue, 09 Oct 2007 13:00:34 +0000

Hello:

I'm migrating table that have more than 16 key parts, and i cant created it in Mysql. What should i do? As i understand, i have 2 options:

1. Create an id as identity column, making this column the key for the table, and left the real key outside of the key.
2. Create insert and update trigers that will concatenate all the fields of the key in one field wich would be the key for the table.

Which implementation would you recomend? Or if you have other ideas? Which one would be faster to use with heave selects and other operations?

Thankyou in advance!

Adding 7 days to a date (1 reply)

Anjel — Wed, 31 Jan 2007 23:24:20 +0000

I am trying to remove data from a table in a database. Like a sort of archiving processes whereby I remove one week of data at a time.

So I select the min date from the table (select min (TIMESTAMP) from )

Which returns a date in the following format -> 20070114 13:22:59.843671 +0000?

I want to be able to add seven days to that field so I will end up with 20070121

And then I can delete from table name where TIMESTAMP < '20070121'

Any suggestions?

Thanks

Anjel

Sybase 5.0 .db file (1 reply)

Tue, 04 Sep 2007 09:40:58 +0000

I have an old .db file from sybase 5.0 I want to migrate the data to mysql.

Are there any programs out there that does the converesion.

or How can I connect to it using php, c or some language to retrieve the data. (I believe there are no longer odbc drivers)

How to edit sql script in Manual Editing in Migration Tool (no replies)

Romel — Tue, 07 Nov 2006 07:55:34 +0000

Hi

Im trying to port a Sybase to Mysql. So far i've only migrated one schemata (table) out of 30. I look at the table details (in Manual Editing stage) under the column and it says that "data type ID can not be migrated." However other variables in that same table are said to be migrated succesfully. But in the end only one table was successfully migrated. How can i edit the script in MTool - those that create table and change datatype? Also i noticed that most of the non migrated objects are of data type 'ID'. Is there a way i can just change this ID to a data type that is acceptable to mySql? The summary report says about the Routines: "The generated SQL has to be checked manually."

How to port from Sybase (1 reply)

Romel — Fri, 27 Oct 2006 05:35:50 +0000

Hi. Im a newbie. I was asked to investigate how to Port a Sybase to mySql. I need to know the procedure to do it. Can it be possible to do this if the Sybase is on linux and mySQL is windows?

Backups like in MySQL in Oracle (1 reply)

Hauke Meier — Fri, 23 Feb 2007 08:38:10 +0000

Hello,

I am new in Oracle, and I love mySQL, but my company wants me to use oracle. A/W maybe you can help me, cause the most oracle forums are dead or I couldn't find any. My problem is, that I work on two computers. Both have Oracle 10g Express Edition. I want to have on both systems the same database structure and content. If I change something on one of the systems I want to make a Dump like with mysql to a plain text file, send it to the other and restore it.
With sql it works fine, but in oracle I couldn't find any solution for that. On Linux and mysql you have also to possibility to copy the files from /var/lib/mysql/... but I have no idea where the files are for oracle on a windows machine.

Can somebody help me?
And sorry for my worse english, I am from germany.

Thank you
Hauke

facing - The SQL Server is terminating this process error (no replies)

shubhada khawase — Mon, 25 Sep 2006 08:56:27 +0000

Hi All,
I have one proceudre for which I am facing problem. when I execute this procedure I got the following error

Server Message: Number 5702, Severity 10
Procedure 'cm_find_ratetable', Line 57:
The SQL Server is terminating this process.
Client Message: Layer 1, Origin 1, Severity 1, Number 167
ct_cmd_drop(): user api layer: external error: This routine cannot be called because the command structure is in an undefined state.

Following is my procedure :
CREATE proc cm_find_ratetable
(
@payerpricingname varchar(30)= NULL,
@rulename varchar(30)= NULL,
@contractid varchar(40) = NULL,
@payerid varchar(20)= NULL,
@alldates varchar(10)=NULL,
@sortfield varchar(30)=NULL,
@sortorder varchar(10) = NULL
)
As
Begin

declare @percent char(1),
@orderby numeric,
@maxeffective smalldatetime

select @percent = '%'

if(@sortfield= 'PayerPricingName')
select @orderby =1
else if (@sortfield= 'RuleName')
select @orderby =2
else if (@sortfield= 'Effective')
select @orderby =3
else if (@sortfield= 'Termination')
select @orderby =4

if @payerpricingname !='%'
select @payerpricingname = @payerpricingname
else
select @payerpricingname = @percent

if @rulename !='%'
select @rulename = @rulename
else
select @rulename = @percent

if @contractid !='%'
select @contractid = @contractid
else
select @contractid = @percent

if @payerid !='%'
select @payerid = @payerid
else
select @payerid = @percent

if (@alldates = 'Y')
Begin
if (@sortorder = 'D')
begin
select PayerPricingKey,
PayerPricingName,
RuleName,
Effective,
Termination
from
(select distinct
PayerPricingKey,
PayerPricingName,
PR.RuleName ,
PR.Effective,
PR.Termination
from PayerPricing PR ,
TermInRule TIR ,
TermRule TR ,
ContractTerms CT ,
LookCCntrct LCC ,
PayerProfile PP
where TR.TermKey = CT.TermKey and
LCC.ContractID = CT.ContractID and
TIR.TermRuleKey = TR.TermRuleKey and
PR.PayerPricingName = TIR.InputValue and
PR.PayerPricingName like (@payerpricingname) and
PR.RuleName like (@rulename) and
LCC.ContractID in (select distinct ContractID from PayerContracts
join PayerProfile on
PayerContracts.PUID = PayerProfile.PUID and PayerID like (@payerid)) and
LCC.ContractID like (@contractid)
)RatesTbl
ORDER BY CASE
WHEN @orderby= 1 THEN PayerPricingName
WHEN @orderby= 2 THEN RuleName
WHEN @orderby= 3 THEN convert(varchar,Effective,120)
WHEN @orderby= 4 THEN convert(varchar,Termination,120)
ELSE PayerPricingName
END
DESC
end

else
begin
select PayerPricingKey,
PayerPricingName,
RuleName,
Effective,
Termination
from
(select distinct
PayerPricingKey,
PayerPricingName,
PR.RuleName ,
PR.Effective,
PR.Termination
from
PayerPricing PR ,
TermInRule TIR ,
TermRule TR ,
ContractTerms CT ,
LookCCntrct LCC ,
PayerProfile PP
where TR.TermKey = CT.TermKey and
LCC.ContractID = CT.ContractID and
TIR.TermRuleKey = TR.TermRuleKey and
PR.PayerPricingName = TIR.InputValue and
PR.PayerPricingName like (@payerpricingname) and
PR.RuleName like (@rulename) and
LCC.ContractID in (select distinct ContractID from PayerContracts
join PayerProfile on
PayerContracts.PUID = PayerProfile.PUID and PayerID like (@payerid)) and
LCC.ContractID like (@contractid)
) RatesTbl
ORDER BY CASE
WHEN @orderby =1 THEN PayerPricingName
WHEN @orderby= 2 THEN RuleName
WHEN @orderby = 3 THEN convert(varchar,Effective,120)
WHEN @orderby = 4 THEN convert(varchar,Termination,120)
ELSE PayerPricingName
END
end

end

else
if (@sortorder = 'D')
begin
select PayerPricingKey,
PayerPricingName,
RuleName,
Effective,
Termination
from
(select distinct
PayerPricingKey,
PayerPricingName,
PR.RuleName ,
PR.Effective,
PR.Termination
from
PayerPricing PR ,
TermInRule TIR ,
TermRule TR ,
ContractTerms CT ,
LookCCntrct LCC ,
PayerProfile PP
where PR.Effective = (select Max(Effective) from PayerPricing PR1 where
PR.PayerPricingName = PR1.PayerPricingName ) and
TR.TermKey = CT.TermKey and
LCC.ContractID = CT.ContractID and
TIR.TermRuleKey = TR.TermRuleKey and
PR.PayerPricingName = TIR.InputValue and
PR.PayerPricingName like (@payerpricingname) and
PR.RuleName like (@rulename) and
LCC.ContractID in (select distinct ContractID from PayerContracts
join PayerProfile on
PayerContracts.PUID = PayerProfile.PUID and PayerID like (@payerid)) and
LCC.ContractID like (@contractid)
) RatesTbl
ORDER BY CASE
WHEN @orderby =1 THEN PayerPricingName
WHEN @orderby= 2 THEN RuleName
WHEN @orderby = 3 THEN convert(varchar,Effective,120)
WHEN @orderby = 4 THEN convert(varchar,Termination,120)
ELSE PayerPricingName
END
DESC
end

else
begin
select PayerPricingKey,
PayerPricingName,
RuleName,
Effective,
Termination
from
(select distinct
PayerPricingKey,
PayerPricingName,
PR.RuleName ,
PR.Effective,
PR.Termination
from PayerPricing PR ,
TermInRule TIR ,
TermRule TR ,
ContractTerms CT ,
LookCCntrct LCC ,
PayerProfile PP
where PR.Effective = (select Max(Effective) from PayerPricing PR1 where
PR.PayerPricingName = PR1.PayerPricingName ) and
TR.TermKey = CT.TermKey and
LCC.ContractID = CT.ContractID and
TIR.TermRuleKey = TR.TermRuleKey and
PR.PayerPricingName = TIR.InputValue and
PR.PayerPricingName like (@payerpricingname) and
PR.RuleName like (@rulename) and
LCC.ContractID in (select distinct ContractID
from PayerContracts join PayerProfile on
PayerContracts.PUID = PayerProfile.PUID and PayerID like (@payerid)) and
LCC.ContractID like (@contractid)
) RatesTbl
ORDER BY
CASE
WHEN @orderby =1 THEN PayerPricingName
WHEN @orderby= 2 THEN RuleName
WHEN @orderby = 3 THEN convert(varchar,Effective,120)
WHEN @orderby = 4 THEN convert(varchar,Termination,120)
ELSE PayerPricingName
END
end
end

Please help me to resolve this problem

UDP broadcast in mysql (1 reply)

Srivats Chandrasekaran — Mon, 22 Jun 2009 09:08:30 +0000

Hi,

There is a function in Sybase called syb_sendmsg(ip_add, port ,) which broadcast the message to the ip_add and port specified. Is there an equivalen mysql function. There is an MYSQL Message API. Is there anybody who has used it.

Thks
Srivats.C

Migration problems (1 reply)

David Eder — Sun, 20 May 2007 04:06:08 +0000

Hi!

The company i work for plans to migrate all databases we use from Sybase ASA Version 8.0.3.5217 to mySQL V5.x! The Application (executed in Windows NT) which accesses the mySQL-Db was created with Powerbuilder 7 Build 10180. We're using myODBC 3.51.12 to connect the mySQL-Server (V5.0.22). I configured the ODBC driver like the manual suggests it. The mySQL server is not specially configured yet (except the sql_mode which is ANSI).

The database itself is already migrated to mySQL without any problem (well, less problems than i thought!), but the PB-Application does some strange things in connection to it! First of all, for some DataWindows i had to change the retrieval argument(s) from number to string in order to get them work - I would like to know why this is necassary - it doesn't sound logically to me and I really dont like that solution (because some DataWindows work fine with number-arguments! But I could'nt figure out any differences in DW-definition). Another problem is, that DW's Update() method does not return a valid value (always -1) - seems like the odbc-driver does not realize that rows were changed - They're all perfectly written to the db!

I heard that there are some Powerbuilder configuration files which handle various things like how values are passed to the ODBC driver, but I could not figure out where they are located and how to write them.

How can I avoid changing too much code in my application? It has to work with both databases (ASA & mySQL).

Thanks in advance!

***EDIT***
HI!

I found out why DataWindows with numeric retrieval-parameters did not work for Datawindows in connection to mysql:

There's a file called pbodb70.ini which handles various odbc-driver settings! So if you connect a mysql-db, just create a section called [MySQL] and put PBSupportBindSelect='NO' in it and it works fine! There's also a setting for update/insertable dw's (called PBSupportBindUpdate!)

hope this helps!

MySQL Migration Toolkit - supports Sybase migrations (3 replies)

Edwin DeSouza — Fri, 01 May 2009 03:40:53 +0000

Migration from Sybase ASE 12.5 or later is now supported.

http://forums.mysql.com/read.php?104,100566,100566#msg-100566

Porting code that does a raiseerror (1 reply)

Eileen Boyer — Mon, 18 Sep 2006 05:11:11 +0000

How do you generate an error from MySQL as you do in SYbase using raiseerror?

e.g. raiseerror 99999 "bad values"
return

I have searched all over the web but cannot find anything that will show me the syntax to use to do this.

Eileen Boyer