by: t2581 |
last post by:
I want to run single script that will attach to instance and restore db
example file restore_on_dev1.txt
-- file restore_on_dev1.txt
attach to DEV1 user bamboo using 123456;
restote database...
|
by: Peter Postlbauer |
last post by:
hi newsgroup,
is there a way to pass a parameter (e.g. password) to a db2script?
Example:
db2cmd /c db2 -t -fscript.clp
script.clp:
----------
connect to mydatabase user myself using...
|
by: rhjaisingh |
last post by:
Folks,
I need to create a batch file that will do the following -
Establish a DB2 instance
Connect to a certain database
Get data using an sql and output it to a file
So, this is what I...
|
by: Gregor Kovač |
last post by:
Hi!
I have an SQL script with bunch of CREATE TABLES, ALTER TABLES, ...
I'd like it to run transactially. I have found that id I run a ALTER
STATEMENT inside a transaction and then roll it back...
|
by: wb5plj |
last post by:
Hi I am having a problem passing some sql to the db2cmd via ant. This
is very confusing as I am doing this exact thing elseware with no
problem (just differant sql, and I have verified the sql is...
|
by: Mesan |
last post by:
Does anyone have an idea what it takes to administer DB2 through
PowerShell? I want to write some scripts to automate my common DB2
management tasks and I'd really like to be able to use...
|
by: vaibhavsumant |
last post by:
hi
I am trying to create the database using a BAT file but the script is not recognizing the username and password sent as parameters and gives error.
The BAT looks like following -
and...
|
by: WP |
last post by:
Hello, I have a very simple script (or would you call it a batch
file?) with the following content:
connect to mydb2;
DROP TABLE staff_employee_address;
DROP TABLE...
|
by: Azahary |
last post by:
Hi,
I'm using DB2v8.1.7 on window XP. I got
DB2CMD.EXE -> 5
SQL1042C An unexpected system error occurred.
when try to execute DB2 command on CLP.
Is there any solution for this problem...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
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...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
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...
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|