DSXchange

Go Dallas.

I would use Samba. It makes UNIX appear as Windows server to Windows PCs. This allows you to write UNIX directory and read it from DOS. Let us say your Samba share name was myshare and your UNIX machine name was server12. On DOS this would be available as \\server12\myshare. Samba is easy to setup a...

All of us have been corrected on this forum if you answer enough questions. Kumar has given a lot of great answers. I want that to continue and not slow down becuase something was learned on this post. I always want to encourage people to post whether or not the question seems important. The importa...

You need the transition lab offered by this web site and usually taught by Ray.

Here is another link. m This list the depend jobs field in the properties tab of a job. This is not always accurate. A more accurate way is to look for the job activity stages. select DS_JOBS.NAME JobName FMT '40L', DS_JOBOBJECTS.NAME LinkName FMT '30L', EVAL DS_JOBOBJECTS."@RECORD<12>" AS...

No big deal Kumar. Keep up the good work. It was just a minor point. This is a powerful and complex routine which is very useful when used correctly.

We preach that hashed files should be rebuilt every ETL run. This is a hashed file. I practice what I preach. With the new EtlStats I included a job named ETL_Reseed_SDKSequences. This should rebuild this hashed file. Modify it to your needs. It basically assumes that the key to SDKSequences is the ...

By the way 5GB is a joke. By a disk drive. They are cheap.

Hester recently posted why not to use CRC32 for "Surrogate key generation". He wrote this routine with another Ascential developer. He has lots of posts about how to use this routine. It works best in SCD type 2 calculations. If you calculate CRC32 on all fields in a dimension record and calculate C...

I would not use $UserStatus if you need more than one value from a job. If you are on Ds7.5 then you can use routine arguments as parameter values or in loops. I would store dates into a hash file. It is easy to read a hashed file and return values in a routine. There is a utility routine to read an...

Agreed.

Texian?

Rich, you are giving me a headache.

Maybe your scheduled job is running as a different user. There does not have permission to write to this share.

I would reinstall the client.