09-07-2009
malcomex,
i have few doubts..
1.you said "line starts with Capital letter followed by two characters", whether it will account for only upper case characters?
2. i assume the first NF<1 is the one which splits the each set, so that a single insert statement is created?
3. how you are concatenating all the single single records into one insert statement?
For an example, 1st line -- Insert into table ('Fri Sep 4 06:25:51 2009'
2nd line will be splitted by : and created 'CREATE INDEX S100S_DC.PLInsuranceReportRules_testI1 ON S100S_DC.PLInsuranceReportRules_test1(ENTITY_KEY)'
How you are concantenating these two and the others?
Thanks for your help and time..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I have a text file text.txt which contains values as
ULTRA,OTHERS,Mumbai,16912
ULTIMATE,OTHERS,Mumbai,16913
ULTIMATIUM,OTHERS,Mumbai,16914
I want to read the file line by line and create insert scripts like
INSERT INTO TAB ( DESC,PLACE,NUMBER ) VALUES... (3 Replies)
Discussion started by: ultimatix
3 Replies
2. Shell Programming and Scripting
Hi Guys,,,
I have a file which is of this type.
abdc
defd
afds
adfse
I want to create a export statement like this.
Db2 "export to /clocal/rem/user/rem/used.txt of del select * from t.tel where name in ('abdc','defd','afds','adfse') with ur"
Please help me..
Thanks for... (2 Replies)
Discussion started by: mac4rfree
2 Replies
3. Programming
i would like to know how can i fine tune the following query since the cost of the query is too high ..
insert into temp temp_1 select a,b,c,d from xxxx
.. database used is IDS.. (1 Reply)
Discussion started by: expert
1 Replies
4. Shell Programming and Scripting
My script contains as follows,
VALUE=`sqlplus un/pwd <<EOF > OB.txt
set pagesize 0 feedback off verify off heading off echo off
select max(1) from table1;
exit;
EOF`
insert into table2 values(1, 'The max value is $value',...);
i need the value of VALUE to be inserted after 'The max... (2 Replies)
Discussion started by: savithavijay
2 Replies
5. Shell Programming and Scripting
Hi,
I'm trying to form an insert sql query using shell programming. I have table named company with four columns 'company name', 'company id', 'company code' and 'last change id'
I have to read the company name, company code and last change id from a file delimited by | which has around 10... (4 Replies)
Discussion started by: rakesh_s
4 Replies
6. Programming
Hello
i want help to load data from file into mysql DB
this part i know how to do
but during loading
i want to combine 2 fields into 1 field and insert into db as primary key in new column
thanks advice how to do so (5 Replies)
Discussion started by: mogabr
5 Replies
7. Shell Programming and Scripting
Hi all.
This is my first post on this forum. I've previously found great help in the huge knowledgebase that is here, but this time I have not been able to find a solution to my problem.
I have a large text file that looks like this:
typedef struct ABC_struct_nbr1_ {
char attr1; /*... (0 Replies)
Discussion started by: Yagi Uda
0 Replies
8. Shell Programming and Scripting
Hi,
I'm a first timer with Unix so pardon my ignorance.
I'm trying to read a comma separated file from the same folder where the script is and insert the value in a DB2 table.
I'm using AWK for the same. I'm getting `)' not expected error.
I'm not sure but for me it doesn't look like detailed... (8 Replies)
Discussion started by: Kabira Speaking
8 Replies
9. Shell Programming and Scripting
Hi
How do I translate
Let say
Cat inserts.sql
gives
Insert into PM9_TAXATION_ROUNDING
(STATE_GECODE, TAX_TYPE, TAX_AUTHORITY, SYS_CREATION_DATE, SYS_UPDATE_DATE, APPLICATION_ID, DL_SERVICE_CODE, ROUNDING_METHOD)
Values
('xx', 'xx', 'x', TO_DATE('10/26/2012 13:01:20',... (3 Replies)
Discussion started by: anuj87in
3 Replies
10. Shell Programming and Scripting
Hello,
In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data.
file -i filename.csv - gives... (2 Replies)
Discussion started by: Dharmatheja
2 Replies
LEARN ABOUT SUNOS
toupper
toupper(3C) Standard C Library Functions toupper(3C)
NAME
toupper - transliterate lower-case characters to upper-case
SYNOPSIS
#include <ctype.h>
int toupper(int c);
DESCRIPTION
The toupper() function has as a domain a type int, the value of which is representable as an unsigned char or the value of EOF. If the
argument has any other value, the argument is returned unchanged. If the argument of toupper() represents a lower-case letter, and there
exists a corresponding upper-case letter (as defined by character type information in the program locale category LC_CTYPE), the result
is the corresponding upper-case letter. All other arguments in the domain are returned unchanged.
RETURN VALUES
On successful completion, toupper() returns the upper-case letter corresponding to the argument passed.
ERRORS
No errors are defined.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|CSI |Enabled |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
|MT-Level |MT-Safe |
+-----------------------------+-----------------------------+
SEE ALSO
_toupper(3C), setlocale(3C), attributes(5), standards(5)
SunOS 5.10 14 Aug 2002 toupper(3C)