Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

Write in DB

Hello

I have IPCC premium.

I can write variable from script to table of SQL server.

I need to activate a application immediately after i was write a variable.

How can i activate a appplication with this variable.

For axample:

I need to activate "Notepade 123456".

The "123456" is a variable that write in SQL.

Thank you.

10 REPLIES

Re: Write in DB

Where do you want to activate the application? what server or desktop?

Community Member

Re: Write in DB

I want to activate the application on different server, with operation system 2003.

Community Member

Re: Write in DB

Hi,

Well I don't understand the scenario that you have.

This link is to enable the Database Subsystem.

http://www.cisco.com/en/US/partner/products/sw/custcosw/ps1846/products_administration_guide_chapter09186a008018e98d.html#1056609

Once it's enabled and you are connected to the database you can use the DB steps to get, write , read and release the database.

Anyway, pls describe your scenario.

Omendieta.

Community Member

Re: Write in DB

Hello

I was success to write variable to DB, but i need to take this variable that write in DB and activate a application to Main Frame.

I need a trigger that activate this application when the script write in DB.

Re: Write in DB

Well, If you referring to Mainframe integration, then you need to look into Vonetix (Gold Systems) or Verastream (Attachmate). You cannot write directly to mainframe. You need to use java or http/xml to third party applications (mentioned above). The third-party applications will perform something called screenscraping to input and output data. This is the preferred method of integration to mainframe. There are some sql drivers that exist but not widely used. Don't know the names.

Community Member

Re: Write in DB

Hello

I have the application that working with Main Frame.

I need a trigger that activate this application when i write a variable in DB from script.

Re: Write in DB

What type of application is this. Is this a java based application(.class, .jar) or can you call it through http request?

Community Member

Re: Write in DB

It is application of Main Frame. it's call EntireX.

Do you know how can i trigger this application with java?

Re: Write in DB

Unless you know EntireX and what it supports, we will have no idea. Does EntireX has Java beans that you can use to open and close a mainframe session? Does it have java beans/apps to navigate to a certain mainframe screen and enter data and collect output? We don't know what EntireX. For all, it could just be a terminal emulator. You need to call EntireX or the people who know EntireX to give you more information.

Community Member

Re: Write in DB

Shaul,

would you happen to have a sample IVR script that I can review to see how to Read, Write and Relase an SQL DB?

266
Views
0
Helpful
10
Replies
CreatePlease to create content