Search results for query: *

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?

...x ++; insert into blobtbl values (filename,x,buffer); end close fd; then to get the data back out you specify sel * from blobtbl where filename = 'filename' order by partno; fd = open(newfile); while ( num = fetch(buffer)) write...

BLOBS were released in V2r5.1

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

...from MyTable; Make sure to add proper spacing. Without it it all runs together. sel 'This' || 'is' || 'a' || 'test.' as mytext; *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. mytext ------------ Thisisatest. I added the...

...insert into numbers VALUES(7); insert into numbers VALUES(8); insert into numbers VALUES(9); INSERT INTO STUDENT sel 1+ a.k + ( b.k * 10 ) + ( c.k * 100 ) + ( d.k * 1000 ) + ( e.k * 10000 ) + ( f.k * 100000 ), 'FirstName','LastName','Major'...

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

...the file to a TEMP location when you want to view it or modify it and then encrypt it again as you write it back to the directory. Which flavor of *NIX are you using? AIX, Solaris, Linux, SCO? Maybe they have some proprietary File system format that can do what you want. Maybe you...

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.

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

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

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

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

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;"

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.

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

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

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

...minutes to avoid the if statements with 00:00 - 00:04 becoming 23:55 - 23:59 #! /bin/csh set h = `date "+%H"` set m = `date "+%M"` @ min = ( $h * 60 ) + $m + 1435 @ h = ( $min / 60 ) % 24 @ m = $min % 60 echo "$h $m" | awk '{printf("%2d:%2d\n",$1,$2)'}; I used awk to make sure I could...

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