Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mvnrk

  1. mvnrk

    No of Load Utlities

    Thanks for Information
  2. mvnrk

    No of Load Utlities

    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
  3. mvnrk

    Kill session / User

    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...
  4. mvnrk

    Hi When I do fast export from a

    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...
  5. mvnrk

    sequence numbers

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

    sequence numbers

    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
  7. mvnrk

    Hi When I do fast export from a

    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...
  8. mvnrk

    V2R5 New Features

    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
  9. mvnrk

    Primary Index

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

    MLOAD Commad line options

    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.
  11. mvnrk

    Suggestions needed for the teradata exam

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

    MLOAD Commad line options

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

    Fast Export Help

    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
  14. mvnrk

    How to write BTEQ batch scripts in Unix

    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...
  15. mvnrk

    Cached lookups

    What is cached lookups? What is dynamic cached lookups?
See more

Part and Inventory Search

Back
Top