11-10-2010
Well if the record value is greater than the field size, its certainly not a shell issue but more a DB issue...
I see no other alternative but to do a query to delete the record (or correct it...).
How did it get there in the first place?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi...
I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies
2. Shell Programming and Scripting
Hi All,
In my script i am using data from oracle table for validation.
#!/bin/sh
export UID=dun_ind
export PWD=`getID dun_ind`
fed_ctrl=`sqlplus -s $UID/$PWD@lms <<END
set feedback off;
set heading off;
select sta from controls where sta = 'ABC';
EXIT;
END`
echo $fed_ctrl... (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies
3. Shell Programming and Scripting
Hi
I need help on this. Its very urgent for me.. please try to help me out..
I have data in tables in DB2 database. I would like to export the data from DB2 tables into a text file, which has to be space delimited. so that I can carry out awk, grep operations on that file. I tried to export... (2 Replies)
Discussion started by: ss3944
2 Replies
4. Shell Programming and Scripting
Hi All,
I have list of 100 table names in a file, how to read table name from and pass to DB2 export command and run for all tables in loop.
Please help me with script.
db2 EXPORT TO ~/data_export/<table name from file>.ixf OF IXF MESSAGES messages.txt "SELECT * FROM ITG.<Table Name... (4 Replies)
Discussion started by: srimitta
4 Replies
5. Shell Programming and Scripting
All,
While executing the bellow commnad after the sed, awk command to export the value to, i am getting the fallowing error.
line="_AABBB.EEEEEEE.LOG4JDISPLAY.PATH_=/apps/opt/abcde/pdstdsd/esapp/apadsfasdf/logadsfasdf.xml"
keystring=`echo $line | awk -F"=" '{ print $1 }'`... (1 Reply)
Discussion started by: jothi basu
1 Replies
6. Shell Programming and Scripting
I have having a heck of a time figuring this out so any help is much appreciated.
Here is the code where it seems to be dying, I bolded the part it is complaining about:
$sth = $dbh->prepare( $query ) or die "error with query\n";
$sth->execute() or die "error executing query ...\n";
while(... (1 Reply)
Discussion started by: savigabi
1 Replies
7. Solaris
A backup/clone script of ours was recently ran. It normally only clones the rpool and renames in rpoolA. Something must've changed as it found another one of our pools that it shouldn't have. It exported that pool unbeknownst to us. Later on when a coworker realized the other pool was missing he... (2 Replies)
Discussion started by: beantownmp
2 Replies
8. Homework & Coursework Questions
Hi Guys,
I Just wanted your opinion/ suggestion/ Help on my unix script about db2 export data with deli file and import into oracle.
db2 connect to Tablename user id using psswrd
db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/AAAAA.DEL' OF DEL select * FROM AAAAA"
db2 "EXPORT TO... (3 Replies)
Discussion started by: Sonny_103024
3 Replies
9. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
is this enough to make the data perfect export into delimited file? there are some posted that i read, they... (9 Replies)
Discussion started by: Sonny_103024
9 Replies
10. Shell Programming and Scripting
I have a shell script main.ksh We are calling dbscript.ksh from main.ksh
I am using select statement in dbscript.ksh but there is a problem with the select statement in dbscript.ksh but still echo $? is showing as zero. I am using DB2 commands in dbscript.ksh
Main.ksh
dbscript.ksh
echo $? ... (13 Replies)
Discussion started by: vamsi.valiveti
13 Replies
LEARN ABOUT HPUX
root_geometry_manager
root_geometry_manager() root_geometry_manager()
Name
root_geometry_manager - Shell class method called to negotiate shell geometry requests with a window manager.
Synopsis
typedef XtGeometryResult (*XtGeometryHandler)(Widget, XtWidgetGeometry *,
XtWidgetGeometry *);
Widget w;
XtWidgetGeometry *request;
XtWidgetGeometry *geometry_return;
Inputs
w Specifies the shell widget making the request.
request Specifies the requested geometry.
Outputs
geometry_return
Specifies the reply geometry.
Returns
The window manager's reply: XtGeometryYes, XtGeometryNo, XtGeometryAlmost, or XtGeometryDone.
Availability
Release 4 and later.
Description
The root_geometry_manager() method is registered on the root_geometry_manager field of a ShellClassExtensionRec structure with record_type
NULLQUARK, which is itself registered on the extension field of the Shell class part structure. The root_geometry_manager() method will be
called when a shell widget calls XtMakeGeometryRequest() or XtMakeResizeRequest(), and should negotiate the requested size with the window
manager.
The arguments to this method are the same as those passed to the geometry_manager() method. The root_geometry_manager() method should pass
the geometry request on to the window manager. If the window manager permits the new geometry, the root_geometry_manager() should return
XtGeometryYes; if the window manager denies the geometry request or it does not change the window geometry within some timeout interval
(the XtNwmTimeout resource for WMShell, for example), the root_geometry_manager() should return XtGeometryNo. If the window manager makes
some alternative geometry change, the root_geometry_manager() method may either return XtGeometryNo and handle the new geometry as a
resize, or may return XtGeometryAlmost in anticipation that the shell will accept the compromise. If the compromise is not accepted, the
new size must then be handled as a resize.
Communication with a window manager is an asynchronous process, but the root_geometry_manager() procedure must return its answer syn-
chronously. It will have to issue its request and then block until the reply arrives.
The root_geometry_manager() method is not chained. It can be inherited by specifying XtInheritRootGeometryManager in the Shell extension
record. If there is no Shell extension record with record_type equal to NULLQUARK, then the Intrinsics will behave as if an extension was
specified with XtInheritRootGeometryManager.
See the Inter-Client Communications Conventions Manual for information on communicating with window managers. See geometry_manager(4) for
a description of the structures and the possible return values of this method.
Usage
The root_geometry_manager() method of the Shell class itself handles communication with ICCCM-compliant window managers. It sets the
appropriate properties to make the geometry request, then uses XCheckIfEvent() to block until an ConfigureNotify event arrives in reply.
This method also uses private functions internal to the Intrinsics in order to correctly handle the events. Because of the complexity and
implementation-specific nature of this method, classes that want to define a custom root_geometry_manager() method should make their
requests to the window manager, and then call their superclass's method to make additional requests, block, and get the response.
See Also
XtMakeGeometryRequest(1), XtMakeResizeRequest(1),
Shell(3),
geometry_manager(4).
Xt - Intrinsics Methods root_geometry_manager()