Sponsored Content
Top Forums Shell Programming and Scripting Execute stored procedure through script in sybase database and store the output in a .csv file Post 302435566 by amit.mathur08 on Wednesday 7th of July 2010 04:36:16 PM
Old 07-07-2010
Question

Hi.
Thanks for your reply but I donot have a single statement rather I need to execute the procedure and need to put output into a .csv file.
Also, let me know how I can pass the parameters also through unix script in for sybase database.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Execute an Oracle stored procedure from a shell scrip

Here is a snippet of my code: if then echo "\n Deleting all reports older than 24 hours. \n" >> $logfile ls -l $FileName >> $logfile ... (1 Reply)
Discussion started by: mh53j_fe
1 Replies

2. UNIX for Dummies Questions & Answers

execute store procedure

Hi, can someone point out the tutorial or syntax for how to execute store procedure through shell scripting . thanks. (7 Replies)
Discussion started by: epall
7 Replies

3. Shell Programming and Scripting

How to compile a stored procedure that is there with in a script file(.sql) in unix

Hi, How can i compile the procedure code that is there in a script file (.sql) in unix. (0 Replies)
Discussion started by: krishna_gnv
0 Replies

4. Shell Programming and Scripting

how to store the return values of stored procedure in unix shell script.

hi i am calling a oracle stored procedure(in the database) from unix shell scripting (a.sh). the called stored procedure returns some values through OUT variables i want to assign the return values of stored procedure in to unix shell script variable. can you provide me the code. ... (1 Reply)
Discussion started by: barani75
1 Replies

5. Shell Programming and Scripting

Call and redirect output of Oracle stored procedure from unix script

Hi, Can you assist me in how to redirect the output of oracle stored procedure from unix script? Something similar to what i did for sybase isql -U$MYDBLOG -D$MYDBNAME -S$MYDBSVR -P$MYDBPWD -o$MYFILE<< %% proc_my_test 8 go %% Thanks in advance - jak (0 Replies)
Discussion started by: jakSun8
0 Replies

6. Shell Programming and Scripting

How to execute the stored procedure from shell script

How to execute the stored procedure from shell script and is there any possibility to print the dbms output in a log file. (2 Replies)
Discussion started by: dineshmurs
2 Replies

7. Shell Programming and Scripting

Shell Linux to connect to a database and execute store procedure

HI, i want to write a script (Linux) that: 1) connect to a database oracle 2) execute some store procedure. Can anybody help me, please? Thanks a lot Andrew (3 Replies)
Discussion started by: manichino74
3 Replies

8. Shell Programming and Scripting

Unable to execute Stored Procedure from CRON

Hi, I am very new to this environment - I hope this is the right platform to discuss my issue: I created a CRON job to run a Stored Procedure from our database - Sybase. Within the Stored Procedure there is a TRUNCATE table and CREATE table function. the CRON job fails to run with... (2 Replies)
Discussion started by: pizzazzz
2 Replies

9. Shell Programming and Scripting

ksh and Oracle stored procedure output in logfile

Friends, I pass some runtime arguments (date, number) through ksh script to Oracle procedure, use input value and pass it on to procedure. Oracle procedure gets input value, run query and logs everything in the logfile. I'm facing with couple of challenges 1. Even though I pass all... (5 Replies)
Discussion started by: homer4all
5 Replies

10. How to Post in the The UNIX and Linux Forums

Calling a Sybase Stored procedure from a UNIX Script

Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File.somehow i try to find a solution but whwn i try to run the script i am not getting the output file with... (1 Reply)
Discussion started by: Arun619
1 Replies
acctdisk(8)						      System Manager's Manual						       acctdisk(8)

NAME
acctdisk, acctdusg - Perform disk-usage accounting SYNOPSIS
acctdisk acctdusg [-u file] [-p file] FLAGS
Searches file as the alternate file for login names and numbers, instead of searching /etc/passwd. Writes records of file names for which it does not charge into file. DESCRIPTION
Normally the acctdisk and acctdusg commands are called from the dodisk shell procedure to do disk-usage accounting. The dodisk shell proce- dure is invoked when the cron daemon executes commands in the /usr/spool/cron/crontabs/[filename] file. In the usual case, the output of the diskusg command is the redirected input to the acctdisk command. When a more thorough, but slower, version of disk accounting is needed, specify the -o flag with the dodisk command. This is not normally done in the /usr/spool/cron/crontabs/[filename] file. When the -o flag is used, the acctdusg command replaces the diskusg command. acctdisk Normally, the acctdisk command reads a temporary output file produced by the diskusg or the acctdusg command from standard input, converts each record into a total disk-accounting record, and writes it to standard output. These records are merged with other accounting records with the acctmerg command to produce a daily accounting report. acctdusg The acctdusg command is called when the -o flag is used with the dodisk command. This produces a more thorough, but slower, version of disk-accounting records. Otherwise, the dodisk shell procedure invokes the diskusg command. The acctdusg command reads a list of files from standard input (usually piped from a find / -print command), computes the number of disk blocks (including indirect blocks) allocated to each file divided by the number of hard links then writes an individual record for each user to standard output. To find the user who is charged for the file, compare each file pathname with the login directories of the users. The user who has the longest pathname component match is charged for the file. Therefore, the relevant information for charging users is not ownership of a file but the directory where it is stored. The acctdusg command searches the /etc/passwd file, or the alternate password file specified with the -p flag, for login names, numbers and login directories. Each output record has the following format: uid login #blocks EXAMPLES
To start normal disk-accounting procedures, add a line similar to the following to the /usr/spool/cron/crontabs/[filename] file: 0 2 * * 4 /usr/sbin/acct/dodisk The foregoing example is a typical, periodically invoked command that the cron daemon reads and executes. The period is expressed by a 6-field entry having the format: mm hh daymon monyr wkday cmd. For any field requiring digits, numbers are integers. These six fields have the following significance: Purpose Time variable that has the value 0 through 59 expressing minutes past the hour. Time variable for the hour of the day in 24-hour clock notation. Time variable for the day of the month. Time variable for month of the year. Time variable for the day or days of the week, where 0 is Sunday and inclusive days are separated with a hyphen (-). Command the cron daemon must execute. Whenever you write any of the time variables described in the foregoing table, an unspecified value must be noted with an * (aster- isk) to define an empty field. In the foregoing example, the dodisk shell procedure runs at 02:00 hours (2) every Thursday (4). The dodisk shell procedure calls the acctdusg command to redirect its input to a temporary file and then calls the acctdisk shell procedure to redirect disk-usage records from the temporary file as input to a /var/adm/acct/nite/[filename] file as output. The file stored in the /var/adm/acct/nite subdirectory is a permanent binary record of disk usage for the specified period. To initiate a slower, more thorough disk-accounting procedure, add a line similar to the following to the /usr/spool/cron/crontabs/[filename] file. 0 2 * * 0-4 /usr/sbin/acct/dodisk -o The dodisk shell procedure calls the acctdusg command and the acctdisk command to write disk-usage records to the /var/adm/acct/nite/[filename] file just as in the previous example. The dodisk procedure runs at 2 a.m. every day (0-6) including Sunday. FILES
Specifies the command path. Specifies the command path. User database file. The active login/logout database file. Accounting header files that define formats for writing accounting files. RELATED INFORMATION
Commands: acct(8), acctmerg(8), cron(8), diskusg(8), dodisk(8), runacct(8) Functions: acct(2) delim off acctdisk(8)
All times are GMT -4. The time now is 09:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy