10 More Discussions You Might Find Interesting
Right I have a MYSQL database with table1 with 3 columns, colA, colB and colC. I want to combine the data in the 3 columns into a 4th column names col_comb. Here's the SQL command that works:
UPDATE table1 SET `col_comb` = CONCAT( `colA` , ' - ', `colB` , ', ', `colC` );
So now I want this... (5 Replies)
Discussion started by: barrydocks
So I have a php web application that allows updating of records. I would like to track the changes of only the fields that have changed. There are plenty of how to's that involve recreating the original row in a separate table with an additional time/date stamp column but I think this is a big... (1 Reply)
Discussion started by: barrydocks
3. Shell Programming and Scripting
I need to update the value in config.txt value using shell script
lets say a value in config.txt file is as SEQUENCE=1
after some iteration as the loop ends , the SEQUENCE should get update in the config.txt file with a new value of SEQUENCE=2.
also , can anyone please help me... (7 Replies)
Discussion started by: ravidwivedi2288
4. Shell Programming and Scripting
I want a script , which searches the log for the term/phrase "JFSnapshotService::systemSnapshot: Starting data capture. This may take awhile depending upon system workload." and if there is some logging like this, it has to mail me that this data capture process is happening.,
Below is... (2 Replies)
Discussion started by: cratercrabs
5. Shell Programming and Scripting
Is ther any way to write the script with source trigger ?
To trigger the script on particular time we have crontab.
Similarly in a path, when a file comes particular script has to run.
Thanks:) (7 Replies)
Discussion started by: jesu
6. UNIX for Dummies Questions & Answers
I have to write a script to compare the sum of the amount fields in a source file and the amount field in another file.
based on the name of the source file (say SALES as an example), a file already available in a path will be grabbed (say SALES_ParmFile) and this file... (4 Replies)
Discussion started by: vijaylak
7. UNIX for Dummies Questions & Answers
I have a file in my unix directory called "restart_job1.job". Below is a sample of the script where I am doing a 'grep' to check specifically for an oracle error. If the value 'ORA-" is found, I set a variable to hold the return code value (job1_return_code). If the return code is non zero, I... (2 Replies)
Discussion started by: ncsthbell_dr
8. UNIX and Linux Applications
i hope i am posting this /beginner) question in the right forum:
i want to create an update trigger, which rolls back a transaction if a record of a table is updated. the table has - amongst others - a field 'statusid' - if a record in this table has the statusid X and it is attempted... (0 Replies)
Discussion started by: kalinkula
9. Shell Programming and Scripting
We had a requirement like we should find the user whoever logged into sqlplus through UNIX automatically.
For that we should write a script and store the result in file.
we will get that user manually by using WHO command.
can anybody help me how to trigger?
I tried many commands beyond... (1 Reply)
Discussion started by: siri_886
10. UNIX for Dummies Questions & Answers
I need to send a file from a Unix box to a Windows sever to kick off a Crystal Reports job.
Any good ideas how to do this? Can it be done with FTP? (0 Replies)
Discussion started by: robw95