All forum activity

#DateUserForumTypeThreadPost
161717 Aug 2006 @ 08:34 PDTmagrawalDatabaseReplyTeradata Parallel Transporter TPT APIThank you Barry for your detaled reply. I will go thro' the docs.I am trying to extract/load data from/to TD using these TPT APIs thro C++. so I am waiting for the v2r6 to get shipped soon. In the ...
161617 Aug 2006 @ 08:26 PDTBarry-1604DatabaseReplyTeradata Parallel Transporter TPT APIYou can find free documentation at www.info.ncr.com.The TPT documentation is under "Teradata Tools and Utilities". If you go to "Teradata Tools and Utilities 8.1", you will find there is a manual ...
161517 Aug 2006 @ 05:46 PDTsxjcarlDatabaseTopicstrange thing-interactional of two different database connectionI found a strange phenomenon happened in NCR-CLI.I want to use two different database connection in one process.according to the CLISAMP.c, I think that DBCAREA will keep all connection info.so I d...
161417 Aug 2006 @ 05:45 PDTsxjcarlThird Party SoftwareTopicstrange thing-interactional of two different database connectionI found a strange phenomenon happened in NCR-CLI.I want to use two different database connection in one process.according to the CLISAMP.c, I think that DBCAREA will keep all connection info.so I d...
161317 Aug 2006 @ 05:45 PDTsxjcarlJobsTopicstrange thing-interactional of two different database connectionI found a strange phenomenon happened in NCR-CLI.I want to use two different database connection in one process.according to the CLISAMP.c, I think that DBCAREA will keep all connection info.so I d...
161217 Aug 2006 @ 01:28 PDTJohn MacUDAReplyLimitation ON Bteq ExportAre you hitting the MP-RAS 2GB file limit ?
161116 Aug 2006 @ 10:32 PDTsfyeu1ToolsReplyStored ProceduresI'm studying the SQL Reference: Stored Procedure and Embedded SQL Release V2R6.1. It mainly teach us how to write the stored procedure. Also, mention the stored procedure can provide Better Perform...
161016 Aug 2006 @ 02:07 PDTsparanUDAReplye-mail Notificationsyou can use .os to generate email from bteq script. Basically it will execute operating system commands in bteq mode.here is an example sql1;sql2;.os mailx -s "subject" email_address < file_name as...
160916 Aug 2006 @ 02:03 PDTsparanUDATopichow to get octal delimiter in the export file???Hello,i need to get the octal delimiter ("\001" non - printable character) in a flat file.please suggest me how to get it in fastexport.that need to be automated.Thanks,Sparan
160816 Aug 2006 @ 01:18 PDTsparanDatabaseTopicBteq Export LImitation???Hello,i am trying to export 34M records into a flat file of record length 97 using BTEQ export.I am getting error after exporting 24M records and says "output FIle is to large"Please let me know if...
160716 Aug 2006 @ 11:22 PDTsparanUDATopicLimitation ON Bteq ExportHello,i am trying to export 34M records into a flat file of record length 97 using BTEQ export.I am getting error after exporting 24M records and says "output FIle is to large"Please let me know if...
160616 Aug 2006 @ 08:25 PDTSamantha-3071ToolsReplyProblem using Teradata import - making me crazy!!Results of show table below: CREATE SET TABLE CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3 ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( ID_MEMBER CHAR(...
160516 Aug 2006 @ 07:13 PDTNicolasDatabaseReplyAdd a number to next rowHello,you can try this SQL:select col2,col3,(sum(col3) over (order by col2 rows between unbounded preceding and 1 preceding) - (sum(col3) over (order by col2 rows between unbounded preceding and 1...
160416 Aug 2006 @ 04:56 PDTDiEgoRToolsReplyProblem using Teradata import - making me crazy!!Sorry, the forum told me my message could not be added, that's why I have it posted 4 times.
160316 Aug 2006 @ 04:54 PDTDiEgoRToolsReplyProblem using Teradata import - making me crazy!!"Hi Samantha, could you post the result of SHOW TABLE CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3; statement?"
160216 Aug 2006 @ 04:52 PDTDiEgoRToolsReplyProblem using Teradata import - making me crazy!!Hi Samantha, could you post the result of SHOW TABLE CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3; statement?
160116 Aug 2006 @ 04:52 PDTDiEgoRToolsReplyProblem using Teradata import - making me crazy!!Hi Samantha, could you post the result of SHOW TABLE CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3; statement?
160016 Aug 2006 @ 04:52 PDTDiEgoRToolsReplyProblem using Teradata import - making me crazy!!Hi Samantha, could you post the result of SHOW TABLE CSES_DEV_MICSS.MICSES_INCOME_DW_BKP3; statement?
159916 Aug 2006 @ 02:05 PDTmagrawalDatabaseTopicTeradata Parallel Transporter TPT APII am new to Teradata and would appreciate, if someone could respond to following queries.-Is there any documentation on the architechture of Teradata and how does it store the data/tables?-Where ca...
159816 Aug 2006 @ 01:00 PDTabdysDatabaseTopicAdd a number to next rowHello All,I have a table like this Col1 Col2 Col3========= ==== ========8/14/2006 0 0.5849428/14/2006 1 1.2192858/14/2006 2 1.8502458/14/2006 ...
159715 Aug 2006 @ 04:19 PDTtrying_to_learnDatabaseTopicTeradata - Stored ProceduresCan any one guide me where can I find Examples (online links, books etc) on how to write Teradata Stored Procedures (other than the Teradat Reference Manuals). I would like to learn writing databas...
159615 Aug 2006 @ 01:21 PDTSamantha-3071ToolsTopicProblem using Teradata import - making me crazy!!I don't know if there is something wrong with the Teradata import capabilities or what.I have created a table with only 2 rows:member_idssnI have exported 2 columns from another table - only 1 row!...
159515 Aug 2006 @ 12:30 PDTDiEgoRToolsReplyOleLoadCan you post here what you have put in your hosts file, with real data disguised?
159415 Aug 2006 @ 05:26 PDTt3raUserToolsTopicmload terminates with warninghello out there,i'm re-importing data from dbase A to dbase B, exporting it using fload (in fastload format) and using mload to load them back.the mload procedure (a script which uses mload) works ...
159314 Aug 2006 @ 04:54 PDTBethJobsTopicETL Developer in Southlake, TX for Travelocity!!!Travelocity, a Sabre Holdings, Inc. company, is seeking a ETL Developer who has at least 5+ years experience working in data warehousing environment utilizing Teradata.Description:The ETL developer...

Pages