Solved

need some idea of adding sequel  statements

Posted on 2013-05-21
10
207 Views
Last Modified: 2013-06-27
Hello,

I need some idea where I need to append a stored procedure with some select statements everytime I get a new request and once I add the procedure should have all the ones I added till now, those are all select statements with unions etc

I can describe in detail but am trying luck just like this as of now
0
Comment
Question by:welcome 123
  • 3
  • 2
  • 2
  • +2
10 Comments
 
LVL 41

Expert Comment

by:Sharath
ID: 39185906
Can you explain your question in detail? May be you can explain with some examples.
0
 
LVL 38

Accepted Solution

by:
Gerwin Jansen, EE MVE earned 500 total points
ID: 39185955
Like calling your procedure with a select statement that gets stored in a table for that procedure and where the procedure is calling a 'join' of each stored select statement?

in pseudo code:

yourProc ('some select statement')
begin
  if supplied statement not in table with select statements
    insert supplied statement into table
    concatenate select statement(s) from table into sql statement
    execute sql statement
end;
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 39208857
Your requirements are not clear:

I need some idea where I need to append a stored procedure with some select statements
-- Append where? from where? to what?
...everytime I get a new request
-- From what source? what request?
and once I add the procedure should have all the ones I added till now, those are all select statements with unions etc
-- What does this mean?

You need to post examples of source and expected results, etc...
:p
0
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

Author Comment

by:welcome 123
ID: 39239014
I aplozise for the delay let me ask a part of my issue:

I have a stored procedure which has a set of sql statements and every time I get new data I add some extra sql statements to that procedure and run and replace some values in those insert statements and now I have to automate the entire process so in this context should I add a table and have all values stored there and have a unix script to read and pass values to the stored procedure ? or is there a better way to do in informatica?
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 39239223
If you have the money to license Informatica -- go for it!
Otherwise you could put the new data in a text file and load using SQL*Loader or External table.
0
 

Author Comment

by:welcome 123
ID: 39242853
how will you do it in informatica?
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 39245183
You have not responded to my questions:
1) How/from where do you "get new data".
2) What is that you "add some extra sql statements to that procedure" What does this mean?
3) What does "run and replace some values in those insert statements"?

If you have Informatica license, you would know what to do -- why do you ask?

This whole process could be summarized as follows:

1.- You have (need) a source for the data in an "electronic" format (spreadsheet, text file, another database, etc...

2.- You create the data mapping and transformations from source to target

3.- You set the sequence of tasks

4.- You schedule the job

;)
0
 
LVL 5

Expert Comment

by:magento
ID: 39261830
You can use HERE DOC

isql -Uuser -Ppass -Hserver << EOF

**sql here

EOF

BR,

Magento
0
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 39262001
@magento - Your suggestion does not match the question that is asked here...
0
 
LVL 5

Expert Comment

by:magento
ID: 39264921
Gerwinjansen,

Apologies, in that case .

BR,

Magento.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ROBOFTP UNZIP 1 59
AWK Code gives empty file, why? 12 47
Interactive Powershell script to reset password age in AD 4 53
powershell automatic variable for results 21 13
How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
Learn the basics of modules and packages in Python. Every Python file is a module, ending in the suffix: .py: Modules are a collection of functions and variables.: Packages are a collection of modules.: Module functions and variables are accessed us…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question