DSXchange

I create a little batch file like this: :: ----------------------------------------------------------------- :: Host is server name :: User is username to use to attach to DataStage :: Password is password to use to attach to DataStage :: BackupDir is the directory to place the backed up project in ...

What?

In BASIC you should use Pick style SELECTs and not SQL SELECTs. The SELECTs have a little different syntax. SELECT filename WITH column_name = "value" AND WITH ... Use WITH instead of WHERE. WITHs are repeated for each field. The fields or column_names have to be in the DICT or you need to...

I modified it a little bit and posted it on my tips page.

Same answer as this post http://www.dsxchange.com/viewtopic.php? ... highlight=

I sure hope they integrate stats with DataStage where it belongs and not in MetaStage. You need to make ETL decisions based on these numbers. That is why it is in a job and stored in tables so you can make ETL decisions with it. All this and it is free.

Craig comes through again. Very funny.

Way to go blogman.

I think that each database needs 3 parameters for the DSN, User and Password. We name them p plus Source or Target plus the DSN name plus Dsn, User or Pwd. So AS400 DSN has: pSourceAS400Dsn pSourceAS400User pSourceAS400Pwd Ray suggests jp in front for job parameter. I think that maybe better. To par...

This is DsSeqFilesAll.sql and is part of EtlStats. select EVAL DS_JOBOBJECTS."@RECORD<6>" AS FILE_NAME FMT '45L', DS_JOBS.NAME AS JOB_NAME FMT '35L', DS_JOBOBJECTS.NAME AS LINK_NAME FMT '35L' from DS_JOBOBJECTS, DS_JOBS where DS_JOBOBJECTS.OLETYPE in ('CSeqOutput','CSeqInput') and ...

it now employs a webmaster

It has always employed a webmaster. Dennis has eaten this cost for years now. Now it is time to at least break even.

I absolutely agree with Ray.

Why not run some of the SQL posted against the repository tables to see if they did it right?

Yes. Some binaries are owned by root. So do not chown on these. You will have problems.

No it does not. It is a backup of jobs only.