DSXchange

Use 32 bit client only on the unix box. Set ORACLE_HOME in the dsenv file to point there and recycle the services.

Search the forum for OCONV. It has the necessary options for implied decimal conversion and rounding.

If you're using 7.5, there's expanded functionality you need to learn. Please look to your manuals and tutorial, because it clearly lays out with pictures and extensive notes the methods for building a Sequence that can "restart", or pick up where it left off when a job failed.

Good luck!

The command line program dsjob has a RESET option and a RUN option. You can use this on the individual job. However, your Sequence job cannot be used unless you built it for restartability.

I can't speak to this problem specifically, but what I'll point out is that the GUI has a limitation on how many characters you can enter for the length of the field. What you are seeing is this issue. When you shortened the length of the field, the job stopped complaining because you were binding t...

Let me re-affirm that Windoze is a toy. Giving up so much RAM just to run an OS on a server is a real consideration. GUI is irrelevant on a server, so the slimline OS should hands-down be the choice. Given the same hardware to run both OS's, I'd choose linux.

Permissions are managed thru the DS Administrator. They are handled as user groups having access to projects. There is no method for separating job access because internally they are stored in the same table.

Your best option is to separate users as Operators and Developers.

Install the client on whatever PCs you want. Just point and configure for the appropriate database. Database is 100% independent.

Use "FastExport" in the Search facility on this forum. You see a lot of discussion regarding what you are trying to do. The short summary is, your design works great for small volumes because it's a compact design. For larger volumes, you're going to need to break down the design. Don't take my word...

Is this a new installation of DS on this server? Is Sybase installed on the same machine? Is this a new installation of Sybase? I'm asking because we're probably beyond the realm of it's something you're doing. With an idle server, DS should behave well. If it's a new install, maybe there's a config...

Probably because your program has logic that uses the PATH, just like writing a shell script that requires execution from without a specific directory can't be run from outside that directory, even with fully qualifying the command line when executing the script.

Let's fill in more details. Is the Sequencer doing more work than just running this specific job? Is it simultaneously running other jobs? When you say that the job works outside the Sequencer, but fails when called from the Sequencer, is it 100% of the time? Your initial post gave me that impressio...

If running the job manually from Director works, but using a Sequencer to execute the job fails, then the only variable would seem to be the job parameters. If the Sequencer is running out of a scheduled execution, then maybe there's a specific userid associated with running scheduled jobs (verify i...

Depends on the source stage you are using. Some databases store date + time under DATE data type, like Oracle. Therefore, the metadata should be DATE. How about you import the metadata, which DS reads from the data source and stores in the Manager library? Then you don't have to know what the metada...

Go to job properties and turn off row buffering and see if the problem goes away. I don't know why the error is occuring.