Link to home
Create AccountLog in
Avatar of welcome 123
welcome 123

asked on

need some idea of adding sequel statements

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
Avatar of Sharath S
Sharath S
Flag of United States of America image

Can you explain your question in detail? May be you can explain with some examples.
ASKER CERTIFIED SOLUTION
Avatar of Gerwin Jansen
Gerwin Jansen
Flag of Netherlands image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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
Avatar of welcome 123
welcome 123

ASKER

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?
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.
how will you do it in informatica?
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

;)
You can use HERE DOC

isql -Uuser -Ppass -Hserver << EOF

**sql here

EOF

BR,

Magento
@magento - Your suggestion does not match the question that is asked here...
Gerwinjansen,

Apologies, in that case .

BR,

Magento.