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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tdatgod

    Compiling C program with Visual C++ 2005 Express Edition?

    You are specifying something on your command line that the compiler doesn't like. Then it is taking one of your incorrectly specified options as your file name and trying to compile that instead of you .C file. Could you Post the command line you are using to build your module?
  2. tdatgod

    Storing Graphics

    Hi, There is a program in the CLI Installation called BLOBSRVR. The Sourece code ias in the sample directory. Basically it creates a table filename char(30) partno integer data varchar(32000) (or 64000) then it basically takes you graphic and breaks it up into...
  3. tdatgod

    Storing Graphics

    BLOBS were released in V2r5.1
  4. tdatgod

    Teradata question insert

    Can you post your queries? maybe you can simply UNION your 2 queries together. insert into mytable ( select * from evens union all select * from odds ) ; The ALL on the union tells it not to eliminate duplicates. Since I know the tables don't overlap I can...
  5. tdatgod

    String concatenation...

    you use Double OR Bars || to do concat.. This is the same as the 'C' Language Logical OR Operator. sel 'Test Text ' || MyFieldName as mytext from MyTable; Make sure to add proper spacing. Without it it all runs together. sel 'This' || 'is' || 'a' || 'test.' as...
  6. tdatgod

    Teradata question insert

    Hi, With teradata you want to do everything in SETS. Here I populate a table with 10 rows create a table with 1 million rows by a cartesion product of the first table and your constants. ct numbers, no fallback ( k integer ) unique primary index(k); insert into numbers...
  7. tdatgod

    Version of Modules

    Hi, I found the FAQ for listing which modules are installed on my system.... What modules do I have installed? faq219-5657 Posted: 3 Feb 05 and using this method I can display all the modules on the system. However since that does a directory walk, there is no VERSION information. Is...
  8. tdatgod

    Password Protect a folder on Unix

    Write the Contents of the directory to a CDROM and put in your Desk. Then Delete the Directory. When you want to see the files, remount the CD. Sorry UNIX DIrectory/File permissions are very limited. Maybe there is an encryption package that you can use to Encrypt the whole directory and...
  9. tdatgod

    uninitialized value in substitution iterator

    Because your variable $translate{$1} translates to UNDEFINED because $1 doesn't match any of your %translates Keys . Your Input atgatg is translated to uacuac by the tr/atcg/uagc/ And uac doesn't have a translation.
  10. tdatgod

    Problem with result set generated by fast export

    1.85460621446000E 007 is really 18546062.1446 and this won't fit in a ( 9,4 field ) you need to make it a 13,4 field to accomedate this number. Sum(zeroifnull(field1)) (Decimal (13,4))(CHAR(20)) or something like that
  11. tdatgod

    Create Trigger examples?

    Hi, We don't have recursive Triggers. WEll maybe in 6.x now I forget. The best you can do is create a LOG TABLE to record who is making the change. Why not simply use the Variable user when inserting the row? update blort set myuser = user...
  12. tdatgod

    REBUILD Utility Cannot be run on a non-AMP vproc

    Hi, you must run REBUILD from DBW/cnstool. It doesn't run from the cmd prompt. Its a DEMO.... Unistall it and Reinstall it. Make sure to answer Yes to do you want to remove the TDCONFIG dirrectory. Its not like there is any DATA out there that you can't get back from simply re...
  13. tdatgod

    Identity columns in Teradata

    Hi, IDENTITY COLUMN is not the same thing as AUTO INCREMENTING. There is no ANSI requirement that IDENTITY be Contigous numbers just that they be UNIQUE across the whole table. So which do you want a UNIQUE IDENTITY COLUMN ( which is implmeneted in v2r6 ) or an AUTO INCREMENT column...
  14. tdatgod

    How to Execute Stored Procedure from Unix

    This worked for me.... echo "sel * from dbc.dbcinfo;" | bteq "logon copid/user,password" I guess you could substitute "call sp1;" for "sel * from dbc.dbcinfo;"
  15. tdatgod

    Import Logon Statement for FastLoad

    Hi, .run file = fileid is BTEQ. Start fastload in interactive mode and type HELP; it shows the command.... RUN fileid ; therefore try RUN cmplogon; and see if that works.
  16. tdatgod

    Sed to insert string after second comma

    Why does it have to be SED? Is this a home work assignment? Tek-Tips frowns on asking for help on Home work Assignments. Will there always be 2 strings followed by the 6 NULL fields.? a,b,,,,,, or could there be othe caase like.... a,,,d,,, or a,b,c,d,,,, I mean could you simply...
  17. tdatgod

    Multiple default databases?

    No. Macros are automatically fully qualified before they are stored if you are default database John and execute create macro m1 as ( sel * from t2 ; ); the Macro is expanded to create macro john.m1 as ( sel * from john.t2 ; ); before it is stored. therefore no matter who...
  18. tdatgod

    teradata.jar for Teradata demo

    Hi, Isn't the Teradata.Jar on the DEMO CD? Under the TTU 7.0 Installation portion. If not contact me at.... http://www.teradata.com/teradataForum/logon.aspx?MemberID=105&Task=doEmail you might have to register with Teradata.Com
  19. tdatgod

    date -d & pulling out hair

    Hi, I did a man date on my solaris 9 box and it says FSF Last change: GNU Shell Utilities It supports the -d option, but I can't find where it is installed on our server. /usr/bin/date doesn't support it as you pointed out. Maybe you can find the GNU shell utilities...
  20. tdatgod

    How to validate telephone number in sql

    Hi, I know someone was in the process of writing a regular expression UDF but I can't seem to find it anywhere.

Part and Inventory Search

Back
Top