DSXchange

I haven't been able to figure out a way to get the mark into the query before it is sent to the server. I thought of using a parameter in some way but haven't had much luck there. In any of the relational stages, parameter values are available via #parametername# notation. So, a query would have a ...

Since leading zeroes need to be retained, you should be reading this column as char and conditionally derive the date value by either adding 1900 or 2000 to the YYMMDD portion and then casting into the appropriate target column.

Somehow your metadata doesn't match the table. Either re-import the definitions and reload, or set the scale to 3 so that the message goes away.

To clarify, I assumed you used ICONV to internalize, and then OCONV to externalize, but used the externalized value in the expressions. To get integer comparisons, the ICONV returned value would have worked. It's probably easiest to always work in YYYY-MM-DD format, rather than internalize just for ...

Is it possible to share the source code for ExecDos.. Huh??? You can't run DOS commands on a Unix server. You can see the source code, go look at it under the Routines folder in the DS Manager library. It won't do you any good. You need to run something on a Windoze server from a Unix server your o...

Cool, what permissions needed fixing, the dsadm userid setup or did you have to fix project/file permissions?

Do you realize this is being discussed right now on another thread? m You might consider lightly reading the topics being discussed over the last few days, you might find problems you're currently experiencing as well as potentially seeing something that in the future, like tomorrow, may happen to y...

Did you read the rest of the questions? You haven't isolated it to a project or all projects? If it's the setup on a project, then you can fix it. If it's all projects for dsadm, that suggests a permissions problem.

Direct or Conventional? If you don't know what I'm talking about, then you need to fully understand the complicated issues that separate the two methods. Direct requires localized load files, careful understanding of constraint and index ramifications, locks the entire table, but has astonishing per...

I don't know if the job matters. Can any other users run jobs? (Identifies if it's a userid issue) Is this the first job being run in this new install? (Identifies installation issue) Does any other project work? (Identifies if it's a project or permissions issue) Can you start the job using dsjob c...

Sequencers, before/after routines, Batch jobs, and just plain old shell scripts can run Unix operating system commands. DataStage has nothing to do with it.

If a script works fine from the command line of a user and not from a job, then the only variable is the environment. The script runs under the environment of the DS Engine, so troubleshoot problems there. In your situation, it sounds like this is not the issue, but one of opportunistic timing. You'...

I recommend you google:


Any server can run commands on a remote server using the above mentioned programs. NT can run stuff on Unix and vice versa.

loveojha2 wrote:I doubt

Too bad, RK is right.

'01-Jan-2004' is text so it's a left to right comparison. You're attempting to do a DATE data type comparison, but because DS does string compares in most situations, you'll never get the right answer. If you're comparing dates put them into YYYY-MM-DD format. This will work with every comparison, s...