#DateForumTypeThreadPost
1318 Feb 2014 @ 09:31 PSTToolsReplySELECT statement in a TPT EXPORT scriptCan someone throw light on this. My question was, I have a sql query which is working fine in SQL assistant but when used in TPT EXPORT in selectstmt='', it is giving me non-existent synta...
1218 Feb 2014 @ 03:27 PSTToolsTopicSELECT statement in a TPT EXPORT scriptHi,   I am trying to export data from a sql uery to a file using TPT Export operator. My Sql query is running fine in sql assistant but when it is run through TPT it is giving non-existent ...
1116 Oct 2013 @ 11:17 PDTDatabaseReplyIdentifying IDs for duplicate namesYou can aslo try below SEL USER_ID FROM tablename WHERE (FIRST_NAME,LAST_NAME,DOB,POST_CODE) IN (SEL  FIRST_NAME,LAST_NAME,DOB,POST_CODE      FROM tablename ...
1029 Jul 2013 @ 03:22 PDTDatabaseReplyPlease explain this queryHi Barani_Sachin, If you have nulls, spaces(only),blanks in col1, these records will be filtered out using above condition.
928 Jul 2013 @ 10:29 PDTDatabaseReplySelecting groups whose member belongs to multiple groupsgive your table name after the from clause in above sql
828 Jul 2013 @ 10:27 PDTDatabaseReplySelecting groups whose member belongs to multiple groupsSagar, Put your table name instead of in below query and run it. select * from where group_id in ( select group_id from where member_id in (select me...
725 Jul 2013 @ 01:44 PDTDatabaseReplyImmediately exit a query if a condition is verified I think the value in where clause should equate to 1, instead of 0 for Mondays. 0 should be for Sundays. (CURRENT_DATE - DATE '0001-01-01') MOD 7=1  
610 Jul 2013 @ 11:13 PDTDatabaseReplyWhy can we have UPI only when PPI column is part of PIAny help is appreciated !!
513 Jun 2013 @ 11:07 PDTDatabaseReplyHUT LockYou have to go to viewpoint/manager and from there go to database console and open up showlocks utility.
413 Jun 2013 @ 03:01 PDTDatabaseReplySize of table with partial data (active records)You can get size of a complete table from DBC.Tablesize view.By using this view you can estimate the size of partial data.. lets say you have 100 records in your table which is of 10MB size(Tablesi...
313 Jun 2013 @ 02:39 PDTData ModelingReplyEffect of reversing the order of columns in mutli-column statsI am new to this forum, so misplaced the posting. Thanks ulrich for the link provided.Till 13.10 the order does not matter as it is determined from table definition as goldminer mentioned, Th...
213 Jun 2013 @ 02:30 PDTDatabaseTopicWhy can we have UPI only when PPI column is part of PIWhy can we have UPI only when PPI column is part of PI, can someone explain in detail?   Thanks in Advance
112 Jun 2013 @ 04:11 PDTData ModelingTopicEffect of reversing the order of columns in mutli-column statsDoes it make a difference if we reverse the order of the columns mentioned in multi-column stats. Eg:- collect stats on emp column (a,b)  Vs  collect stats on emp column (b,a)   C...