I try to use Teradata Fastload utility to load TAB delimited text file.
According to documentation delimiter is defined by following statement:
SET RECORD VARTEXT "c"
where c is the delimiter.

I'm an Oracle forms application designer by trade working for a DoD
contractor, but my company has asked me to recommend a database backend
and front end development tool for its own internal use.
The requirement is 50+ users in several geographic locations therefore

can i add auto index in the oracle database table?
how to check the no. of entry in the field?
thanks!

I am a novice to DB. I am working with Postgresql. The following is
*not* an academic assignment. I suspect this could be an FAQ.
The required data to be stored is graphs with nodes and branches
belonging to various types. Based on each type, more data needs to be

I'm trying to determine whether or not 'status' is a reserved word for
some SQL standard, and have encountered conflicting information.  The
following reserved words checker suggests that it isn't:
http://www.petefreitag.com/tools/sql_reserved_words_checker/

How would one go about renaming columns in MySQL?  Neither of the
following seem to work:
ALTER TABLE phpbb_users RENAME username TO usertest
ALTER TABLE phpbb_users RENAME COLUMN username TO usertest

Can somebody tell my something about performances when using mysql and php!
Where i can find document about this performance?
How php and mysql behave in use of multiple connections?

I'm currently designing my first complex database, and I'm somewhat
stumped on how to store ordered lists data. I have an object that
represents an instruction, and I have an object that has a list of
these instructions. The instruction must be ordered, and I need to be

I'm trying to write a modification for phpBB that protects against
common exploits, and am currious as to whether or not blocking all
requests containing the substring 'UNION' would be sufficient to
protect against SQL injection attacks involving UNIONs.  If it isn't

I've just been researching deadlocks (yes, we
sometimes use Sybase;-) and came across
the generic advice to always access
(and implicitly lock) tables in the

My Oracle DBA friends once explained to me that null values, when used
as a part of a restriction clause in SQL do not take advantage of any
indexes placed on that specific column. As in the generic example
below:

I have a set of USERs.
Each USER can have multiple DEFAULT_LISTs that belong to it.
Every DEFAULT_LIST belongs to one USER.
Each USER can have multiple FILEs that belong to it.

update COST_TAB,POS_TAB,OBJ_TAB
set cost_tab.f38=epl.pricesu,POS.F2119='1',OBJ_tab.F22=EPL.UM
FROM    COST_TAB COST_TAB
    INNER JOIN EPL EPL ON COST_TAB.F26 = EPL.SKU AND COST_TAB.F38 <>

I will implemented a MySQL database on a Website. There will be a date field
on this database and I want this field to be check automaticly to make an
actrion if the date expired.The "program" must run by imself on the server.
How can I do that? I was thinking that a CGI script on ...

Does it exist CEIL function (returns the smallest integer that is
greater than or equal to the argument) in Teradata?
I can't find it. Any implementation ideas?
Thx