Generic script for Querying a DB Post: 302530336

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to transfer files (By using generic script) when using sftp

I have written generic script to transfer files from one machine to other machine(By passing the command line arguments like server name, user name ,location of the files, file names etc) but when i am using sftp, what are the things I have to specify in the code Is it necessary to specify...

2. Shell Programming and Scripting

Connecting and Querying DB2 database from Unix Script?

I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If...

3. HP-UX

Querying HP VA array

Hello, all... I've got an older HP-UX 11i machine hooked up to an HP VA array. I've never worked with VA arrays, so I was wondering if anyone could point me in the direction of some documentation on querying and manipulating VAs (HP VAs for Dummies or something). I'm used to EMC arrays, so...

4. Shell Programming and Scripting

Generic Shell Script to Archive a file

Would appreciate if any one can paste a generic schell script to archive a file with date stamp by passing the file with fullpath as parameter For Eg. /apps/scripts/Archive_File.sh /data_home/project_home/file.txt this should place the file in the following directory ...

5. Shell Programming and Scripting

ksh script to create a generic csv file from different source formats

Hi all, I have a requirement to create a "superset" file out of a number of different sources with some different and some same columns. We intend to have a manually updateable SuperSetCols.csv which would look like "ColA","ColB","ColC","ColD","ColE","ColF","ColG" so someday we may add...

6. Shell Programming and Scripting

generic sftp script creation

I am trying to work out if it is possible to create a generic scrip which will allow sftp to be run for connecting to a host machine based on a parameter and to retrieve files based on a batch file. The batch file bit I am fine with, I can make that work. The are I'm not so sure about is how to...

7. Shell Programming and Scripting

Required help on a Generic File-watcher script

Hi All, Good morning... I have prepared a shell script which will monitor files in a certain folder and if available, SCP it to a destination path. Now the challenge I'm facing is my script is currently SCP-ing to only a single destination path. Wherever different destination path is in...

8. Shell Programming and Scripting

Generic script to recursively cd into directories and git pull

Hi all, I'm trying to write a script to recursively cd into my Git projects and pull them, and will later expand it to build my projects as well. I'm having a bit of trouble with my current script, as I want to supply a command line argument to tell it which branch to check out. I can hard...

9. UNIX for Beginners Questions & Answers

Generic script to load file details(ls -ltr) in to a database.

All, I am trying to create a report on the duration of an ETL load from the file arrival to the final dump in to a database for SLA's. Does anyone have any guidance or ideas on how metadata can be extracted; information of a file: like file name, created timestamp, count of records and load...

LEARN ABOUT FREEBSD

nisplus_table

NISPLUS_TABLE(5)						File Formats Manual						  NISPLUS_TABLE(5)

NAME

       nisplus_table - Postfix NIS+ client

SYNOPSIS

       postmap -q "string" "nisplus:[name=%s];name.name."

       postmap -q - "nisplus:[name=%s];name.name." <inputfile

DESCRIPTION

       The  Postfix  mail  system uses optional lookup tables.	These tables are usually in dbm or db format.  Alternatively, lookup tables can be
       specified as NIS+ databases.

       To find out what types of lookup tables your Postfix system supports use the "postconf -m" command.

       To test Postfix NIS+ lookup tables, use the "postmap -q" command as described in the SYNOPSIS above.

QUERY SYNTAX

       Most of the NIS+ query is specified via the NIS+ map name. The general format of a Postfix NIS+ map name is as follows:

	   nisplus:[name=%s];name.name.name.:column

       Postfix NIS+ map names differ from what one normally would use with commands such as niscat:

       o      With each NIS+ table lookup, "%s" is replaced by a version of the lookup string.	There can be only one "%s" instance in	a  Postfix
	      NIS+ map name.

       o      Postfix  NIS+  map  names  use  ";"  instead  of	",", because the latter character is special in the Postfix main.cf file.  Postfix
	      replaces ";" characters in the map name by "," before making NIS+ queries.

       o      The ":column" part in the NIS+ map name is not part of the actual NIS+ query. Instead, it specifies the number of the  table  column
	      that provides the lookup result. When no ":column" is specified the first column (1) is used.

EXAMPLE

       A NIS+ aliases map might be queried as follows:

	   alias_maps = dbm:/etc/mail/aliases,
	       nisplus:[alias=%s];mail_aliases.org_dir.$mydomain.:1

       This queries the local aliases file before the NIS+ file.

SEE ALSO

       postmap(1), Postfix lookup table manager

README FILES

       Use "postconf readme_directory" or "postconf html_directory" to locate this information.
       DATABASE_README, Postfix lookup table overview

LICENSE

       The Secure Mailer license must be distributed with this software.

AUTHOR(S)
       Geoff Gibbs
       UK-HGMP-RC
       Hinxton
       Cambridge
       CB10 1SB, UK

       Adopted and adapted by:
       Wietse Venema
       IBM T.J. Watson Research
       P.O. Box 704
       Yorktown Heights, NY 10598, USA

       Wietse Venema
       Google, Inc.
       111 8th Avenue
       New York, NY 10011, USA

																  NISPLUS_TABLE(5)