Search results for query: *

Thanks for Information

Hi How can I find No of Load Utilities(fexp,mload,fastload) that are running at any given time in the system.Can I query any dbc tables to get this information ? Thanks in advance

Hi How do you kill a Mload session or all sessions by specific user? Can anybody tell me exact steps on how to perform above functinality.(like from which tool/which screens)? Here is the background of the situation: We were loading data from ETL server(using ETL tool) using mload utility...

Hi GORYN Thanks for your solution. When you cast columns with char, it pads blank spaces for varchar columns.Thats one problem. If you trim padded space using trim function, it becomes variable length record size, when it becomes variable size record length, Fast export will create record...

Hi dnoeth (Instructor) Thanks for your reply. Can you elaborate on generating Sequence numbers in ascending order using Inmode or OLAP functions. Thanks mvnrk

Hi How can I create a sequence numbers in Teradata. I like to assign sequence numbers to specific integer column in ascending order. I have a incremental data load using mload. Thanks mvnrk

Hi When I do fast export from a table(table has 50 columns with integer, varchar, date data types) to flat file, the first column it is creating a junk character. I think it is doing that because of varchar data type. It is creating 2 byte column/record length as a first field in fast export...

Hi Can anybody point out differences between v2r3 & v2r5 versions. Where can I find more information on differences? Can anybody consolidate these differences? Thanks mvnrk

Hi Can we update Unique Primary Index field/value in a table.If so, does it effects AMP distribution after update? Thanks mvnrk

Hi Thanks for your reply. I have used .ACCEPT var1 FROM FILE /data/sam_030811.txt ; .IMPORT INFILE &var1 It is giving error 0025 .ACCEPT var1 FROM FILE /data/sam_030811.txt ; **** 11:33:16 UTY4811 # of Variables is less than # of data provided. 0026 .IMPORT INFILE &var1 Any clue on this.

Hi BillDHS, WHat is TUF? Do you have website for TUF? Thanks mvnrk

Can we pass IMPORT INFILE file name with path as command line parameter while loading data using mload under Unix environment? Thanks in Advance

Hi I'm creating delimiter data file using Fast Export on SunOS release 5.8 system. Fast export is working fine but it is creating one special (junk like ^A ) character as first character for each record. I don't know how to get rid of it. Any help would be highly appreciated. Thanks

Hi How can we write Bteq batch scripts in UNIX?. I need to write Unix shell script. To star with : I need to do some file checking on unix file system, then based on file existance, I need to run diff SQL in Teradata Bteq. After that, depending on Results of SQL, I need to code other shell...

What is cached lookups? What is dynamic cached lookups?