Search Results

Search: Posts Made By: Leo_NN
21,409
Posted By Leo_NN
SQLPlus spool file
HI

Have some problem with spooling out some relatively large number of records (~2-3 mil)
Small table - OK though.

Getting error: SP2 0308: cannot close spool file.

Any thoughts?


...
2,675
Posted By Leo_NN
Is it ok to do it that way: I can't do: ...
Is it ok to do it that way:

I can't do:

But I can


for some reasons?
2,675
Posted By Leo_NN
object_list="CUSTOMER ADDRESS TELEPHONE" ...
object_list="CUSTOMER ADDRESS TELEPHONE"

Here I wanted to check if $3 is in the object_list, not equal, but part of it.
For instance if $3="CUSTOMER" - OK.
So I need something like IN or *$3*...
2,675
Posted By Leo_NN
AWK syntax question
Hi,

Have to check file names in some given directory.

SO, What is the right syntax here:


*$3*=="'$object_list'" - just wanted to check if $3 is in the object_list.

And also, Do I...
5,402
Posted By Leo_NN
Or can I do it this way: with the stars around...
Or can I do it this way:
with the stars around $3 ?
5,402
Posted By Leo_NN
It is Friday, eow, have no more brain energy... ...
It is Friday, eow, have no more brain energy...

Is there way to use something like IN condition within awk


something like:



Thanks and have a great weekend!
5,402
Posted By Leo_NN
HI joeyg, What is this in here?:...
HI joeyg,



What is this in here?: _[0-9]\{14\}*_
5,402
Posted By Leo_NN
Thanks joeyg!!!
Thanks joeyg!!!
5,402
Posted By Leo_NN
Thanks , I've got it:
Thanks , I've got it:
5,402
Posted By Leo_NN
Nothing: So it is ksh88, right?
Nothing:



So it is ksh88, right?
5,402
Posted By Leo_NN
Yes, something like this, thanks. 1.Should...
Yes, something like this, thanks.

1.Should it be just "ls" instead of "ls -l"?
2.How to check if "object" is in the list?
3. what is the right syntax to put some params into grep, like
ls |...
5,402
Posted By Leo_NN
Here's what I got:
Here's what I got:
5,402
Posted By Leo_NN
print ${.sh.version} ksh: ${.sh.version}:...
print ${.sh.version}
ksh: ${.sh.version}: 0403-011 The specified substitution is not valid for this command.

so how to get the real version?
5,402
Posted By Leo_NN
Predefined : dir=$DATA_PATH vendor='LM' (...
Predefined :
dir=$DATA_PATH
vendor='LM' ( constant )
date: any valid date ( for now)

So input is : source

Output is : the list of files to use in FOR loop to process....
5,402
Posted By Leo_NN
It is korn shell for sure and ksh93 probably, but...
It is korn shell for sure and ksh93 probably, but not 100% sure.
and her's another question is there way to check what version of shell is using?
5,402
Posted By Leo_NN
Not sure, what you mean. Bad one: ...
Not sure, what you mean.

Bad one:
bad_file.txt

Good one:
LM_CM_TELEPHONE_20081024114245_1.txt
5,402
Posted By Leo_NN
How to get a list of files?
Hi,

That should be an easy one:

How to get all of the files names out of the given directory which are in given format?

vendor_source_object_date_filenum.txt

vendor: constant
source:...
19,188
Posted By Leo_NN
Thanks again!!!
Thanks again!!!
19,188
Posted By Leo_NN
Thanks MRC! Another quick one: What is the...
Thanks MRC!

Another quick one:
What is the right awk syntax and how to write/redirect records into two files(good and bad):
if (NF!='$temp')
then write to the bad_file.txt
else write to the...
19,188
Posted By Leo_NN
What is wrong?
What is wrong?
4,182
Posted By Leo_NN
thanks
thanks
4,182
Posted By Leo_NN
hi again, how should I use correctly:
hi again,

how should I use correctly:
4,182
Posted By Leo_NN
Quick and easy! Thanks as always!!!
Quick and easy!

Thanks as always!!!
4,182
Posted By Leo_NN
Thanks, but that's not it. I need...
Thanks,
but that's not it.

I need dynamically generate and substitute part of the variable name.

object=cust
echo $cust_num

object=policy
echo $policy_num

echo ${$object}_num????...
4,182
Posted By Leo_NN
Variable substitution
Hi,

That might be pretty simple.
How can I generate a variable name and get their value ?

Thanks a lot.

Something like:

>CUSTOMER_NF=26
> object=CUSTOMER

> echo ${object}_NF...
Showing results 1 to 25 of 34

 
All times are GMT -4. The time now is 06:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy