09-30-2010
actually i have a text file(SQL and PL/SQL Code around 20000 Lines). In the file i have Table Names, Package, Procedures and Functions names.
Suppose in a query i have more than one table in From Clause i need to find first table and put in below format and second table and third table and so on.
I want separate all the object names from the file and put in a new file in a specific Format like below
<Object Name> <Schema Name>
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all ,
I am getting an error "job_procfile not found" while excecuting a .ksh script. The script is used to create control-m ( scheduler ) jobs dynamically by reading parameter files ( flat filescomma seperated )
job_procfile is a function within the .ksh script
The script is something... (8 Replies)
Discussion started by: rajesh_ramaoz
8 Replies
2. Programming
hi ,
How to view the contents of a "c" program symbol table information in unix. (1 Reply)
Discussion started by: saravanan_nitt
1 Replies
3. Programming
# include <stdio.h>
# include <fcntl.h>
# include <stdlib.h>
# include <sys/stat.h>
int main(int argc, char *argv)
{
int fRead, fPadded, padVal;
int btRead;
int BUFFSIZE = 512;
char buff;
if (argc != 4)
{
printf ("Please provide all of the... (3 Replies)
Discussion started by: naranja18she
3 Replies
4. Shell Programming and Scripting
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)
Discussion started by: easterraj
1 Replies
5. UNIX and Linux Applications
hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname'
for example
... (6 Replies)
Discussion started by: rethink
6 Replies
6. Shell Programming and Scripting
Hi ,
I Have following requirement:
DB2 Sql query to pass from a parameter file
for example, I would create a parameter file with (SELECT column 1, column 2 FROM Table name) then job would read it and create a file with the contents named table.txt
How to write/modify below ksh script to... (10 Replies)
Discussion started by: developer.dwh9
10 Replies
7. Shell Programming and Scripting
If I select the statement on db is ok, but same statement on UNIX script I get
table or view is not exist. what should I do?:( (5 Replies)
Discussion started by: Hscript
5 Replies
8. UNIX for Beginners Questions & Answers
Hi there,
I currently use the following find command to recursively search all the subdirectories in our file system for a table ( in this case BB_TENURE_DAYS)
find -type f -exec grep -l "BB_TENURE_DAYS" {} \+
So I have this so far - the problem is how do I read the line to get the... (2 Replies)
Discussion started by: rjsha1
2 Replies
9. UNIX for Beginners Questions & Answers
HELLO
I need your help please , i need to read a file that contain a table like :
Name | Status
------------------
DB 1 | UP
DB 2 | UP
DB 3 | DOWN
DB 4 | UP
DB 5 | UP
the objective to read each line and check if DB is UP or Down and give me the name of Down database.... (10 Replies)
Discussion started by: Abdellah
10 Replies
LEARN ABOUT OSX
package::constants5.16
Package::Constants(3pm) Perl Programmers Reference Guide Package::Constants(3pm)
NAME
Package::Constants - List all constants declared in a package
SYNOPSIS
use Package::Constants;
### list the names of all constants in a given package;
@const = Package::Constants->list( __PACKAGE__ );
@const = Package::Constants->list( 'main' );
### enable debugging output
$Package::Constants::DEBUG = 1;
DESCRIPTION
"Package::Constants" lists all the constants defined in a certain package. This can be useful for, among others, setting up an
autogenerated "@EXPORT/@EXPORT_OK" for a Constants.pm file.
CLASS METHODS
@const = Package::Constants->list( PACKAGE_NAME );
Lists the names of all the constants defined in the provided package.
GLOBAL VARIABLES
$Package::Constants::DEBUG
When set to true, prints out debug information to STDERR about the package it is inspecting. Helps to identify issues when the results are
not as you expect.
Defaults to false.
BUG REPORTS
Please report bugs or other issues to <bug-package-constants@rt.cpan.org<gt>.
AUTHOR
This module by Jos Boumans <kane@cpan.org>.
COPYRIGHT
This library is free software; you may redistribute and/or modify it under the same terms as Perl itself.
perl v5.16.2 2012-08-26 Package::Constants(3pm)