Search Results

I'm fine with after NULL till the NO ORDER.

You see a paranthesis because its part of CREATE TABLE command,
CREATE TABLE (
Column1 int,
Column2 int,
...

RudiC - My apologies for not using the code. Thanks for making it code format. The statement that you mentioned is not required for the output. It is not considered as a column in the target...

Can anyone help me with sed or awk to do a bulk replace of the below requirements.

"REC_ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (
START WITH +7486
...

Thank you so much :)

I have a person script which has a following statement.

BUILD_FOLDER=$2
i=$((${#BUILD_FOLDER}-1))

if [ "${BUILD_FOLDER:$i:1}" != "/" ]
then
BUILD_FOLDER=$BUILD_FOLDER/
#echo...

2014-05-31-18.22.18.500158-240 E11115478A502 LEVEL: Info
PID : 25100668 TID : 73282 PROC : db2sysc 0
INSTANCE: udbin001 NODE : 000 DB : IBDSYS01...

Ohh my god !!! it works perfectly what i was looking for. Thank you so so so much. Lovely.

---------- Post updated at 04:04 PM ---------- Previous update was at 03:54 PM ----------

Don't mind...

2014-05-31-18.22.18.500158-240 E11115478A502 LEVEL: Info
PID : 25100668 TID : 73282 PROC : db2sysc 0
INSTANCE: udbin001 NODE : 000 DB :
APPHDL :...

I'm looking forward to learn something via this unix.com. You call me Non-Sense doesn't make any sense. Some people doesn't quote properly in english but they are all just looking for to take some...

I've not tried anything. I was going through the SED tutorial how to extract things which is between the single quotes. Not deriving anything as of now.

USING ('/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT1',
'/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT2',
'/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT3',
...

I've written a shell script to create id in oracle database. However in some db the script just hanging.
How can I say to the script "If you are hanging for more than 3 min" then kindly come out...

I am calling a perl script from shell script.

$ cat mah_appln_bkp_oln.ksh
#!/bin/ksh
. /udb/home/udbappln/.profile
. /udb/home/udbappln/sqllib/db2profile...

I've notepad in which logs are present. I need to design a web page by which if some one paste their ticket number and click on "search" the logs for that ticket number should be displayed at the...

I wish to convert the following in shell. Help me SED or AWK

ID= 12345,23456,67859 , 90225 , 67583

I can extract the right hand side of "=" using cut command "cut -d "=" -f2

after...

I've a Centralized Server which can connect to all Oracle Databases.

When I was trying the below code it doesn't work, But tnsping was working fine.

#!D:/perl5/bin/perl.exe

use DBI;

my...

I have script for all oracle prod db. I have hard coded the username / password. I need a mechanism to encode and decode the username / password in a shell script.

Another challenge is I use the...

Need commands for following,
At any give time

Peak CPU
average CPU
Free memory paging
swap %

If any one can help in linux also, it would be fine.

thanks

Gopalan V

Thanks. Let me know how to check the present CPAN Modules in my AIX server. Any specific commands.

Thanks
Gopal

Env: AIX 5.3
I was doing shell scripting and for my Oracle DB.

Now there is a requirement to use Perl instead of Shell

Can anyone give the equivalent of this command in Perl

`Sqlplus -S...

I just want to test the for loop like this. I have loops like
for i in `cat /home/oraclesid` ; do
..
..
..
done

but am not sure why am not able run this kind of for as i given below

for...

hi all
I am trying put some array and looping logic in my shell script. I am good in shell scripting. I dont knwo why the below if failing ? I got this input from Oreilly Sed & Awk nutshell.

...

Thanks... Hope i ll get into it deeply.

Dear all,
I am sound in Shell scripting but not in Perl scripting. I need a simple Perl script which i can write the content in Excel sheet1 and other content to sheet2

for example...

not being smart in .bat scripts. first.txt file is automatically generated by SQL. I need to copy these content to another file May be u can say i should append to another file (out.txt).
so i dont...