DSXchange

CLI is just Informix's name for their native API, analogous to OCI for Oracle.

Try before/after routine call to ExecDOS and use the zip/unzip command line program. Or, use a Command stage in a Sequence.

Unix servers can get massively huge, so if you're running Server or PX on a 64 cpu machine hooked to a fast disk farm, you'll blow away a lot of the Windoze machines out there. But, those Intel chips can be wicked fast. A linux on Intel/AMD solution can be a great compromise. I'd go that route if a ...

Or look under the surrogate keys folder of the functions I gave you. There's an ...AssignSkeyParallel function that works in blocks for parallel assignment if you call it that way (any blocksize other than 1 will fetch numbers in that block range). Shoot me an email if you have any questions.

It looks to be the problem. Total size of 9 with decimal of 5 leaves 4 for the leading values in front of the decimal.

As long as the DNS names stay the same, you should be insulated from the IP change. Of course, the DNS server must be updated to translate correctly. In addition, make sure all processes work using DNS and not the named IP.

Please re-read my above post and if that doesn't work post another response.

On unix it's just a cron tab entry, so if cron is active it should have started the job. Any chance the Sequence did something like a checkpoint restart and did nothing?

What do you mean by uncompress? I have never heard of this with respect to Oracle.

At this point, you're better off assuming your project has some level of corruption. Export all of your job, routines, and definitions. Create a new project and load your work there. Remove your old project at some point in the future. Get into the habit of using fully qualified sequential and hashe...

With dsjob always give it the server name or ip address on the command line option.

No problem on my part. FYI, invoking the command line requires you to be inside a "project" directory. You can do the same command from your project's directory and you'll be connected to that project. All your logs and local hashed files will be readily accessible. To connect to another project, ju...

Write a DS Function like ParseYourText(Arg1, Arg2) where Arg1 is the string and Arg2 is the position you need returned (in this case usage is 1 or 2). Tryout some code like: MyText = Arg1 CONVERT "!@#$%^&*()_+-=[]\;';,./<>?" TO "" IN MyText MyText=CHANGE(UPCASE...

From my second post, which would have saved you days of time...

kcbland wrote:Do it exactly as I have shown, do not be in the bin directory.

Mike wrote:Isn't that precisely what Ken provided back on the third post in this thread

and clearly stated, with full explanation to be the correct directory and why, in my second post.

Somedays life on this forum is like the scene from Silence of the Lambs, you know:

"It rubs the lotion on its body."