Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bengalliboy

    finding element data from referenced array, nested

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

    How to use global variable from SQLPLUS?

    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!!!
  3. bengalliboy

    Date range checking from DOS

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

    Date range checking from DOS

    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!!!
  5. bengalliboy

    Date range checking from DOS

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

    Concatinating two fields in SQL Loader

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

    Finding the difference between two tables

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

    difference between files (same file)

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

    difference between files (same file)

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

    difference between time to calculate execution time.

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

    Shell scaning bunch of report and doing count.

    Where can I learn about 'AWK' ?
  12. bengalliboy

    Shell scaning bunch of report and doing count.

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

    Shell scaning bunch of report and doing count.

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

    dll call problem. Urgent Help

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

    dll call problem

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

    URGENT HELP NEEDED in Calling DLL

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

    URGENT HELP NEEDED in Calling DLL

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

    more command changing text case!!

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

    more command changing text case!!

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

    more command changing text case!!

    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

Part and Inventory Search

Back
Top