Page 1 of 1
Access Documentation Tool question
Posted: Tue Feb 18, 2003 11:44 am
by datastage
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?
Posted: Tue Feb 18, 2003 1:49 pm
by ray.wurlod
That has been my experience. I ended up creating a ClearAll macro.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Posted: Tue Feb 18, 2003 3:04 pm
by datastage
Thanks Ray.
If you happen to the macro code available could you copy/paste it to the forum?
Posted: Tue Feb 18, 2003 8:40 pm
by ray.wurlod
Would you believe 27 DELETE FROM tablename statements, with transactions disabled?
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Posted: Wed Feb 19, 2003 9:53 am
by WoMaWil
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.
Posted: Tue Apr 01, 2003 11:28 am
by datastage
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;
Posted: Tue Apr 01, 2003 4:38 pm
by ray.wurlod
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.