Search found 133 matches

by Luk
Thu Jan 20, 2005 9:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UPDATE row using OpenClient plug-in or ODBC
Replies: 4
Views: 2160

Hi Peter!!
Thanks a lot!! I have sybase IQ :
Adaptive Server IQ/12.5.0/040702/P/ESD 11/Intel/Linux X86 2.4.9-e.25smp/32bit/20

I hope that 11.4 solve the problem. I will write to sybase
thanks again.

LUK
by Luk
Thu Jan 20, 2005 6:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UPDATE row using OpenClient plug-in or ODBC
Replies: 4
Views: 2160

UPDATE row using OpenClient plug-in or ODBC

Hi! How can I update few rows in no character format(ex. integer or numeric) in Sybase IQ 12.5 database using DataStage?? When I'm trying to do this , there is an error both in OC and ODBC. theese drivers can't convert character to decimal or integer type and DataStage always treats all formats (num...
by Luk
Mon Jan 17, 2005 7:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Bulk Loaders in DS
Replies: 6
Views: 1911

Hi !
Sybase ASIQ is also suported! Plug-in creates flat file wchich is later load into database.

LUK
by Luk
Fri Jan 07, 2005 5:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection to MySQL server on remote machine via ODBC
Replies: 5
Views: 1839

Still I don't know what the problem solution is but , when I have installed and started to use iODBC manager instead of unixODBC everything works fine!!
by Luk
Fri Jan 07, 2005 5:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage 7.5 ODBC stage error
Replies: 6
Views: 4776

Still I don't know what the problem solution is but , when I have installed and started to use iODBC manager instead of unixODBC everything works fine!!
by Luk
Fri Jan 07, 2005 4:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to configure ODBC connection to MySQL using DS and Linux
Replies: 1
Views: 1042

How to configure ODBC connection to MySQL using DS and Linux

Can you tell me what I must install and what I must configure and how to connect to MySQL server on remote machine using DataStage 7.5 under Linux RedHat??

Rdds
Luk
by Luk
Tue Jan 04, 2005 9:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage 7.5 ODBC stage error
Replies: 6
Views: 4776

one more question! Do you have path to branded_odbc manager (libodbc.so) in your LD_LIBRARY_PATH in dsenv. It is important that no other path to other odbc managers precedes this path. or try to use odbc manager wchich you get with sybase and put path to it into LD_LIBRARY_PATH before path to brande...
by Luk
Tue Jan 04, 2005 9:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage 7.5 ODBC stage error
Replies: 6
Views: 4776

Try to connect in dssh and write SQL querry with bad syntax. In my case connection in dssh works perfect until I write SQL querry with bad syntax. Then I get abnormal termination error! I have noticed that when using DS designer and for example impot table definition I've got error like yours when t...
by Luk
Tue Jan 04, 2005 7:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage 7.5 ODBC stage error
Replies: 6
Views: 4776

I have simillar problem with ODBC connection to MySQL - I have simmillar error. I have posted it here earlier. This is abnormal termination of DS, segmentation fault. Unfortunetelly I heavn't solved it yet. I think that is a problem with shared libraries to ODBC manager in Unix (libodbc.so) - but th...
by Luk
Mon Jan 03, 2005 2:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection to MySQL server on remote machine via ODBC
Replies: 5
Views: 1839

yes, but in branded_odbc there is no driver to MySQL, so I must use unixODBC and MyODBC drivers!
I removed path to branded_odbc driver - and this error is still the same.
by Luk
Wed Dec 29, 2004 8:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection to MySQL server on remote machine via ODBC
Replies: 5
Views: 1839

I think that may be prodlem with shared libraries version conflict.
I found sth like that:

http://bugs.mysql.com/bug.php?id=577

If you know, write how can I configure connection to MySQL under Linux, what drivers, what libraries and connection parameters I must use!

Maybe I'm doing sth wrong!
by Luk
Wed Dec 29, 2004 7:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection to MySQL server on remote machine via ODBC
Replies: 5
Views: 1839

Connection to MySQL server on remote machine via ODBC

Hi! I'm trying to get table definition and data from MySQL server on remote machine. I'm using DataStage 7.5 on Linux, unixODBC drivers and myODBC drivers. Connection to localhost works OK! Connection to remote MySQL is OK, but when I want to import MetaData I have an error: Error calling subroutine...
by Luk
Mon Dec 13, 2004 7:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sybase IQ 12 Load plug-in - problem !!!
Replies: 0
Views: 723

Sybase IQ 12 Load plug-in - problem !!!

Hi! We have problem with Ascential DataStage 7.5 and loading data into Sybase IQ 12.5 with Sybase IQ 12 Load plug-in!! When we running job we have got following error : ds_loadlibrary: Win32 error in LoadLibrary of iqbulk12.dll! We have DataStage on Windows and IQ on Linux. We have no idea what reas...