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!!!

Hi, Thanks again, One reason I need to send the result out to DOS, because I am performing several other steps, like manipulating a dos file etc based on this SQL result. So I send the SQL to ORACLE and if the todays date fall into the date between the date stored on my ORACLE table then I...

Hey Thanks a lot! My problem is, I can not create any procedure in that db. So I have got to check this with plain SQL. Can I use Case statement? Also how do I get the status to DOS? Many Thanks!!!

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

Thanks. Will the diff command identify all the changes in fields on the file? I think it will certainly get the new data. Say, values in this file: Key Name Address 1234 Some Name Address1 Changed to: Key Name...

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

Where can I learn about 'AWK' ?

Hi PHV! This 1 line get me the script name and the return code: ---------------------------- grep 'return code' * |more ---------------------------- The result looks like this: dddd0208_01: *** RC (return code) = 0 rrrr0209_01: *** RC (return code) = 0 ssss0210_01: *** RC (return code) = 0...

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...

Here is the code: Private Sub Command1_Click() num1 = InputBox("Please enter number 1:") num2 = InputBox("Please enter number 2:") 'Static STR_IN As String * 10, STR_OUT As String * 20 'Rem Pass lengths of string arguments Call total1(num1, num2, total) TextBox1.Text = total End Sub...

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

Thanks but my question is, why the 'more' command would change the case inside a variable and how to prevent it? Thanks again!

Hi there, Here is my script: for MYTEXT in $CODE Q1 do more $MYTEXT 1>> $TEMP_FILE more L1 1>> $TEMP_FILE done THANX

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