Search Results

i have the following create table definition ,the shell script has to search for the first column name of the create table definition in the file and explicitly add primary index (first column name)...

sorry .. as iam not not getting how to start a new thread,i have mailed you.

could you please let me know ho to start a new thread,so that i can post my request

could you please help :

i have written script to search the for PRIMARY INDEX and if found display the whole definition of create table:


ISSUE NOW IS:

to store the table name in a variable...

could you please help :

i have written script to search the for PRIMARY INDEX and if found display the whole definition of create table:


ISSUE NOW IS:

to store the table name in a variable...

i have the following create table definition :

ct t15(
c1 varchar(32000),
c2 char(32000),
c3 int);

i have to store the table name in a var and serach for update and show table on that table...

hi,

i have modified it like this :

list_files()
{
if [ -f $1 ]
then echo $1; return;
fi

cd $1
echo; echo "Processing---> `pwd`:"; #Display Directory name

for i in *
do
if test -d...

actually my requirement is :

i have to search the create table definition in all the files and print the create table definition starting from CREATE TABLE to ;

i have the following perl script.but it searches for a given filename.

i want to run the same script in my directoy which has subdirectories too and it has to display the file if sreach satisfies...

actually it has to search the whole create table definition if found

starting from CREATE TABLE ....... to ;

Example:

if the contains :

CREATE TABLE Table1, FALLBACK
(col1 CHAR(4),
...

i want create table definition also:

List out the file names which has “create table upto ; “ even if it's in next line.
List out directory found and the file name which satisfied the above...

i have tried with grep like this didn't help my requirement
Requirement:

check for the table definition which does not have "primary index" as in example in the whole directories which has...

The script should check the entire create table definition upto ; and list out the test suite names which does not primary index in the definition.

Example:
main directory which has subdirectries...

The script should check the entire create table definition upto ; and list out the directories names which does not primary index in the definition.

Example:
main directory which has...

The script should check the entire create table definition upto ; and list out the test suite names which does not primary index in the definition.

Example:
main directory which has subdirectries...