DSXchange

Hmm. I get the same error message when using the timestamp datatype with nanoseconds on Oracle 10g. I have to convert the columns using TO_CHAR.

What version of Oracle and what datatypes? Do you have any timestamps?

Barking... I listened to the money warped car and driver magazine articles and bought one of them non-US cars. It was a new Toyota Corolla. I had the car in about 7 times because Toyota could not stop the car from vibrating. Finally, after cursing at them many times, they said it was an engine probl...

Because I had it fixed about 1 year ago I would not be surprised if it has been added as basic functionality to 7.5.2.

I made Ascential give me a patch for this garbage. Get the patch and you can specify preserve_type as true and change the output datatype as necessary for the output. The patch allows you to get MAX and MIN of character, date, timestamp columns.

Ecase is 61040.

That portion of the error could be caused by anything from permissions, missing localization files, corruption, bad code, etc... Here is what I put at the end of my dsenv to configure Sybase. ## BEGIN SYBASE ENV export SYBASE=/msybase export SYBASE_OCS=OCS-12_5 export LIBPATH=${LIBPATH}:${SYBASE}/${...

Is this AIX? How much real memory do you have and how much paging space? Reason I ask is because IBM still recommends that you have more paging space then real memory. If not, you can run into many problems. Including, not being able to generate dumps, running out of paging space, cannot fork proces...

Looking at the product compabatility matrix included with plug-in installation guide it states that Datastage is only supported with Open Client 12.5.

Note: Open Client 12.5 is fully backwards compatable with 12.0 and 11.0. I think that you should find a package for 12.5.

SYBASE_OCS is not used for open client 11. Just SYBASE.

Thanks.

-- First get the current log number -- Run the job -- Get the current log number -- print out those records using max. You can download an example using the dsjob wrapper on www.ascential.com. Note: This example is out of date, but the code for this purpose is still there. You could also get the pat...

This functionality used to exist pre-SQL Server 7.0 and should be maintained going forward even if the vendor changes their core. BCP still exist for SQL Server 2000 albeit for backward compatability but a loader could be built around the "bulk insert" function. I definately want some sor...

Hey dude. Really really... For real... I have written many books on Sybase. You need to install the Sybase APIs in order to connect to Sybase using the native Sybase stages. If you want to use ODBC. No you don't. But that would be silly being that open client is free on Linux. I believe open client ...

If you want to use Sybase open client then you must install it on the unix box.

When Ascential came in (about 2 months ago) to talk about Hawk they said (Keith Cole) that about 50% of the error messages would be documented in an error messages guide.

Eval does two things. 1. Executes the entire argument passed to it as one command. 2. Goes through command substitution again. Both are awesome. But 2 could be annoying. But because of 2, you can now use a shell variable in your parameter file if you want. Example: STUFF=${PARM} STUFF will take on t...