Inserting data through routines in database

poorna.ds · Post by **poorna.ds** » Thu Jan 29, 2009 8:30 am

Can we insert data into any database through routines in server jobs?

chulett · Post by **chulett** » Thu Jan 29, 2009 8:53 am

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.

poorna.ds · Post by **poorna.ds** » Thu Jan 29, 2009 9:02 am

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?

chulett · Post by **chulett** » Thu Jan 29, 2009 9:04 am

Search for "BCI" here and make sure you understand the licensing issues that it brings to the table when you go through those posts.

mk_ds09 · Post by **mk_ds09** » Thu Jan 29, 2009 9:17 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Jan 29, 2009 3:02 pm

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.