Sponsored Content
Top Forums Shell Programming and Scripting How to call shell script from db2 triggger Post 302449105 by frank_rizzo on Saturday 28th of August 2010 12:51:25 PM
Old 08-28-2010
create an external stored procedure and call it from that. You will need to use a language like C or Java.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to connect to database db2 through Unix Shell Script

I am trying to connect to database db2 through shell script. The process I am trying is > db2 It gives me error Access Denied. While checking for access I have the rights. Is there ant other way round..? Please help. (3 Replies)
Discussion started by: ankitgupta
3 Replies

2. Shell Programming and Scripting

How to connect DB2 table using shell script

Hi All, I want to connect two tables in DB2 using shell script and then compare the contents of two tables field by field. Could any one please help me in connecting database tables using Unix and retriving data from the same. Thanks, Durwas (0 Replies)
Discussion started by: dtidke
0 Replies

3. Linux

How to call a DB2 SP from Solaris machine.

Hi, Can some one give me the syntax, how to call a DB2 SP from a Solaris machine. Thanks and Regards, Preetham R. (0 Replies)
Discussion started by: preethgideon
0 Replies

4. Shell Programming and Scripting

access db2 from shell script

How to connect to db2 through shell script using cygwin? (0 Replies)
Discussion started by: supriyat
0 Replies

5. Shell Programming and Scripting

Connect status of db2 in Unix shell script

Hi I am trying to connect to db2 database from Unix shell script (k shell) I need to catch the status of connect whether it is succesful or not. ---------------------------------------------------------- # Read login credentials for db2 tput clear echo "Please enter your Userid:\c"... (3 Replies)
Discussion started by: mKarri
3 Replies

6. Shell Programming and Scripting

connect to db2 using shell script

Guys, I am trying to write a shell script that connect to wcsprod database and read the query #!/bin/ksh sqlplus -s < connect to wcsprod user wcsadm using pwd > select * from catentry fetch first 1 row only with ur; databse: wcsprod user: wcsadm pwd: pwd thanks (1 Reply)
Discussion started by: skatpally
1 Replies

7. UNIX and Linux Applications

[Solved] How to connect DB2 from UNIX shell script?

Hi all, I have a requirement to connect DB2 database and do some operations and generate a report through shell script. Can anyone please tell me how can i connect DB2 from unix shell script? Thanks in ADV. (2 Replies)
Discussion started by: gani_85
2 Replies

8. Shell Programming and Scripting

Return db2 query value to shell script

Hi, Im new to DB2. I need to connect to DB2 from shell script and return the query output back to shell script variable. this is my code #!/bin/ksh db_name=db db_user=usr db_pwd=pwd db2 <<EOSQL connect to $db_name user $db_user using "$db_pwd" select count(1) from table quit EOSQL ... (3 Replies)
Discussion started by: sup
3 Replies

9. Shell Programming and Scripting

Call Anonymous block from DB2

Hi, I have a shell script and im trying to call a .sql file. The sql file has a simple Anonymous block. The code is shell script db2 -tvf query.sql the sql file contains SET SERVEROUTPUT ON; BEGIN call dbms_output.put_line( 'Hello' ); END; I get the following error BEGIN... (1 Reply)
Discussion started by: sup
1 Replies

10. Shell Programming and Scripting

DB2 in awk or PARSING VALUE in Shell Script

Guys, My Motive is, There are some View names in the file with the format of SCHEMA.VIEWNAMe, I want to read the data from file and parse it to SCHEMA and VIEWNAME and execute DB2 command to get the base Table name. I can parse easily through AWK but i could not execute db2 commands in... (1 Reply)
Discussion started by: Nandy
1 Replies
XtMenuPopdown() 														   XtMenuPopdown()

Name
  XtMenuPopdown - built-in action for popping down a widget.

Synopsis (Translation Table)
  <Event sequence>: XtMenuPopdown([shell])

Inputs
  shell     An optional argument which specifies the name of the shell to pop down.

Availability
  This action is named MenuPopdown prior to Release 4.

Description
  XtMenuPopdown  is a predefined action procedure which does not have a corresponding public C routine.  It can only be invoked from a trans-
  lation table.  If passed an argument, that argument is interpreted as a shell name, and XtMenuPopdown tries to  find	the  named  shell  by
  looking up the widget tree starting at the parent of the widget in which it is invoked.  If it finds a shell with the specified name in the
  popup children of that parent, it pops down the shell by calling XtPopdown(); otherwise, it moves  up  the  parent  chain  as  needed.   If
  XtMenuPopdown  gets  to the application top-level shell widget and cannot find a matching shell, it generates a warning and returns immedi-
  ately.  If XtMenuPopdown is called with no argument, it calls XtPopdown() on the widget for which the translation is specified.

Usage
  Note that XtMenuPopdown is an action procedure; you cannot call it from C code.

  The action name MenuPopdown is a synonym for XtMenuPopdown.  Either action can be used to pop down menus or other popup shells.

  Popup shells can also be popped down by calling XtPopdown() explicitly, or by using the predefined callback procedure XtCallbackPopdown().

  The action XtMenuPopup can be used to pop up a spring-loaded popup from a translation table.

See Also
  XtCallbackPopdown(1), XtMenuPopup(1), XtPopDown(1), XtPopup(1), XtPopupSpringLoaded(1).

Xt - Pop Ups															   XtMenuPopdown()
All times are GMT -4. The time now is 11:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy