DSXchange

In ksh use && and || for AND and OR when doing something like this:

There's nothing like a good benchmark in your specific environment.

I'll confirm the whitespace debate if someone else doesn't beat me to it, but I recall explicitly handling this in some cases. It's all getting blurry these days, lack of sleep will do that to you...

TRIM without the optional trimming character defaults to just spaces. You've got something else modifying that column. Try writing to a Sequential file pipe delimited write after trimming to assure yourself you're not going crazy. Then, follow it the rest of the way to the database.

My brain was too tired today, I didn't articulate my thoughts clearly. You need a Function (not routine) that will fire off a UNIX or Windoze statement, kind of like a 1 line wrapper to DSExecute. Then, when you goto the Initialize cell on setting up a stage variable, use your right-click menu and c...

The DSGetLogSummary API doesn't distinguish log entries for the instance, it gives you everything. I'm guessing that dsjob uses the same API so has the same problems.

One thought, could it be a TAB character? It can give the appearance of spaces.

TRIM(link.column) takes care of trailing and leading and repeating spaces if you want a simpler way. If there are spaces at the end of your text it depends on how you're seeing it. If you're writing to a fixed with file it will pad the fields. If your metadata for that column is CHAR it will pad the...

If it's a 1 row hashed file, how many columns? If you used some derived value as the key, how do you expect your process to know the key value? If it knew the key value, it wouldn't need to do the lookup. If your process created the hashed file, it should write the max value out and use a column wit...

Welcome aboard. This is the craziest thing I've seen posted. Could you please state your situation another way? I cannot comprehend the steps the logic needs to follow. I do understand that you have a non-structured file with record start and end markers. What I don't understand is your terminology ...

Sounds like the FTP ports are locked, you're going to have to talk to your network/NT administrator

You don't have that luxury. The job log for all instances are one and the same. You're going to have to verify the job instance name against the text within the log message to make sure the message pertains to your instance.

Or make copies of jobs rather than use instances. I know that sucks.

Depends on your security requirements, some places use SFTP instead. Just try it, get the IP and give it a try.