Inserting data through routines in database
Moderators: chulett, rschirm, roy
Inserting data through routines in database
Can we insert data into any database through routines in server jobs?
chulett wrote:Yes, but I certainly wouldn't advise it. Far better to use a job for that and have the routine land the data in a flat file for it to load. ...
Could you tell me what would be the issue if we insert data through routine. Can you also tell me with a small example how we write the command in routine?
You can use DSExecute function to execute the command.
You can excecute the unix script using above command.
In the unix script you can your insert statements.
Routine - > DSExecute - > Unix Script - > Database inserts..
This could be one of the way doing what you want to achieve...
---------------------------
Hope this helps
-------------------------
MK
You can excecute the unix script using above command.
In the unix script you can your insert statements.
Routine - > DSExecute - > Unix Script - > Database inserts..
This could be one of the way doing what you want to achieve...
---------------------------
Hope this helps
-------------------------
MK
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Actually, Windows has far fewer licensing issues when using BCI functions because you can make the calls via the free ODBC drivers one tends to get on/for Windows systems.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.