UNIX for Advanced & Expert Users

I'm trying to find the syntax for running DBsurvey scripts in UNIX. This is for a Sprint's cellular network (Lucent hardware). I can't find anything in Sprint or Lucent documents. Can anyone help me? A simple script looks like this:

DB: ecp
MATCH: field_name GE 1
OUTPUT: field_name1 field_name2 field_name3, etc ...
ENDDB

Thanks,
Roy

Running an SQL query against Lucent hardware is the way you described your problem. Accordingly, your problem is an SQL problem. First you must get the details on the Lucent H/W, the database, the listening sockets and processes.

Then you determine how generic and open the SQL interface is....

If it is open, then any nice SQL query tool will work for you.

If closed, you might have to use a vendor specific product to do the query.

Please most more architectural details and we will try to guide you.

Hello,
I don't know any SQL.
In UNIX, I enter the following command to run the scripts:

DBsurvey -i script_name -o output_file_name

This creates an output file (output_file_name), also called a data dump, in the current directory. The output file conatins all the current values taken from the field_name on the script. The only info from Lucent docs I found about the DBsurvey command is:

Data Base Survey - A flexable, general purpose database query mechanism which is a UNIX System level process (DBsurvey). It is accessed from a UNIX system terminal. It allows the user to query the application databases and to extract specific infomation by using a DBsurvey input message.

I need some more keywords that I can use in the script so that I can have more control. I don't really know where else to look.

Thanks.
Roy

Hmmm... the Lucent doc does sort of imply DBsurvey can be
used to query application databases of various types.
However they are not specific...

Perhaps looking at the script you're using may help us
help you further.

OK, now I think I understand.... this may or may not be an SQL query.... it is just some query to a database that is part of the Lucent management application.

This implies that your command line utility DBsurvey does the query for you based on a configuration file read from the command line, script_name .

If you can help with the investigation on your end, we can proceed on this end:
[list=1][*]Is DBSurvey a binary file or a text file?[*]Does the command man DBsurvey produce any output?[*]Does the command DBsurvey -help provide any output?[*]What is the output on the screen of DBsurvey without any arguments?[/list=1]

If you can be kind enough to answer these, we can proceed to the next step of the investigation

By the way, I was assuming the sample script you gave was
just a sample and not the real thing. If that was the real thing,
then it doesn'r look like much either.

Sorry I wasn't clear on that.