DSXchange

Test it two ways from ActiveBatch, then. First like Craig said, just try adding the dsjob path to PATH in the regular ~/.profile file. Second, try giving a fully qualified path to the dsjob command. Are you using a script? The script may need to source the dsenv file first. If it's already doing tha...

jkibler wrote:dsjob: command not found

Regardless of which scheduling tool you use, the error indicates that the dsjob command is not in your PATH environment variable. Adding the command's path to your PATH should not be necessary as long as your fully qualify the command with its path when you call it.

This is a bit of a trivia question, and I only know the answer to #2:

1. What does the T stand for in the tsort operator, and how do you know?

2. What does the P stand for in the psort operator?

Is there any new utility in Version 8.5 that can do this easily? The two most common utilities you can use to export/import are by using the istool command line (isx file format) on client or server, or traditional Designer export/import (dsx file format) on the client tier. For that you can use th...

ArndW wrote:... do a full project export, create a new project and then do a full project import into the new one.

That's also the same process to follow if you want to rename a project.

First go into your job properties and add the environment variable APT_DISABLE_COMBINATION then run your job with that set to True. It should change this message you got to something more meaningful: APT_CombinedOperatorController,0: Fatal Error: Not bounded length. VarChar(1024) should not cause an...

Yep! I ran into ever-so-slight compile issues with those combinations since some pre-compile steps happen on the client and the rest happen on the server... Same goes for the IIS Console used for IA and ISD. I found recently that between 8.5 and 8.7, you can login with either version of the IIS Cons...

The maximum length of a varchar field can be of 255. Not true. Did you know that max length is also not 999999999 (nine nines)? :idea: Max length it will accept is 2^31 - 1 (2 to the power of 31, minus 1), or you can leave it blank. Try it for yourself. I have seen some IBM tech notes that suggest ...

Note: Please take note of this IBM tech note: :D

Parallel Engine data sets and sort operations with VARCHAR/NVARCHAR columns may require the maximum length specified to store data on disk.

http://www-01.ibm.com/support/docview.w ... wg21458132

APT_OSL_PARAM_ESC_SQUOTE

http://www-01.ibm.com/support/docview.w ... wg21386517

Data set descriptor files (or control files) contain a copy of the config file that was used at the time of data set creation.

From UNIX script or after-job command or sequence job Execute Command stage, you can rename (move) the file using UNIX date command syntax. For example, to rename file.txt to a new file name formatted as file_YYYYMMDD.txt use the date command within tick marks (the date command is executed, and its ...

chulett wrote:Short answer: you can't.

And if you can, you shouldn't. Back on various 7.5.1 / 7.5.1A / 7.5.2 combinations, it worked. That doesn't mean you should compile all the jobs across differing client & server versions.

Exactly.

I agree with Craig's approach. The last thing I would want is for the external job tracking table to have some problem, like that database goes down or the ID expires, then it brings your production ETL to a halt.

FYI: DataStage 8.7 has a web-based operations console (read-only).