DSXchange

You do not need one for Universe. Use a UV stage. The DSN is localuv for hash files. I do not know about UniData. Maybe Dr. Ray does.

I did it in the DEADLOCK.MENU. Worked like a charm. If this file was 2GB would it cause problems.

I would select into a hash file the last value then do a lookup and only select matches. Process more data but it will work.

Thanks.

If you're brave enough, you can write a basic routine to automatically update your DSX export file, so every DB2 plugin is changed to an Oracle one. I did this recently upgrading an oracle 8 to 9 system. Best take a backup first... This is not a good idea. These 2 databases have different propertie...

Professor Ray or anyone,

Can I zero out this log file?

-rw-rw-rw- 1 dsadm dstage 2147483653 Mar 5 12:46 ./DSEngine/dsdlockd.log

Thanks

Use a hash file. Should not be a problem to have CR/LF. It will slow it down but it will not change the column.

You could do a SELECT against DS_JOBOBJECTS and count(*). You need to GROUP BY OLETYPE. This should give you what you want. To run SQL against the repository use DataStage Administrator and select your project then press the Command button.

Do a search for EtlStats. Whole series of jobs to do exactly what you asked.

You can SELECT COUNT(*) FROM MyHashFile; in a UV stage. You can COUNT MyHashFIle in a ExecTCL command.

I should be posting a new EtlStats soon. I am installing it at a new customer site. Found some missing routines. Found somethings I do not like. If you downloaded it then you are missing routines IsJobSequence and DateConv. Also routine EmailToRtn needs rewriting. If you tried to install it and coul...

Who cares, we are having fun.

Well he was just wrong. PROTECT THE OR's. Some have sense and then some have common sense and then some ain't got none at all. If you protect the OR's with () then who cares what langauge you use or what precedence is involved. I try to keep it simple by not having to worry about these things. Ray h...

What?

if (Fundname2 <> Fundname1) or (Fundname1='' ) and DateGenericDateDiff(Date2, Date1) < 365 then 0 else 1 Is almost always true because the () are in the wrong place. The () should always protect the or like: if (a<>b or b=1) and c<b then 0 else 1 or if a<>b or (b...