DSXchange

That would be the Warlord from "al DSXchange" no doubt?

Some time back Ultramundane posted of installation issues with PS1 values that contained a newline. Possibly this problem is related.

Ross, find out what the largest field size in your log file is.

It may even be bigger than 16KB!

Sam, a power of 2 works best for MAXFETCHBUFF.

I have already given you this solution.

Use dsjob to read the first event from the job run from the job log. This contains all of the parameter values with which the job was started.

Did anyone take the time to analyze what I posted? It handles the existence of any non-alphanumeric character in the value.

Welcome aboard. :D The Complex Flat File in server jobs simply does not handle OCCURS DEPENDING ON (though it does handle OCCURS n TIMES). Because it's my background, I'd create a before-job subroutine to convert this file to ASCII and line terminated. The following code is written without access to...

Option -paraminfo gives the default value, not the actual runtime value. You need to get this from the job log, as I outlined earlier.

Your business rule needs clarification. Define "bad". For example, if you wish to eliminate any character that is neither alphabetic nor numeric, state this as the rule. The "MCP" conversion is only useful if you have non-printing characters; it does not solve the original question. See if you can u...

There's no Matches operator in parallel jobs. But Index() can report if there's a "/" in the data. So your constraint expression might be Index(InLink.TheColumn, "/", 1) = 0 This asserts that there is no first occurrence of "/" in TheColumn. Combine as many of these with AND as you...

It appears to be a correct assumption. Is Sybase an available option in the Dynamic RDBMS stage (DRS)? If so, this will use Sybase OC under the covers.

The "?" in the string is the character that could not be mapped. You need to make sure that you are using a map that can handle all of the characters in your data.

Don't supply the user name. Or, if you need to, use the appropriate options for hostname, user name and password.

Type dsjob by itself to obtain a syntax summary.

The Administrator client will tell you if a project is protected. Yours is not, because you have been able to effect edits. The message "Record J\644\V0A5 in file DS_JOBOBJECTS does not exist" refers to an annotation. But that may not be the only other thing missing from the job. Do you have an earl...

Linux is no different from any other O/S in this regard. One group per project. One extra group for the DataStage software: this should be the primary group of the dsadm user. Developers belong only to the groups for the projects with which they can work. Users' umask is 002. DataStage roles are ass...

I did.