|
by: DB2 Novice |
last post by:
I am trying to use DB2 Control Centre (version 8.2) to load one flat
file into multiple tables. However, I don't see the options in Control
Centre that allows that.
Anyone knows how to do this?
DB2 Novice
|
by: donhyams |
last post by:
It seems like at one time I knew how to do this, but right now I'm
drawing a blank. I know there has to be an easier way to link tables
using more than one field.
Heres a simplfication of the problem:
I have two tables that are not normally linked to each other:
------------
tblClientStatusDetails with these fields:
...ClientStatusID =...
|
by: topmind |
last post by:
I need to search for database text with underlines in it. However,
underlines are interpreted as wild-cards in LIKE clause text . I need
to know how to escape the underlines so as to be able to search them.
Some DB's use an "Escape" keyword and others use a back-slash to escape
wild-cards. However, Jet does not seem to support either of these....
|
by: panchaga |
last post by:
Hi,
could any one help me with this select statement. i am using as part of JSP page.
i want to use wild cards as part of this select. i am getting error when i use % along with the name.
rs = statement.executeQuery("SELECT * FROM lessons WHERE fname='"+ name+ "'");
Thanks
|
by: new214 |
last post by:
Hey all, got abit of a problem. Ive got a database where ive got 2 tables. I want to create a command which selects * from table 1 and if the same values are in table2 - it updates otherwise adds. Ive got a loop so i can run through the data records But i dont know how i check 1 objrs against another within an sql statement?? please look at...
|
|
by: SQL Learner |
last post by:
Hi All,
I need to link two tables using partial word match.
How can I write a SQL statement to do so? (I am using MS-Access.)
Table One:
123 ABC Street
124 ABC Street
125 ABC Street
|
by: nehashri |
last post by:
hi
i am designing a database using Ms Access and ASP. i have 3 tables in access namely 'PERSONAL', other as 'POLICY' and 3rd one is named as 'STAFF'. in the contact table i have ID, Name, Children as fields. Also in policy table the firlds are:- ID, date_of_policy, no_policy, amount_paid, amount_balance and similarly the 3rd ie., staff has few...
|
by: Sreeraj |
last post by:
hi,
I am a beginner in Python. I wish to know how can i filter a list of
strings using wild characters.ie
Lets say i have list countries =
. I need only the list
of string starting with 'a'.
thank you
|
by: iheartvba |
last post by:
Hi,
I already have 3 Databases running:
A. they all have the same tables and the same structure
B. There is no 1 Master table they are all separate tables
What I want to do is to merge them into 1 Master Table to be able to generate reports etc. An append query will not suffice because some fields get updated in the orginial databases.
I...
|
by: simple simon |
last post by:
How would I insert into multiple related tables using a table valued parameter? Is there any way to do this without using a WHILE loop?
I know how to insert from a table valued parameter into one table:
INSERT INTO dbo.Table
SELECT * FROM @TVP
But what do I do when I want to insert all of someone's information into multiple tables, and...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
|