#DateForumTypeThreadPost
1123 Mar 2009 @ 05:31 PDTToolsReplyLoading a timestamp column with FastloadNo, I had not. Vielen dank, that worked wonderfully.Thank you very much,Susan
1019 Mar 2009 @ 08:39 PDTToolsTopicLoading a timestamp column with FastloadFastload is rejecting my attempts to load a timestamp column with the Invalid Timestamp Error 6760. I am attempt to load data like this:20010429 04:07:55.940000with this statement in the DDL part ...
928 Jan 2009 @ 06:56 PSTToolsReplyHow to suppress column headings in BTEQThanks, Wiinter09, you set me on the right track. I tried your suggestion and had the following error message from BTEQselect count(*)as REC_CNT (TITLE '') from TABLEA; ...
826 Jan 2009 @ 10:43 PSTToolsReplyFastload - keeping your logon id and password secureExtremely grateful thanks, that worked a treat. Best wishes,Susan
726 Jan 2009 @ 07:23 PSTToolsTopicFastload - keeping your logon id and password secureI had a bright idea and wrote a Unix shell script that requires a Teradata logon and password as parameters. I thought I could then could substitute that logon on and password into my fastload scr...
620 Jan 2009 @ 05:21 PSTToolsTopicHow to suppress column headings in BTEQI would like to suppress the column heading and underscore output from the following BTEQ script. Please could you let me know how to do this, the manual seems to omit this option. I can get roun...
519 Jan 2009 @ 11:45 PSTToolsReplyHow to return BTEQ and Fastload error codes to UnixThanks for both responses - apologies for my basic error - penalties of trying to do something too quickly.Regards,Susan
416 Jan 2009 @ 11:46 PSTToolsTopicHow to return BTEQ and Fastload error codes to UnixI am running fastload scripts and BTEQ scripts from a UNIX shell script. Everything was going fine until I inserted a test to make sure there was a return code of 0. My fastload script, in the fa...
309 Jan 2009 @ 06:21 PSTToolsTopicLoading multiple tables with Fastload only logging in onceI am attempting to login once to Fastload and then run a number of Fastload scripts to load different data to different tables. My test was just to merge two scripts together, dropping the logoff ...
209 Dec 2008 @ 07:19 PSTToolsReplySecuring passwords in Fastload, Multiload, etc in UNIXI replaced the logon and password in the script with .run logon.txt where the file logon.txt contained the logon and password and it worked with no problem. I am now asking our UNIX people how the...
108 Dec 2008 @ 06:03 PSTToolsTopicSecuring passwords in Fastload, Multiload, etc in UNIXWe have just had Teradata Tools and Utilities loaded to our test UNIX (AIX) environment. We can run Fastload, Multiload and FastExport scripts successfully using such command line entries as fastl...