DSXchange

remsh, rlogin, rsh, ftp w/before/after script are some options.

For DS 6.0+ the DS_AUDIT hashed file tracks changes done via the Designer or Manager. That will tell you a lot about who touched a job last. Search the forum for this undocumented internal repostory file....

You can unlock a Routine or Function by using the LIST.READU command and the UNLOCK command. Search the forum, but you'll find that you need the USERNO column associated to your Routine/Function object listed on the right. Then, using UNLOCK USER xxxxx ALL you'll be able to release object. You have ...

Premium Membership means you get full access to all features on this site, which includes posts marked as Premium. The only folks who can make a "Premium" content post is a Premium Poster. So, 6 out of 12xxx posters have this ability to mark their posts "Premium".

Premium Posters are your sponsors of this forum, either as employees, partners, collaborators, or such for the illustrious Editor Mr. James. We have this exalted position because of our business or personal relationships and our commitment to this forum and product. Rising to the level of Premium Po...

I would like a clean defintion of the difference between Kimball and Inmon as it applies to ETL or delivering a solution. What do you think we DSX developers would benefit from knowing more or understanding better these books and there is a lot of books and articles. What table designs or ETL desig...

The umask setting in the S99ds.rc file sets the default file permissions.

By the way Ken, can you explain "Bus" versus "CIF" without using buzzwords? I double dare you. No way. Both my responses said the same thing: read their books and figure out the differences and whether the authors have contributed anything to you. Solutions are "right-sized" according to the skills...

Use a job to run the routine.

Well, no, you've pretty much got it completely wrong. Kimball argues against stove pipe data marts and not "backing into" an architecture. Kimball and Inmon both believe in a well architected data integration environment for analytical processing. Kimball espouses his "Bus" architecture, and Inmon h...

Rollback does work, provided your loading methods allow for it. You need to understand what the database is doing when you're loading data. OCI/ODBC connections use DML and have a commit count. An errant insert does not cause a rollback in certain databases, the row simply rejects and others continu...

What's the basic difference between an orange and an apple? What do you want, color, taste, nutritional value, texture, method of consumption? Kimball and Inmon both write books, give lectures, and teach about data integration. Their methods are complimentary in certain areas, conflicting in others....

Please do us a favor and post in the correct forums! If you post in a Server forum, you get a Server response. In the Parallel forum, a Parallel Response. In the TX forum, a TX response. I'm not going to spend time asking you questions such as version, release number, etc, as posting in the correct ...

That's a tough requirement. Short answer: No. You could consider people looking at jobs a restricted activity to development servers only.