50 - 65 of 65 tags for linux

Pages

Using these settings the results of my SQL ran using Bteq is written to a file with no column headers, the only thing I can't figure out is how to get rid of the 10 spaces that are written to the export file before the results of the SQL.

My data:
15-MAR-11 07.54.08.000000 AM
15-MAR-11 07.53.40.000000 AM
15-MAR-11 07.53.04.000000 AM
15-MAR-11 07.52.55.000000 AM
15-MAR-11 07.52.16.000000 AM

My current DDL:
CREATE multiset TABLE dbname.dbtable
(
CREATE_DATE timestamp(6)
);

My current TPT Insert statement:
'INSERT INTO '||@TargetDatabase||'.dbtable
(
CREATE_DATE = :CREATE_DATE (TIMESTAMP, FORMAT ''DD-MMM-YYBHH.MI.SS.S(6)BT'')
);'

The data is being stored in the database table with century of '19' instead of '20'. My data will always be century of '20':

CREATE_DATE
1911-03-15 07:54:08

Teradata SQL Assistant Java Edition release 13.10 is now available for download. SQLA JE is an information discovery tool for retrieving and displaying data from your Teradata Database systems. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.

Hello - I am exploring the possibility of using an existing ETL tool (Ab Initio) to load data into TD Express databases for test/dev purposes. The ETL tool is already used to load data into a production TD system.

23/7/10 Urgent contract requirement ****EXCELLENT RATES******

Management of Enterprise Data Warehouse system in a highly dynamic environment. The person must be capable of applying innovative approaches to solving design and technical issues. Familiarity with a Teradata environment would be a definite plus.
*Experience with ODI or Sunopsis
*Development and data modelling, with strong Unix and SQL skills. Preferably with Teradata
*Redhat Linux hands-on experience
*Knowledge of ASG Rochade metadata management tool and Orsyp job scheduling tool is preferable. Training will be provided

23/7/10 URGENT Immediate interview and start for the right candidate
Familiarity with Oracle Data Integrator (ODI) ELT tool set would be a definite plus.
This person will need to be capable of working with functional and technical project managers, and Cognos and data architects to determine the appropriate set-up, configuration, documentation and support processes required to extend an existing data warehousing environment based on Teradata.

Teradata SQL Assistant Java Edition provides an information discovery tool that retrieves data from Teradata Database systems and allows the data to be manipulated and stored on the desktop. It is built on the Eclipse Rich Client Platform (RCP).

Teradata SQL Assistant Java Edition provides an information discovery tool that retrieves data from Teradata Database systems and allows the data to be manipulated and stored on the desktop. It is built on the Eclipse Rich Client Platform (RCP).

I have installed Teradata 13 on VMWare and trying to play around with it but have a few issues with bteq (being slow and hanging after a missing semicoln and so on).

Teradata SQL Assistant Java Edition release 13.0 is available for download. It provides an information discovery tool for retrieving and displaying data from Teradata Database systems. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX. It is built in top of the Eclipse Rich Client Platform (RCP) which allows SQL Assistant Java Edition to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database.

Teradata SQL Assistant Java Edition (SQLA-JE) provides an information discovery tool that retrieves data from Teradata Database systems and allows the data to be manipulated and stored on the desktop. It is built on the Eclipse Rich Client Platform (RCP). For more information on SQLA-JE, refer to SQL Assistant Java Edition.

SQL Assistant Java Edition is an information discovery tool that retrieves data from Teradata Database systems and allows the data to be manipulated and stored on the desktop. It is built on top of the Eclipse Rich Client Platform (RCP).