#DateForumTypeThreadPost
2209 Sep 2014 @ 07:14 PDTGeneralReplyBTEQ export through shell scriptHi Radsubra, I haven't got a chance to test the below sql with bteq export. But it worked fine on sql assistant. sel CAST ( 'FILE_NAME' || TRIM(TBL.FILENAME) || x'0A'  ...
2104 Mar 2014 @ 08:27 PSTToolsTopicRe: Delete Syntax in MLOADHi, I need to delete the rows from table in mload script which are not matching in the file. Tried couples of ways but couldn't succeed. DELETE FROM Employee WHERE EmpNo <> :EmpNo a...
2029 Jan 2014 @ 08:37 PSTToolsReplySQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.11.0.04@kawish Do i need to Uninstall the .Net provider and then Install it again.. or I can just Install it ..
1929 Jan 2014 @ 08:35 PSTToolsReplySQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.10I tried it already but it didn't helped me ..
1828 Jan 2014 @ 08:13 PSTToolsTopicSQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.10 SQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.10 I am unable to Define ODBC Data Source in Teradata Sql Assistant.   File Not Found Une...
1710 Jan 2014 @ 07:33 PSTToolsTopicBTEQ ERROR CODE .QUIT 66Hi, Could some help me out what is .quit 66 usage in the below statement. .IF ERRORCODE <> 0 THEN .QUIT 66; Thanks balu
1626 Sep 2013 @ 07:54 PDTToolsReplyFile Name Based up on the cloumn data.Hi Feinholz, Usually I used to change the files name at the end of fexp using the .SYSTEM cmd As our eniv us unix.. I have an Idea but dont know whether it works. Storing all the Distinct Id'...
1524 Sep 2013 @ 04:09 PDTToolsTopicFile Name Based up on the cloumn data.Hi, I have requirement where i need to send mutliple files based on the data. Our enivroment is Unix and teradata. EG: below is table with sample table. C_Name   ID xxxxx  &...
1424 Sep 2013 @ 04:00 PDTToolsReplyFast Export and MLoad Thanks Dhiraj and Thomas,   Thomas Could please explain me in brief or any place i can get more infomation about NP AXMOD.   Thanks balu
1305 Sep 2013 @ 07:04 PDTToolsTopicFast Export and MLoad Hi, I have a requirement i need to export a data from one table using fast export  Parallel load it into a table using MLOAD. I can write seprated Fast export and Mload but As the table is h...
1202 Jul 2013 @ 07:06 PDTGeneralReplyinterview helpHi, please forward to the hereiam.balu@gmail.com   Thanks
1108 May 2013 @ 08:27 PDTGeneralTopicCheck the Header of Flat file while MloadEvery day i will receive a Flat file which i have Mload it in prod. So i have to check the Header in file and make sure it matches with old one. File Delimited '|' Eg : S_NO | LNAME ...
1029 Mar 2013 @ 08:07 PDTDatabaseTopicLoad clm with 12 hour time format Hi I need to load a file using mload where  the load clm has a data like this 03/29/2013 12:00:00 PM. select cast(cast('03/29/2013 12:00:00 PM' as timestamp(0) format 'MM/DD/YYYY...
919 Mar 2013 @ 11:55 PDTToolsReplyRe: remove the CRLF in the fastexport generated fileHi Dnoeth, Thanks for replying.. I dont have an option to use OReplace or OTranslate.. Is there any other way i can get out from it..   Thanks balu
819 Mar 2013 @ 08:47 PDTToolsReplyRe: remove the CRLF in the fastexport generated fileThe Record may or may not contain CR. If it has don't how many CR it will be..  
719 Mar 2013 @ 08:37 PDTToolsTopicRe: remove the CRLF in the fastexport generated fileHi, I need to export file with certain fields. Where one of coulmn data has a CR. For eg:               cml4  record1 aaa&n...
607 Mar 2013 @ 04:55 PSTDatabaseReplyTimestamp format not working to get the two digit yearHi Doneth, Concat worked !! Thanks Balaji
507 Mar 2013 @ 06:32 PSTDatabaseReplyTimestamp format not working to get the two digit yearThanks Mjj, Could plz let me know how to over come this issue in teradata..    
406 Mar 2013 @ 01:24 PSTDatabaseTopicTimestamp format not working to get the two digit yearHi, My Source data has only two digit year when i am trying to convert to timestamp sel cast('12/12/12 00:00:00' as timestamp(0) format 'MM/DD/YYBHH:MI:SS') o/p 12/12/1912 00...
306 Mar 2013 @ 01:20 PSTToolsTopicError when loading table using OLE LoadHi I have flat file i need to load it into a table.. I am trying load the using OLELoad utility. When i trying to establish a connection to teradata database in desitnation field. Getting a POP ...
206 Mar 2013 @ 12:32 PSTDatabaseReplyTimestamp format not working to get the two digit yearIntersting thing is in above eg is date you can "19" 12/12/1912 00:00:00
106 Mar 2013 @ 09:13 PSTDatabaseTopicTimestamp format not working to get the two digit yearHi My Source data has only two digit year when i am trying to convert to timestamp sel cast('12/12/12 00:00:00' as timestamp(0) format 'MM/DD/YYBHH:MI:SS') o/p 12/12/1912 00:00:...