DSXchange

I am not using any stored procedures from datastage. The sp_tables is a system stored procedure on Sybase. I do not know why this is being called or when/where the "Create Table" command is being issued, as transaction logging is off on Sybase.

But the problem is, no where in my job do I create a table. It is a simple select sybase stage which just selects data from one table and output to sequential file. Why would a "Create Table.." be issued in tempdb? Transaction logging is off, auditing is off. Does datastage use temporary t...

Help appreciated!!! I am in the process of upgrading to datastage 6 (and sybase 12.5) on Solaris 8. And am getting the following warning with all jobs using sybase stage, even with a simple 'select' sybase stage: ======================================================== test..SYBASEOC_0: Sybase Serve...

Hi Ray, Thanks for your comments. It led me to investigate all the path names, links etc... In conclusion, the sybaseoc.so calls libtli.so, which has been renamed to libtli.so.12.5.0 in sybase version 12.5!!!! I have emailed support for their recommendation (upgrade?). Have you encountered this befo...

Help appreciated! I have upgraded to Datastage Version 6! Unix(2.5) and Sybase (12.5)!! I am getting the following error when validating a job with Sybase stage... ------------------------------------------------------------------ ds_loadlibrary: error in dlopen of sybaseoc.so - ld.so.1: phantom: fa...

Help appreciated! I have upgraded to Datastage Version 6! Unix(2.5) and Sybase (12.5)!! I am getting the following error when validating a job with Sybase stage... ------------------------------------------------------------------ ds_loadlibrary: error in dlopen of sybaseoc.so - ld.so.1: phantom: fa...

Thanks Ray.

Help appreciated... We are having problems connecting to a Sybase 12.5 database. OS = Solaris 8 box Datastage version = 6.0. Sybase and Datastage reside on same box. ------------------------------------------------------------ Error is: --------- MSG = [DataDirect][ODBC 20101 driver][SQL Server]EMP ...

CLEAR.FILE filename worked!!!!

Thanks Ray!

Cheers,
Zinna

Hi Ray, I ran the uvfix VOC and got the following result... ------------------------ Beginning TRACE of VOC. TRACE of VOC completed. Scanning overflow buffers. Scan complete. 23 group(s) processed. 192 group buffer(s) processed. 4711 record(s) processed. Number of data bytes = 364268. --------------...

I create it by Validation in DS Director. The EXACT error message is "Read Operation Failure. Message[00000]Internal File Corruption detected". And YES, after deleting I do check the VOC... using SELECT * FROM VOC WHERE NAME='filename'; I suspect there is another system file where the dele...

Yes, when I use the DELETE.FILE command, it reports it has successfully deleted all three parts. And indeed when I checked the VOC and NT Explorer it no longer exists. Indicating that it has deleted all traces. When I then recreate it (using validation) it works, but when I then try to view/select f...

Please Help! I cannot seem to completed delete and recreate a particular hash file. I have used DELETE.FILE filename, all seems successful, D_filename directory completed gone, all traces in the NT file system seem to have been deleted. VOC entry is all. All seems sweet. I validate the file, all loo...

Perfect! Exactly what I wanted it do it. Thanks John.

Zinna

Hi, I want to write to a hash file in a before/after routine. I am using the WRITE statement, it is fine when the hash file only has one field as key, but my hash file has two fields as key and I can't write to the second key field. This is a snippet of my code, which works as it only has one field ...