#DateForumTypeThreadPost
2324 Mar 2008 @ 06:26 PDTDatabaseTopicHow to insert a string with quotes into a char datatype?Hi,I have a table with the following definition:CREATE SET TABLE db_name.tbl_a ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( col1 CHAR(10) CHARACTER...
2205 Mar 2008 @ 12:56 PSTDatabaseTopicMacroHi,create macro a(col1 char(10)) as(sel *from :col1;);3707:Syntax error,expected something like a name or '(' between the from keyword and ':'why is this error coming... help please
2110 Dec 2007 @ 01:08 PSTToolsTopicNeoviewAdvantages of using teradata over neoview?
2006 Dec 2007 @ 06:26 PSTToolsReply.OS commandGot the answer....We used the RC(return code) from the bteq as an input to the jcl (using if clause)and further execute the mailing part. i.eJCL JOB://s1 exec pgm=xyz --> calls the ...
1904 Dec 2007 @ 12:56 PSTToolsTopic.OS commandHi,we are doing a conversion from unix to mainframe.In which we have the following os command in bteq script:.os mailx -r "xxxxxx" -s "STEPyyyy-- Personal" abcd@xyz.com < error_message.txtNow we...
1803 Dec 2007 @ 01:11 PSTDatabaseReplyhow to round the percentage?Its because you are performing integer division and then casting it.Eg: sel 1/4 will also return you 0. and further casting it will not help.what you can try is :select cast( 1/293.0000 * 100 as ...
1728 Nov 2007 @ 10:01 PSTToolsReplyINMOD/OUTMODHi,all of them are a bit complex...i want one simple but effective one ...can somebody help me out ...
1628 Nov 2007 @ 09:57 PSTDatabaseReplycollect stats probThanks a lot Issac.You made things more clear.
1528 Nov 2007 @ 05:10 PSTToolsTopicINMOD/OUTMODCan anybody give a small example of INMOD and OUTMOD?How do we actually call/write them?
1427 Nov 2007 @ 10:00 PSTDatabaseReplycollect stats probGot it .. Thanks a lot
1327 Nov 2007 @ 05:11 PSTDatabaseReplycollect stats probhi ,But why is it reqrd to collect the stats before loading into the table?
1227 Nov 2007 @ 04:14 PSTDatabaseTopiccollect stats probHi,Is there any performance improvement if statistics is collected first and then the table is populated?i.ecreate table tbl_a(col1 int,col2 char(4) ....);collect stats on a column (col1);THENinser...
1127 Nov 2007 @ 04:00 PSTDatabaseTopiccollect stats probHi,Is there any performance improvement if statistics is collected first and then the table is populated?i.ecreate table a(col1 int,col2 char(4) ....);collect stats on a column (col1);THEN
1016 Nov 2007 @ 10:35 PSTToolsReplyInformatica 7.1.3 and Teradata V2R6But still there is a time difference...Is it because informatica calls mload and other utilities through API's and relational queues?If informatica is better .. Then its better to learn informatica...
916 Nov 2007 @ 06:18 PSTToolsReplyInformatica 7.1.3 and Teradata V2R6I have a question...Why does informatica take more time to load than teradata utilities(Fastload and multi load)?
814 Nov 2007 @ 04:09 PSTDatabaseReplyDistinct V/s Group ByGot it ...Thanks a lot .....
714 Nov 2007 @ 01:13 PSTDatabaseTopicDistinct V/s Group ByI have a table with 20 million records ... I am doing various join operation on these set of records to get some distinct values...when i use:sel distinct col1,col2..... col12 from tbl i am gett...
629 Oct 2007 @ 06:24 PDTDatabaseReplyproblem with derived tableThanks a lot guys....
519 Oct 2007 @ 08:43 PDTDatabaseTopicproblem with derived tablei had a situation where i ahd to select 3 columns from 3 different combination of table i.etables: A,B,C each table has a million records sel temp.a1,temp1.a1,temp2.a1from(sel a1 from A inner j...
410 Oct 2007 @ 06:20 PDTToolsReplyProblem with bteqi think the error was because of the data ... the table that i was updating was a 'set table' that might be the reason i guess ...I had pasted the o/p of the log file above .. hence there is a .GOT...
308 Oct 2007 @ 10:56 PDTToolsTopicProblem with bteqI was running an update bteq script and i got the following error:UPDATE SCRIPT HERE*** Total elapsed time was 18 minutes and 43 seconds. *** Update completed. 196376 rows changed. *** Total elapse...
213 Jul 2007 @ 06:29 PDTDatabaseReplywhat does this error mean?Thank you
111 Jul 2007 @ 05:32 PDTDatabaseTopicwhat does this error mean?error: Target row updated by multiple source rowson executing the following update stmt ;i am getting the above errorupdate target_tbl T --> this table is a set table from (derived table --> this t...

Pages