#DateForumTypeThreadPost
2207 Jun 2016 @ 04:42 PDTDatabaseReplyTable counts in a databaseThanks for you response. This was very helpful
2101 Jun 2016 @ 01:52 PDTDatabaseTopicTable counts in a database Please guide/help me writing a macro or procedure. Below is my scenario I have few tables in a database which starts with ‘dev%’ and same table with ‘test%’. Am using...
2022 Jul 2015 @ 06:56 PDTDatabaseTopicBack to back dates resultPlease help me with below sceanerio Product_no    start_date             end_date ABC              2015-07-29   ...
1910 Mar 2015 @ 06:48 PDTDatabaseReplySQL helpChirag Sure, Thank you.
1803 Mar 2015 @ 09:49 PSTDatabaseReplySQL helpthere is no common id between sales table and store-id table, inorder to bring each sale id from different stores i hav to put cross join. I cannot use inner join as only matching records will come...
1703 Mar 2015 @ 09:48 PSTDatabaseReplySQL helpthere is no common id between sales table and store-id table, inorder to bring each sale id from different stores i hav to put cross join. I cannot use inner join as only matching records will come...
1603 Mar 2015 @ 06:22 PSTDatabaseTopicSQL helpI have table sales and store_id details sales_id sales_percentage sales_area 1 10 BG 2 20 ch 3 30 as store id store name 2 ed 3 tr 6 ns i need output like below sales_id sales_percentage ...
1525 Feb 2015 @ 01:31 PSTDatabaseReplyRemove the first 4 characters in a stringHi Ravi, i provided some details here, let me know if you need any details Table A Product_nm Product_id Ar_CD offercode A 10 2 10 A 10 3 10 B 11 17 11 B 11 18 11 B 11 19 11 Table B ...
1425 Feb 2015 @ 01:11 PSTDatabaseReplyMultiple values in where clause Hi Dieter, We have below scenario. Please help us with this Table A Product_nm Product_id Ar_CD offercode A 10 2 10 A 10 3 10 B 11 17 11 B 11 18 11 B 11 19 ...
1319 Feb 2015 @ 02:22 PSTDatabaseReplyRemove the first 4 characters in a stringI had a scenario in which entire data from column A from table A should match with Column A from table B (Select Offerid , product_id, apc_code from table_A) live_offer Innerjoin  (Selec...
1219 Feb 2015 @ 02:17 PSTDatabaseReplySQL helpI had a scenario in which entire data from column A from table A should match with Column A from table B (Select Offerid , product_id, apc_code from table_A) live_offer Innerjoin  (Select O...
1114 Jan 2015 @ 05:23 PSTDatabaseReplyRemove the first 4 characters in a stringThank you Dieter and Raja .
1010 Dec 2014 @ 09:35 PSTDatabaseReplyRemove the first 4 characters in a stringI have table with follwing data EMP_ID EMP_ADDR 11010 Divya is from bangalore 12034 Suresh from chennai 150567 from mumbai 12345 Sadic is working from delhi I have to extract the EMP_ADDR lik...
912 Nov 2014 @ 11:45 PSTDatabaseReplyHow to avoid using QUALIFY OVER PARTITION BY I have a person table with following data   Person_id  Address 10 Bangalore karnataka india 20 India karnataka Bangalore 30 Maharastra Mumbai 40 Asia bangalore ...
805 Aug 2014 @ 10:19 PDTDatabaseReplyCreating subset of data containing Chinese charactersA Column is having chinese characters.  I need to select rows from a table which is having chinese characters, Can some one pls help me how i can select these type of data.
722 Apr 2014 @ 10:40 PDTToolsReplyMultiload errorAm trying to laod a table with MLOAD connection through inforamtica.Am getting below error "Error: External loader process [5440016] exited with error [12]" Loder log is not getting cre...
613 Mar 2014 @ 05:30 PDTToolsReplyFASTLOAD SCRIPT ISSUEThanks for your response Krishaneesh/sgarlapa. Around 70 lakh records got exported to file..  but in log file i can see the above error. Is this because of space constraints in UNIX ? or scri...
512 Mar 2014 @ 04:15 PDTToolsReplyFASTLOAD SCRIPT ISSUEFast export script issue : I have to export a file having more than a crore records. whem am running the fast export script i am getting below error. Kindly advice. UTY4014 : Access module error ...
404 Mar 2014 @ 04:31 PSTDatabaseTopicHow a merge statement workPlease help me understand how merge statement works instead of UPDATE/INSERT.
304 Mar 2014 @ 03:34 PSTToolsReplyTeradata Parallel Transporter - Session Character SetDoes Teradata 13 support TPT ??
219 Feb 2014 @ 11:33 PSTDatabaseReplySQL helpThank you. I will check it.
119 Feb 2014 @ 05:36 PSTDatabaseReplySQL help  Hi, I had a scneario like log file will show 100 records got processed and when i query the table i can see only 99 records. I have loaded the table using BTEQ.Can anyone help me answer my...