![]() |
Telelogic SYNERGY (steve huntington) | ![]() |
Topic Title: Query for all objects that have parralel branches ... Topic Summary: is_hist_leaf() ... Created On: 3-Nov-2004 16:30 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Hi,
i want to build a query that can show me all the object in my database that have parralel branches ... Il know the keyword is_hist_leaf() which shows objetcs without successors but in a very big database, result is twoooo big ... So if you have ideas ??? I think it is possible playing with "instance" parameter ... But perhaps there is an other solution ... Regards. PS : sorry for my english ;o) |
|
![]() |
|
![]() |
|
Hi, ccm query -u "recursive_is_member_of('$PROJECT_NAME,$PROJECT_VERSION','') and not type='project' and not type='dir'" -f "%name" > $TMP_WORKING_DIR/$TMP_FILE split -l 500 $TMP_WORKING_DIR/$TMP_FILE $SPLIT_FILES_PREFIX TARGET_FILES=`ls $TMP_WORK_DIR/$SPLIT_FILES_PREFIX*` for TARGET_FILES in $TARGET_FILES
done ### Run through a loop to determine when all of the background processing is done, collect the data DONE="NO" |
|
![]() |
|
![]() |
|
Informix SQL is much faster on Big DB : |
|
![]() |
|
![]() |
|
ok thx
i'm going to test on my window server.
Regards
Damien
|
|
![]() |
|
![]() |
|
Hello Ludovic,
how can you commit the mentioned query? Are you using a informix client? Has ccm an option to commit direct queries?
Philipp Weißmann |
|
![]() |
|
![]() |
|
Philipp, dbaccess $database << ThisIsTheEnd 2>/dev/null select name,cvtype,subsystem from compver ThisIsTheEnd |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.