Access Documentation Tool question

datastage · Post by **datastage** » Tue Feb 18, 2003 11:44 am

Is it just me or is Access built for such a simple mind that anyone used to a real database is throughly confused on how to do anything? I'd like to start with a clean mdb to run the auto-doc from Manager. I don't see anywhere through DataStage's interface to delete all from this database. It appears that TRUNCATE isn't a valid option in Access. Is my only option to run delete queries from all 27 tables?

ray.wurlod · Post by **ray.wurlod** » Tue Feb 18, 2003 1:49 pm

That has been my experience. I ended up creating a ClearAll macro.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

datastage · Post by **datastage** » Tue Feb 18, 2003 3:04 pm

Thanks Ray.

If you happen to the macro code available could you copy/paste it to the forum?

ray.wurlod · Post by **ray.wurlod** » Tue Feb 18, 2003 8:40 pm

Would you believe 27 DELETE FROM tablename statements, with transactions disabled?

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

WoMaWil · Post by **WoMaWil** » Wed Feb 19, 2003 9:53 am

Truncate is a statement in Oracle-dialect. Most Oracle developpers think, that the Oracle slang is the SQL-ANSI-Slang. Access is more SQL-ANSI-like than oracle.

datastage · Post by **datastage** » Tue Apr 01, 2003 11:28 am

FYI, to save typing for those who want to delete from all tables in the Access doc_tool.mdb, there are those statements:

delete from DSArgumentMap;
delete from DSColumns;
delete from DSContainerViews;
delete from DSCustomProperties;
delete from DSDataElements;
delete from DSDLLDependencies;
delete from DSJobDependencies;
delete from DSJobParameters;
delete from DSJobs;
delete from DSLinks;
delete from DSMachineProfiles;
delete from DSObjectTypeRef;
delete from DSProjects;
delete from DSProperties;
delete from DSPropNameRef;
delete from DSRoutines;
delete from DSRtnArguments;
delete from DSRtnDependencies;
delete from DSSeqFileFormats;
delete from DSSPParameters;
delete from DSStages;
delete from DSStageTypes;
delete from DSStageVars;
delete from DSTableDefinitions;
delete from DSTransformArgs;
delete from DSTransforms;

ray.wurlod · Post by **ray.wurlod** » Tue Apr 01, 2003 4:38 pm

Thanks for saving folks the typing. Remember to check table names in Doc_Tool.mdb after upgrading DataStage - you may need more DELETE statements. It's not a bad idea, when crafting your macro, to specify that you don't want transactions. If nothing else, it eliminates the annoying pop-up window.