DSXchange

Welcome aboard! :D When you get a moment can you please fill in your profile, so we know at least where you are (for time zone primarily!)? There's a quite efficient search mechanism available in the menu at the top; learn to use it and it will answer lots of your questions. Meanwhile, to your quest...

Access DS.TOOLS menu from the same prompt (same place) where you execute DS.REINDEX ALL.

Try the different combinations domain\user and machine\user - you might strike it lucky.

Be logged in with Administrator access. Shut down DataStage services. In a DOS shell (cmd) cd to the DataStage Engine directory. Execute the command bin\uvregen Start DataStage services. In the DOS shell, verify that the change has taken hold using the command analyze.shm -t (check the line containi...

Probably the easiest-to-maintain solution is to use user-defined SQL in the target stage of your job; provide a parameter marker for each column being delivered from the DataStage job.

The second argument of Oconv() and Iconv() when dealing with dates always begins with "D". It is NOT a date picture.

Bring up on-line help on topic "D" (actually "D Code (BASIC)") for more information, or visit Date Conversion Demystified

It's even easier with the Field function! First word is Field(Trim(xyz.TeamName), " ", 1, 1) Second word is Field(Trim(xyz.TeamName), " ", 2, 1) Final word is Field(Trim(xyx.TeamName), " ", Count(Trim(xyz.TeamName)...

Make sure that they are all in the same group (it needn't be the primary group, but that helps). If the system default umask is not 002, change the ~/.profile for each so that it is 002. This will allow different people to work with components created by others. You should know that there is a table...

My apologies, I misunderstood what the 104319 represented. Now I understand that the rightmost three digits are the ordinal day number in the year, and anything to the left of that is the number of years since 1900. So you can calculate the year as 1900 + Int(JulianDate / 1000) To get this i...

You ought never have answered Y to the first question. What has happened as a result is that you have created an account that is not a project. If this question comes up it is highly likely that you are not in a project directory. The vital step that you missed is that you had to be attached to a pr...

For the sort & variable way you can run ExecSH (or ExecDOS) as a before-job subroutine that appends a dummy row to the source data.

What would you expect to see? 0xF0 and 0xF9 are non-printing characters. (I am assuming here you are using ASCII - that is, that you do not have NLS enabled.)

For a start you can't start projects. You can only start jobs within projects. And "within" is the operative word here; job control (including job sequences) can only start jobs within its own project. As Craig says, you can use something external such as the command line interface dsjob to do what ...

If you were to post this on the PX forum you might get more answers.
I'd try encasing the URL in quote characters.

Ahh, the dreaded "somebody"! Quite hard to track these down, particularly when "somebody" swears blind that "nothing has changed".

Welcome aboard! :D Do use the search facility here; most questions have been answered in the past. And special thanks for taking the time to post your solution.