I need to insert data from a file to another. I need this to form an sql query file which will consist of 50.000 INSERT INTO sentences.
my sql query file will consist of 50.000 times the below line consecutively:
Code:
insert into subscriber (BLINDID,NAME,SURNAME,EMAIL,USER_AUTHORIZATIONID,REM_REWARD,STATUS,IS_BLACKLISTED) values ('DATA','name','surname','DATA@test.com','1','1000','3','0');
I need to insert a given list of Subscribers into the places i specifed as DATA above. how can i manage this? The given data consists of 50.000 numbers. Any suggestion, solution wellcomes.
Note: I tried with MS Excel but coudlnt make it because it senses the characters " ', @" in the queries as special formula characters. I tried data generator program also but failed
I have to query a DB2 database, and sometimes they take a long time to produce results. Can I run these queries in the background, and if so, where will the results appear? (1 Reply)
Can anyone help..
I have a .dat file which contains 5 columns of data. I need to select one row containing just 3 of the columns. I'm not sure how to select a single row? I then need perform arithmetic on on two out of the three columns and display the output in a new column.
For example..
... (1 Reply)
Hi,
I new to Unix and scripting. Following is my requirement. Can someone tell me whether its possible or not. Also please let me know how to proceed further if this is possible.
List of queries are stored in a file. For example, I have to run a query like this:
Select * from &XYZ where... (0 Replies)
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
dear all,
i want to insert string in file to mysql i just want how to do that cause i am poor in sql languages ...
so this file like this
DATA.txt
doni|student|westjava|123412|lombok|
iwan|student|westjava|1234412|utankayu|
rio|student|westjava|12342|cempedak|
so i want insert DATA.txt to... (2 Replies)
Hi All,
I have a file queries.txt as follows :
SELECT COLUMN1 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN1 FROM SCDEMA2.TABLE2;
SELECT COLUMN2 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN2 FROM SCDEMA2.TABLE2;
SELECT COLUMN3 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN3 FROM SCDEMA2.TABLE2;
SELECT... (2 Replies)
Dear community,
could someone help me to join 2 queries into one?
Basically it's the same query with different clauses (please notice the FIELD3 filters and related counters into the subquery):
SELECT A.FIELD1,A.FIELD2,A.FIELD3
FROM
TABLE A
INNER JOIN
(
SELECT FIELD1,... (3 Replies)
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT DEBIAN
stapgraph
STAP(1) General Commands Manual STAP(1)NAME
stapgraph - systemtap grapher
SYNOPSIS
stapgraph [ OPTIONS ] FILENAME [ ARGUMENTS ]
stapgraph [ OPTIONS ] - [ ARGUMENTS ]
stapgraph [ OPTIONS ] -e SCRIPT [ ARGUMENTS ]
DESCRIPTION
The stapgraph program is a simple frontend to stap that produces graphs from the output of stap scripts.
This manual corresponds to version 1.7.
OPTIONS
stapgraph accepts all options accepted by stap. They are passed through to the stap process running the script or probe points.
USER INTERFACE
The script that produces results can be started from a dialog within the program, in addition to being launched using the program's command
line arguments. This dialog allows arguments to be passed to stap and to the script.
When running, a mouse left click on a graph pauses the display of data, even though it is still collected by the program. Dragging the
mouse scrolls the graph backwards and forwards in time; clicking the displayed pause button restarts the display of new data.
The scroll wheel can be used to zoom in and out on the graph.
SCRIPT OUTPUT SYNTAX
Scripts can output Comma Separated Values (CSV) which will be interpreted by stapgraph. The first value is the X coordinate of the graph,
usually a time value. stapgraph assumes that this value is constantly increasing.
A different syntax allows the script to specify many details of the graph's appearance.
%DataSet: DATA-SET-NAME SCALE COLOR GRAPHSTYLE
The data set name identifies a data set that will be emitted by the script. "SCALE" is the overall vertical scale of the graph for this
data set. "COLOR" is a red-green-blue hex color. "GRAPHSTYLE" is one of bar - a traditional bar graph dot - plotted points discreet - An
event style timeline that records that an event happened at a certain time.
%Title: TITLE
A title for the whole graph.
%XAxisTitle: TITLE
The legend for the X axis
%YAxisTitle: TITLE
The legend for the Y axis.
%YMax: MAX VALUE
The maximum value displayed on the graph.
GRAPH DATA
DATA SET TIME VALUE Each data point that is to be plotted is tagged with the data set name, followed by the time and value of the point.
SEE ALSO stap(3stap), staprun(3stap),
BUGS
Use the Bugzilla link off of the project web page or our mailing list. http://sourceware.org/systemtap/,<systemtap@sourceware.org>.
Red Hat 2013-05-14 STAP(1)