DSXchange

I don't know if there's such a way that programmatically convincingly shows the daemon isn't operating properly.

Need or want? I don't know of any necessity for J2EE.

You're not screwed with Sybase if you can get your hands on a Sybase ODBC driver and install it. Of course, if you're going to do that you might as well install the Sybase client. As for Oracle. how do you expect us to tell you what's wrong if you don't tell us what you're doing and don't even paste...

Start DS Manager and try to connect to the server. If it says the engine might not be running, it's probably not running or you mistyped your userid/password. ps -ef |grep dsrpcd will not do anything but tell you that the daemon is in the process table. You'll have to try to do something. In using t...

To talk to Oracle using native Oracle libraries, you have to install those libraries on all servers (Unix or Windoze, doesn't matter) that need to talk to the database server. The same is true for Informix, Redbrick, UDB, and Sybase. If you want to use ODBC, you must make sure that the appropriate O...

Is this a long running job? "SELECT * from DMDC_HOLD" seems like a user-defined query. Could that be a view and the query/job is timing out because it's taking too long?

You should probably send all errant rows into an exceptions file and then use job control to check the exceptions file. The simplest solution is to use a CONSTRAINT in the transformer stage and two output links. The first output links are the good rows, and the second output link has the REJECT box ...

You can't connect with a DS Client without dsrpcd running.

We just talked about this the other day. I don't believe there's a working ODBC driver out there. I suggested scripted extractions and loadings.

Yeah, that's it, SYBASE_OCS. I was thinking OCI but knew that wasn't right.

Welcome! You'll need to go to the DS Engine home directory: cd `cat /.dshome` and edit the dsenv file there. Add the ORACLE_HOME environment variable and point it at the true Oracle client directory. Update the SH_LIBS path to include the Oracle libraries paths as well. As for Sybase, you'll need to...

Noooo.

Substring notation will not add trailing spaces if you exceed the maximum length of the string. No way.

Put this into a test Function:




You'll see that the end of the string is the end.

Welcome aboard! I recommend you read about hashed files so that you understand them completely. This forum has many articles and discussions regarding them. Your problem is probably either the wrong file name, the wrong folder, or the wrong project. If the file exists but you can't see any data, the...

You should have jobs refresh this hashed file based on SELECT MAX(...) queries no matter what. Build them now so that you can set the values in your new project, then add these jobs to a jobstream so that your SDKSequences hashed file is never out of sync with your target tables.

Your Server job design is translated into DS BASIC and then compiled. All supporting Routines, Functions, Transforms, constraints, key expressions, and derivations are DS BASIC. You can't get away from it, you will use it. The only question is whether you want to do more. If you wish to write some f...