Search results for query: *

I am using perl DBI module to get data back from database in array format. The code I have so far looks like this: $rows = $dbh->selectall_arrayref("show SELECT * FROM table SAMPLE 3"); foreach $h (@$rows) { foreach $x (@$h) { printf "%s\n", $x; }} After I put a break in...

Hi Gurus! I am trying to capture a SQL result that is runing/coming from SQLPLUS onto a global variable. I need to read this variable from DOS. Any help is appreciated!!!

I have got two dates in a table and I need to comapre if today's (system date) falls between the two date field. I am thinking to use sqlplus.... What would be the best way to send a quary to ORACLE and come back with a return code in DOS. What I want some thing like this: CHECK DAte: If...

Hi Gurus! I am trying to load a Flat File where I need to combine two fields to one. Here is the file fomat: Last_Name position (1:20) First_Name position (100:20) I am loding into a name field that is 50 char and I need to add Last_Name || First_Name So what is the way to write my control...

Hi Gurus! What is the best way to comapre two tables (All the fields ) and determine the changes? Note I have got both table same structure, only difference in Data. TIA

All, I am trying to come up with a process of identifying the difference between two files that are extracted from ORACLE. The issue is, there is no date when file A is extracted. After a week or so, this is file is extracted again. What I want to do , is to identify the deltas. What is...

Hi I am using k shell and and one of my shell script calls some 100 scripts. What would be the best way to calculate the Total time it took to finish all the script? Can I use the 'time' command? Any other way? Any sample script is appreciated. Thanks

Hi, I got a report dir and under that I got different sub folder. The sub folders have diferent reports and all the report files have a return code value (0--10, 0 stands for no error). What I want to do is to scan all reports and count the error code by sub dir and finally display or email me...

Please some one help me: I made a fortran dll and am trying to call it from a VB (6) program and am getting the following Runtime error (455): Can't Find DLL entry point DLL_OUT in C;\test\file.dll What am I missing>? Here is the code: Private Sub Command1_Click() num1 = InputBox("Please...

Please some one help me: I made a fortran dll and am trying to call it from a VB (6) program and am getting the following Runtime error (455): Can't Find DLL entry point DLL_OUT in C;\test\file.dll What am I missing>? Here is the code: Private Sub Command1_Click() num1 = InputBox("Please...

Please some one help me: I made a fortran dll and am trying to call it from a VB (6) program and am getting the following Runtime error (455): Can't Find DLL entry point DLL_OUT in C;\test\file.dll What am I missing>? Thanks

I have a shell script that loops through a file and I have got 'more' command to generate another file. For some reason, the more command change the text to lower case! How can I prevent this? Any idea? I am using Korn shell in AIX. Thanks a lot

I would appreciate if some one can point me to the right direction... I am trying to automate an email process as follows and that works fine: #!/bin/ksh echo "This is a Test mail" recepient="root" echo $recepient echo "Job completed okay" | mail $recepient echo...

Greetings! I am trying to execute one korn shell script through crontab, and scheduler. The crontab runs my script okay. The way it is set up is, the script is a korn shell script that basically calls another korn shell script. When It is run, instead it doing what it is supposed to do on the...

I got a data file and I want to display the n'th record say line number 500 from it. How should do this? TIA

I am thinking to write a program in UNIX that can use the ODBC and connect to a remote database and extract data (or generate a quiery that brings results back to host machine).. Can any one point me to the right direction? Any sample/script will be helpful. Note my source is ORACLE database...

I would appreciate if some one , helps me /post sample code on this: I have got two nodes/treeview that displays tables and column info from a db. I want to select the tables to draw relationship between them. Say, I got a table A that is related to table B and C, so I need to draw lines or...

I got a data file that contains an "x". I need to know what number that is nth record number that got this "x" what would be the easiest way to do this? I also need to know, if I want to see the "n"th row how to display this? TIA

I have got a data file and I want to delete first 100 rec from it or read the 101 record.... What would be a quick way to do this? The file is huge... TIA

I have got two datasets tht displays records in two different Treeviews. Now Can I map that is either marge or draw lines between the two treeviews in some way so that I can marge the two treeviews. My treview1 got list of tables in db1: A, B, C My treeview2 got list of tables in db2: A,A...