DSXchange

I posted a batch file that will do a job report for every job on ADN. I prefer JobReport written by Tony Curcio. I think it creates a nicer document. So created a wrapper for his routine which will do all jobs and all routines. I wrote the routine part to look the same as his html. It creates and in...

Means use MetaStage. No, really the Reporting Assistant gives errors like this because the columns get truncated and create duplicates or is unable to load a record. Most of the time it gives an error and keeps going. I have not seen thjis error before. You could ignore it or not export the whole pr...

Some of my comments I regret. I think several thoughts were poorly worded. I do think my heart was in the right place. I agree knowledge, skill and wisdom are universal and should be respected from anyone. I actually like these types of discussions that go beyond the skillset and talk about the mind...

I told you.

We have posted SQL to pull data out of these files so if you need something specific then ask. Ray will tell you that it will not work in the next release but until then it will work fine.

I found the spelling error. most of these statuses I figured out by hacking. Some are in DSINCLUDE JOBCONTROL.H. I do not know what status 7 is. It is hard not to overwrite something in ftp. You would almost need to do 2 calls. One to do a ls and another to put it if it is not there. This script mak...

You would have do it in SQL.

SELECT NAME FROM DS_JOBS WHERE CATEGORY = 'MyCat';

We will hack hawk too. Say it with me. Hacking is fun.

Here is a shell script to run a job. It checks to see if you need to reset and then does a reset before running. #!/bin/ksh ################################################################################ # File Name : RunJob.ksh # Description : runs DataStage job # : then ftp's file for them to dow...

Not unless it is a Windows server.

CCustomStage, CCustomInput or CCustomOutput is probably what you want. select 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 = 'CCustomInput' and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO group by JOB_NAME, LINK_NAME ...

Tell them Ray man.

Numeric sorts are tough. If I do this then I always put the sort fields first and pad the sort fields like they are fixed length.

select EVAL DS_JOBOBJECTS."@RECORD<6>" AS FILE_NAME FMT '35L', 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 ('CHashedOutput','CHashedInput') and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO group ...

This is just a log file. he 2GB limit is on hash files. Most UNIX machines can go beyond this limit on sequential files like this type of log file. The job log files by the way are hash files and do need to be converted to 64bit to go beyond 2GB. If you have a job log file or really any log file the...