hi all
please tell me how to pass parameters 4m shell script to a DataBase stored procedure.
To be specific i have sybase DB.
i mean i want the syntax of the command..
how to connect to DB, pass user id and password, pass the required parameter to SP..
..
need ur help frnds..
hema (0 Replies)
Hi one help,
I need one procedure to load data from flat file to table. Table name as input parameter for the procedure. can anyone help me
Thanks,
Raj, (1 Reply)
Hi
I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.)
I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Hi Dudes :)
I want a unix shell script to pass value to SQL stored procedure.
Below is the procedure
declare
res varchar2(10);
begin
odm_load_check('PRE_SANITY',res);
dbms_output.put_line(res);
end;
select * from error_log;
truncate table error_log;
select * from test; (1 Reply)
Hi
I am new to Unix shell scripting. But i need help to slove the below issue.
Issue description:
I want to read table, view names and package names in a file
my plan to find the table name is : search "From" key word find the table or view
To find the packge name : Search "Package... (5 Replies)
Hi,
I want to create MySQL stored procedure and call the stored procedure using perl.
I tried like this:
use DBI;
my $dbh = DBI->connect ("DBI:mysql:test",
"root", "ibab",
{ RaiseError => 1, PrintError => 0});
$create_procedure =... (5 Replies)
Hello,
I'm working with putty on Windows 7 professional and I'd like to know if there's a way to gather specific lines from a pre-existing table and make a new table with that information.
More specifically, I'd like the program to look at a specific column, say column N, and see if any of the... (5 Replies)
The db2 table stores the unix path as below
PARM VALUE
RootPath $SRootDir
Target $SRootDir/target
$SRootDir is set in the env variable as /home/test/root
In the shell script i read the table value and store it in a variable
pth=db2 -x "select VALUE from... (2 Replies)
I am new to this shell scripting....
I have a file which contains list of users. This files get updated when new user comes into the system.
I want to create script which will give a table containing unique list of users. When I say unique, it means script should match table while parsing... (3 Replies)
Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer:
<script>
$(function(){
$('tr, td, fieldset,... (0 Replies)
Discussion started by: Neo
0 Replies
LEARN ABOUT DEBIAN
ledgersmb::dbobject::account
LedgerSMB::DBObject::Account(3pm) User Contributed Perl Documentation LedgerSMB::DBObject::Account(3pm)NAME
LedgerSMB::DBObject::Account - Base class for chart of accounts entries
SYNOPSYS
This class contains methods for managing chart of accounts entries (headings and accounts).
INERITS
LedgerSMB::DBObject
METHODS
save()
This method saves the chart of accounts entry.
The hash component of the object may contain an id attribute, used to overwrite an account if that one exists.
Hash entries Used:
id: (optional): If set, overwrite existing account. accno: the text used to specify the account number description: Text to describe
the account category: A = asset, L = liability, Q = Equity, I = Income, E = expense gifi_accno: The GIFI account entry control code
heading: (Optional) The integer representing the heading.id desired contra: If true, the account balances on the opposite side. tax:
If true, is a tax account link: a list of strings representing text box identifier.
get()
This method gets a chart of accounts entry. It requires that the $account->{id} value must be properly set.
check_transactions()
Returns true if the account has transactions, false if not. Also sets the $account->{has_transactions} value to the return value.
$account->{id} must be set.
is_recon
Returns true if is set up for reconciliation. False otherwise.
delete()
Attempts to delete the account. This will NOT succeed if the account is referenced in any way by any transactions, credit accounts,
etc.
$account->{id} must be set.
list()
Returns a list of all accounts.
generate_links()
A mostly-private method for generating and checking whether link data is valid.
This is usually done (automatically) in preparation for saving the information to the database.
list_headings
Returns a list of account_heading's. No inputs required.
SEE ALSO
LedgerSMB::DBObject, LedgerSMB
COPYRIGHT
Copyright (c) 2009, the LedgerSMB Core Team. This is licensed under the GNU General Public License, version 2, or at your option any later
version. Please see the accompanying License.txt for more information.
perl v5.14.2 2012-03-25 LedgerSMB::DBObject::Account(3pm)