#DateForumTypeThreadPost
709 Feb 2006 @ 04:14 PSTDatabaseTopicUpdate using the result of a SELECTCan some one help me to know why this update statement fails. Is it possible to useupdate using the select statement like this. Your help would be highly appreciated.###############update CPU_STAT...
608 Feb 2006 @ 11:50 PSTDatabaseTopicHow to Specifying date range (Date + Hour) in the queryI am trying find out the CPU time utilization for the previous day by some intensive SQL jobs. The input is from the DBQL table. I would like to specify the time range in the previous day. How I do...
501 Feb 2006 @ 10:33 PSTDatabaseTopicINSERT EXPLAIN not workingHi,Can some explain to me why the following statement fails. I have a QCD database and I am trying to populate the QCD using the following query:########################INSERT EXPLAIN INTO QCD AS ...
425 Jan 2006 @ 08:22 PSTDatabaseTopicPopulating QCD from DBQLHi,I need your help on this one. How you populate your QCD database from DBQL database? What I am looking for is to populate the QCD databases with data from DBQL(Demographics/Statistics/Plan etc)....
318 Jan 2006 @ 11:21 PSTToolsReplyUnlocking tables after fastload failureThanks Dennis, I will follow up with the other post.Krishnan.R
218 Jan 2006 @ 11:20 PSTToolsReplyRemove a table lock if fastload failsDennis,I have one quick question. Do we need to run the empty fastload script with same user id through a different session or we can use any available userid? An example: User report a fastload fa...
117 Jan 2006 @ 04:03 PSTToolsTopicUnlocking tables after fastload failureIs there a way other than dropping and recreating the load tables after the Fastload failed.If so can some one give me the syntax? Your help would be highly appreciated. I tried to runBegin Loading...