473,379 Members | 1,252 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

teradata-java

Hey...
i have a major doubt. is it possible to use an insert command in a loop while inserting data into a teradata table from java? if so can someone please give me the syntax?
Apr 11 '07 #1
1 1708
iburyak
1,017 Expert 512MB
You have to give more info to get an answer.

General loop in SQL is:


Expand|Select|Wrap|Line Numbers
  1. While (Some condition here)
  2. BEGIN
  3.     Insert statement here.......
  4. END

Irina.
Apr 11 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Paul Watson | last post by:
Is there a DB-API for Teradata? Is there any access to Teradata?
0
by: mgnmsoft | last post by:
Looking for experienced Teradata DBA with experience in conversion from Oracle to Teradata. US. Citizens needed for this position. Client will apply for Top Secret clearance. Please email resume at...
1
by: Michael L. | last post by:
hi everyone, It is relatively easy to translate RANK() from teradata to DB2, but I get to a glitch when I realize what Qualify RANK does. I know that there are a lot of experienced DB2...
12
by: jdokos | last post by:
Does anyone know of any good sources (white papers, etc.) regarding migrating from Teradata to DB2 UDB EEE? We are in the very beginning stages of investigating this as an option for some of the...
3
by: nolanmadson | last post by:
I'm creating a front-end for some Teradata user maintenance tables in MS Access. I've started having problems in occasionally not being able to insert or update records in these tables. I've been...
0
by: Akrishnamohan | last post by:
Subject:How to Run Action Queries in VBA-TERADATA?? Message: hi, Im trying in exceuting an action queris in Vba. Im able to connect to teradata. after connection,im imporitng through text pad...
2
by: mohanpadamata | last post by:
Hi frnds, I am searching for teradata material.its an urgent requirement in my project. i couldnt find materila to learn it.i dont have even a document.plz help me in this regard.if anyone has plz...
4
by: resmi318 | last post by:
I am running a query similar to given below. CREATE TABLE ABC_08 AS (SELECT x.col1, trim(x.col2), x.col3, x.col4, x.col5 FROM Table1 x
4
by: KMEscherich | last post by:
Version of Access = 2003 Hi there, is there a way to capture data using TERADATA SQL Assistant and import a portion of this database table into a Microsoft Access database table??? I currently...
2
by: iceman23 | last post by:
Hello, Any suggestion in the way I used CAST in TERADATA SQL: AND CAST (EXCEPTION_EVENT_TS AS TIMESTAMP(0) FORMAT 'MM/DD/YYYY HH:MI:SS') = EXCEPTION_EVENT_TS AND EXCEPTION_EVENT_TS BETWEEN...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.