6 RSS

1
2
3
4
5
6
7
»
»»

xp_read_file returns null all the time

Hi,I have a table with records already existing. I would like to add an image file into the records, and the image field is Long Binary. So basically, I'm just using an UPDATE statement to add this image. However, using xp_read_file always returns NULL.The SQL I use looks something like...

0 answers | 685 bytes |

Xp_cmdshell use the java application

HiHiI have some question abou the command Xp_cmdshell.Thanks1.Can the Xp_cmdshell be used in the trigger?2. Can the Xp_cmdshell use a java application as parameter?3.I test the command , but it has no response.Xp_cmdshell start javaw AB 1234, no_output"AB" is my java application"1234" is applica...

0 answers | 386 bytes |

xp_cmdshell Resultset in ASE DB?

I've got a problem to recieve the resultset from xp_cmdshell. It is not possible to install my stored procedur in the database. The following statement causes an error while installing:......begincreate table #result (result varchar(255))select @command = "${XP_DIR}/script1.sh"insert #resul...

3 answers | 466 bytes |

xp_cmdshell invalid number of parameters

I am running ASE 12.5.0.3 ESD#3 on RH Linux 7.3 - everything is working as expected except the xp_cmdshell!When I run xp_cmdshell "date" (with or without an exec) I get ...Invalid number of parameters. Check the documentation for minimum and maximum number or parameters.I am running as "sa" with...

0 answers | 630 bytes |

xp_cmdshell

HiI have setup xp_server and added the server into the server list.I issued xp_cmdshell 'ls -la' command but it did not return any result. even i tried to execute shell script using xp_cmdshell, but it did not executed. but i did not get any error. even sp_configure 'xp_cmdshell c...

1 answers | 415 bytes |

XML storage on Sybase

Hi,We will be receiving XML docs and planning to store them in a DB persistence. Can anyone tell me which is the best DB for this out of Oracle and Sybase. If Sybase, are there any tools other than Sybase ASE 12.5 to use. I saw many on Web, but I am not sure which is best for Sybase. Thanks in...

1 answers | 336 bytes |

xml sample compilation error

I am using ASE 12.5 eval copy in WINNT 4.0 I have installed java and when i am trying to workout XML in sample given in sybase java manual i am getting the following errorE:\ase\java\xml>javac Sql2OrderClient.javaSql2OrderClient.java:11: Method sql2order() not found in class jcs.xml.order.Ord...

1 answers | 1203 bytes |

XA interface CICS

Hello,We are trying to run the XA interface for Sybase/CICS, with COBOL appications. We think we have everything running (the CICS is starting now, which we couldn't start before).When we try to do EXEC SQL SET CONNECTION CONN1 END-EXEC. we get: -033620271jcs_objects: cslib user api layer:...

0 answers | 475 bytes |

Writing insert and update triggers on ASE 15.0

I have some problems writing insert and update triggers on Sybase ASE 15 here is my code Insert trigger CREATE TRIGGER dbo.ins_MAIL_BOX ON dbo.MAIL_BOXFor INSERT AS BEGIN select created_by=user, creation_date=getdate(), updated_by=user, updat...

2 answers | 848 bytes |

Working with Sybase Dates

Hi guysI was wondering if you could help me.I am currently working with Sybase.The dates within the Sybase tables are specified as YYYYMMDD e.g. 20020326.If todays date was 20020326, I would like to know what the exact date is 9 months ago. How can I go about finding this ?I would be most gratef...

1 answers | 405 bytes |

Working with roles and permissions

Hi, i'm using the last version of ASE (15.0). I want to create a role (for example, Proj_Developers) which will be assigned to users into a database. I want to give permission to the developers to create stored procedures as database owner (dbo) but not to create tables. I could perform tha...

1 answers | 510 bytes |

Working with Image data type

Hi friends,Please anyone explain me about working with image and text like large objects in Sybase. I want to insert image and mp3 files to sybase tables. Please help me.ThanksPratheep...

0 answers | 214 bytes |

Wireless ODBC connection

I have a Sybase database running on a Windows 2000 machine that we are going to be connecting to with Symbol wireless terminals. The terminals run a PocketPC, or maybe XP embedded. Is there an ODBC driver for such functionality? I already know about Syware's software but $499 for a licen...

0 answers | 319 bytes |

Windows XP, ASE 15.0 Developer Edition: SQL Server fails to start with Error 106

I have installed ASE 15.0 Develper edition on my XP PC as per the instructions on http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc35888_1501/html/installwin/X41739.htmIt appears I do not need a licence server for the developer edition so one is not installed.I have completed the...

0 answers | 1128 bytes |

Windows to HPUX

Dear Sybase experts,I am newbie to Sybase.Is there any way to convert a sybase db from Windows to HPUX platform ?e.g. : Exporting files containing the schema and data from Windows, then import/run those files on HPUXThanks in advance....

1 answers | 274 bytes |

QUESTION ON "sybase"

DATABASE TECH

Home - About Us - Contact - Privacy Statement - Link Exchange - Bookmark - Map.XML - Rss.Xml
0.5