DSXchange

The stops are in the Designer. By that point dsjob is done. Others have had that problem. It maybe XP. You can get the dsjob.exe off the CD.

The name is Kim not Ken. It should work unattended. SaveAsBmp.bat is the batch file. The line from this batch file is: %Designer% /H=%Host% /U=%User% /P=%Password% /SaveAsBmp=%BackupDir%%DsxDate%\%%i.bmp %Project% %%i Where %%i is the job name. This uses dsjob.exe to get a list of jobs to feed this ...

NEWACC stands for new account. It is stored in the UV account. The UV account is the system account for Universe. When you or an application like DataStage creates an account then NEWACC is used to create VOC entries based on the flavor of the account. Most of this you never need to know how it works.

Here is an email I got and some answers which may help someone else: Sanjay DateConv is a routine included. If you have an old download then you need to download it again. If this routine conflicts with one you already have then rename it in the job and rename the routine in the DSX file. It needs t...

I noticed we have one on Sql Server. Think he was an Oracle fanatic?

EtlStats install. You need to create some files at TCL. Probably DataStage Administrator is the easiest. You can also telnet into your DataStage server and get to TCL. In UNIX: export DSHOME=`cat /.dshome` cd $DSHOME export PATH=$PATH:$DSHOME/bin . ./dsenv uv # At this point you should see > the TCL...

Login in as domain\user.

All you have to is run the job to extract once after you change the table. That is not hard. Doing SQL connects in BASIC is not easy and not recommended.

Need to create table dual.

Ray is correct. I left off WEOFSEQ.

Write a job that reads your parameter names and values and writes them to a hash file with ParamName as the key. Next use this routine to start your job. I took their routine and cleaned it up so it is easier to understand. If you cannot understand this then give up. This is the way to run a job fro...

Ray

I lost some respect for you.

Here is a routine to calculate time difference. These 2 routines are part of EtlStats. * ------------------------------------------------------------ * ElapsedTimeSecsRtn(StartDateTime,EndDateTime) * Decription: ElapsedSecs between StartDateTime and EndDateTime * Written by: Kim Duke * Notes...

Ray

I am not sure that was the requirement but still a very cool idea by Arnd.

Thanks.