Search results for query: *

Hi there.. We have a couple of filesystems that have been converted from UFS to VXFS. I was wondering whether there is any way to convert the VXFS filesystems back to UFS without having to copy out all the files in the VXFS filesystem and copying them back into a UFS filesystem. Is there any...

Hi there, I have configured 2 servers running on Solaris 2.6, one as a ntp server and one as an ntp client pointing to the server. The thing is, when i first started up the ntp daemons on the server and then the client, the time on the client server synced with the time of the my ntp server...

Hi there, I have a filesystem that was converted from ufs to vxfs using the veritas file system converter vxfsconvert. How do i undo the conversion to convert back from vxfs to ufs file system? Thanks JD

Hi there. I have a one instance running Oracle 816 32 bit and one disk with all the data in it. I also have another instance on another server running 817 64 bit. Both the databases are the same (table spaces/ tables etc etc). So i was wondering whether i can just take the disk form the 816 32...

Hi there... I currently have a perl script. I was wondering whether it was possible for me to include into the script the environment variables in my unix .profile file into the Perl script. The reason for this is, i need the cron job to run the script automatically every day. But when the cron...

Hi there, How can i compare the number of rows in two files (UNIX)? Basically what i need to do is: if (compare number of rows ('file1', 'file2')==0) { do something; } so is there any way to do the comparison of the two files to see whether they have the same number of rows? TIA JD

Hi there again.. Another question I have a script that runs 3 seperate scripts like below: script1.sh & script2.sh & script3.sh & it pushes it all to the background. I need to run a script script4.sh that would start after ALL THREE scripts script1.sh script2.sh and script3.sh has been...

Hi there.. I was wondering whether anyone can help me here.. I have ten files which is divided into two groups IN and OUT the format of the files are rraIN, rraOUT, rrkIN, rrkOUT, szrIN, szrOUT..... where the first 3 letters are in a list in another file list.txt which lists rra rrk szr...

Hi there.. ANybody knows how to select a random row from a table? The table has a key, but the key's number jumps occasionally so i couldnt use like below: select convert (int, max(key) * rand()) for a random key, as it will sometimes give out a null number So anybody can help me here...

Hey there.. Basically, as the subject says, my cursors in my stored procedures return the last row of its resultset twice. I was wondering why this is happening. Heres a basic structure of my cursors. Am i doing anything wrong here? create proc check_no_letter_type as begin declare @ltr_type...

Was wondering whether anyone can help me with this.. I have two tables A and B and one of the columns is an account_id. What i need to do is to check whether the account_id in table B is in table A. If it is, update a column called status to ACTIVE. If the account isnt in table A, then update...

Hi there... How do i run 3 different processes in a row and then run a 4th process once all three before have finished. Something like: `p1 &`; `p2 &`; `p3 &`; (Once p1, p2 and p3 has finished){`run p4`;} TIA JD

Hi there simple question Is there any way to generate a script to recreate all the stored procs that are in the database? I have tried using the syscomments table, but the text field truncates the stored proc as it is only varchar 255 What i need is to generate a script that would look...

Hi there.. I was wondering whether it is possible to insert into a table in Sybase from an MS Excel spreadsheet.. basically i have two tables, one in Excel and one in Sybase like below: Excel_table account amount 1000 25 1002 77 ..... sybase_table account...

Hi There, Can any one tell me how to call One sql file from another sql file. In mySql I used to do this by calling like "Source --.sql"

Hi there.. Was wondering whether anyone can help on a simple (i hope) SQL problem here i have 4 tables, tablea | tableb | tablec idx1 value | idx2 idx1 | idx3 idx2 1 ab | 22 1 | 444 22 2 bc | 33 2 |...

Hi there.. One simple question here. How do i pass a variable into a perl script? Eg.. at the prompt, i want to type $scriptname var1 var2 var3 and then in the script.. #!/usr/bin/perl print var1; print var2; print var3; Thanks JD

Hi heres a 'lil piece of code, do { open(IN, &quot;/home0/script/update_proc_out.sql&quot;); foreach $item (<IN>){ # Visit each item in turn # and call it $item if($item =~ /procs/){ foreach $line ($item){...